Re: newbie forms question.

From: Walt <walt_bz_at_hotmail.com>
Date: Mon, 13 Sep 1999 11:09:58 +0200
Message-ID: <37DCBF66.B54C0C3C_at_hotmail.com>


Hi

If the query is always the same or fetch all records maybe you can put in the WHEN-NEW-FORM-INSTANCE trigger (at form level) the command.

go_block('your_block_name');
execute_query;

If there's a fix where clause you can put it on the properties WHERE CLAUSE
of your block your_block_name.

bye

bubba wrote:
>
> I have a simple form setup that displays customer records.
>
> How can I pre-fetch the records without having to enter a query in oracle
> forms runtime?
>
> In other words, can i programmatically pre-load the form so that it gets the
> records i want it to when it loads up? This way I can avoid having to teach
> my users how to use oracle runtime queries.
>
> any code examples would be greatly appreciated.
Received on Mon Sep 13 1999 - 11:09:58 CEST

Original text of this message