Re: newbie forms question.
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