We are running into a problem for which oracle tech support does not
seem to have an answer.
We have a Master-Detail relationship form. In the WHEN-NEW-BLOCK-INSTANCE
trigger of the detail block I am executing POST built-in. Immediately after
POST I check the SYSTEM.BLOCK_STATUS and SYSTEM.FORM_STATUS varaibles.
The value for these variables is QUERY after the POST. But when I try to
use EXIT_FORM runtime asks me if I want to commit the changes. That means
somehow FORMS "knows" that user has not really issued COMMIT but has issued
POST.
Evenif the SYSTEM.FORM_STATUS is QUERY, FORMS somehow knows that it has
not been commited. Is there anyway to find out how does FORMS know this??
Thanks in advance.