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

Hi Scott,

I sure appreciate the help. I think I'm coming to the same assessment as you regarding FB -- seems great for DB work but the windowing and normal non-DB programming is a real bear. I could switch to MSVC but then the DB work would be two or three times harder, plus I'm the only guy around that does C/C++/SDK/MFC/DAO/ODBC so the rest of the organization probably wouldn't appreciate that. Looks like FB it is, blank fields and all! :)

Still, thanks so much for trying to help!

• Rick

"Scott Mattes" <ScottMattes_at_yahoo.com> wrote:

> 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
> 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 Thu Jan 10 2002 - 17:06:23 CET