CODEWITHSUNDEEP
formsoracle-database
user3154699
user3154699

Reputation: 67

Oracle Forms auto query

I'm using Oracle Forms and I'm trying to auto-query data when a new form opens (that is, automatically generating SELECT * from TABLE data without clicking on "Execute Query" button from DEFAULT&SMARTBAR menu).

How can I automatically execute query when the new form opens without clicking on the Execute Query button?

Upvotes: 0

Views: 7901

Answers (1)

Tony Andrews
Tony Andrews

Reputation: 132570

You can create a WHEN-NEW-FORM-INSTANCE trigger with code like:

go_block('BLOCK1');
do_key('execute_query');

Upvotes: 2

Related Questions