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

[Quoted] Thanks for the help, Paul, but unless I'm doing something wrong PRE-QUERY [Quoted] does not fire until after Execute_Query, not in between Enter-Query and [Quoted] Execute_Query which is what I think I need. This means while the user is [Quoted] still in query mode he cannot see the default value I've added for them on [Quoted] the form and on the rare occasion that they need to do a query on something [Quoted] other than the default value, my PRE-QUERY code overrides their data entry.

• Rick

[Quoted] "Paul Quenneville" <paulq_at_rogers.com> wrote in message news:Ln0%7.7697$iM.7259_at_news1.bloor.is...
> pre-query trigger
>
> :field := value;
>
> "Rick E." <rickest_at_deleteme.yahooooo.com> wrote in message
> news:0R%_7.149$UR4.82194_at_newsfeed.slurp.net...
> > Hi all,
> >
> > Relative new-comer to Oracle Dev 6.0.
> >
> > Our database is used by our entire organization but I am developing a
form
> > that only a small subset of the whole organization will use. As such,
> when
> > my users enter query mode I would like to fill out a couple of fields on
> the
> > form for them with default, but modifiable, values. In other words, I
> need
> > a trigger that fires *after* Enter-Query and *before* Execute_Query.
> >
> > Any advice? Answers via usenet or e-mail appreciated (fix my e-mail
> address
> > first); correct answers *really* appreciated. ;-)
> >
> > - Rick
> >
> >
>
>
Received on Wed Jan 09 2002 - 20:40:00 CET