Skip to Main Content

Oracle Forms

Announcement

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!

Non active form fires post-forms-commit trigger

User_0QUXCJul 5 2021

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?

This post has been answered by Michael Ferrante-Oracle on Jul 6 2021
Jump to Answer

Comments

Michael Ferrante-Oracle
Answer

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.

Marked as Answer by User_0QUXC · Jul 6 2021

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.

User_0QUXC

I have tested. Using OPEN_FORM (<form name>, ACTIVATE, SESSION); works. Thanks.

1 - 3

Post Details

Added on Jul 5 2021
3 comments
101 views