Re: Forms Builder 6.0: How to insert default values in query mode?
Date: Wed, 09 Jan 2002 22:47:30 GMT
Message-ID: <6M3%7.7099$gO5.2679924_at_news1.news.adelphia.net>
[Quoted] Sorry, I should have tried it first. Oracle Forms is not a robust tool, as you are finding out (with Delphi I know this wouldn't be a problem).
You could make it a non-database block, with non-database items. It is more [Quoted] work, but would give a better product.
"Rick E." <rickest_at_deleteme.yahooooo.com> wrote in message
news:xY2%7.1344$UR4.117536_at_newsfeed.slurp.net...
> "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?
>
> Yes, that would work although it sure sounds sloppy to me. I have visions
> of learning over a customer's desk: "No, you don't have to fill out these
> three fields. If you leave them empty, I'll put some default data in
there
> 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
> 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
> 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 - 23:47:30 CET