Oracle Forms 10g auto query

Question

I'm creating a form which is populated by a data block query.

Let's say that I had an EMPLOYEE table, with the columns "ID" and "NAME".

Select ID, NAME from EMPLOYEE;

How can I trigger this automatically when the form loads (and is there a property or trigger designed to do this?)?

Answer 1

There is no automatic way of doing this so you need to navigate to the database block (if this block is not the First Navigation Data Block of the form) and then execute the query form forms builtin Execute_Query. This can e.g. be done in form level trigger When-New-Form-Instance:

Go_Block(<name of your database block>);

Execute_Query;