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

[Quoted] 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?

"Rick E." <rickest_at_deleteme.yahooooo.com> wrote in message [Quoted] 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.
>
> - Rick
>
> "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 - 22:39:35 CET