Re: Forms Builder 6.0: How to insert default values in query mode?

[Quoted] "Scott Mattes" <ScottMattes_at_yahoo.com> wrote:

> Couldn't you check the value of the field in your PRE-QUERY and set it to
> your default value ONLY if it is NULL?

[Quoted] Yes, that would work although it sure sounds sloppy to me. I have visions [Quoted] of learning over a customer's desk: "No, you don't have to fill out these [Quoted] three fields. If you leave them empty, I'll put some default data in there [Quoted] the for you. What's that? What will I put in those fields if you leave them empty? Here, let me write that down on a sticky for you and put it on [Quoted] your monitor. So, how are you liking my professional software so far?" Mmmm.

Is there really no way to just enter the data for them right there on the [Quoted] form where they can see/change/delete/accept it?

Thanks for the help,
Rick

P. S. Scott, sorry about the cc to your inbox. I use XNews at home; I'm currently at work and not as familiar with OE as a news reader.

> "Rick E." <rickest_at_deleteme.yahooooo.com> wrote in message
> news:f%0%7.225$UR4.94177_at_newsfeed.slurp.net...
> > Thanks for the help, Paul, but unless I'm doing something wrong
PRE-QUERY
> > does not fire until after Execute_Query, not in between Enter-Query and
> > Execute_Query which is what I think I need. This means while the user
is
> > still in query mode he cannot see the default value I've added for them
on
> > the form and on the rare occasion that they need to do a query on
> something
> > other than the default value, my PRE-QUERY code overrides their data
> entry.
Received on Wed Jan 09 2002 - 22:53:36 CET