Re: populate a data block

Timbo wrote:

> Hi. New to Forms. Using 9i dev suite.
>
> I want to have a control block on a form where a user enters a date,
> and then run a query to populate the data block using the date
> entered from the control block as the WHERE value. The data in the
> data block is query only, the user will make a selection from the
> returned data to do something else.
>
> How do I make the control block entry populate the data block?
>
> Thanks,
>
> Tim

[Quoted] I try to keep as much code out of a form as possible. One simple way to do this is to in the validation trigger call a stored procedure in the database to populate the table. Then your code consists only of the following:

BEGIN
   back_end_proc(:block_name.date_field);    GO_BLOCK('block_name');
   EXECUTE QUERY;
END; Let the proc contain the INSERT INTO using the passed date value as a parameter to the WHERE clause.

Keeps the form leaner and faster.

Daniel Morgan Received on Fri Oct 11 2002 - 17:35:38 CEST