For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
I had 2 forms opened. I asked a question in both. But updated in one of the forms. And clicked the common save-button (the disc-symbol) Both forms post-forms-commit-triggers seemed to be fired. How to fire only the trigger for the active form?
Because the application connection to the DB is in a single session, commit (or Save) will commit everything. There may not be an easy way to accomplish what you want. The good news is that this might make for a good enhancement. I will discuss with development to see if there is a reasonable way to implement such behavior into a future release.
Edited by Michael Ferrante: Entry with typo removed. Refer to next post for accurate solution.
Just occurred to me that what you want is possible and my example had a typo. If you open each form as follows: OPEN_FORM (<form name>, ACTIVATE, SESSION); This should allow what you want. Each form will commit independent of the other.
OPEN_FORM (<form name>, ACTIVATE, SESSION);
I have tested. Using OPEN_FORM (<form name>, ACTIVATE, SESSION); works. Thanks.