EXECUTE_QUERY on MASTER-DETAIL form queries wrong block

forms oracle oracle10g designer form-designer
Luceo Astrum picture Luceo Astrum · Apr 26, 2012 · Viewed 8.5k times · Source

I'm using Oracle Form Designer with a Master-Detail relationship, I have a WHEN-NEW-FORM-INSTANCE trigger which runs 'EXECUTE_QUERY;' but it is returning records from the Detail block rather than the master block. Can anyone tell me how to return records from the master block?

I have no idea what the block name is. I've tried the data block name and the title above the block and both say they are undefined.

Thanks.

Answer

GriffeyDog picture GriffeyDog · Apr 26, 2012

Precede the execute_query call with a go_block('MASTER_BLOCK_NAME') call.

Related questions

How to retain block position after a query -oracle forms

I have an oracle form with a data_block which displays 25 items. On the form I have a scrollbar and a 'delete' button. When an item in the data block is selected, and the 'delete' button is pressed, it deletes …

Read More
How can I display a dialog canvas in Oracle Forms Builder?

I have built a form in which the user can view multiple rows of data pulled from a table. The user has the option to select a row, then pressing a button to reject the data in that row, (to …

Read More
Oracle EBS .ClassNotFoundException: oracle.apps.fnd.formsClient.FormsLauncher.class ERROR

I need help in configuring Java on my machine because, when I try loading Forms, the loader just goes in circles and gives this error: java.lang.ClassNotFoundException: oracle.apps.fnd.formsClient.FormsLauncher.class at sun.plugin2.applet.Applet2ClassLoader.…

Read More