Non active form fires post-forms-commit trigger

User_0QUXC

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?

Michael Ferrante-Oracle

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.

Michael Ferrante-Oracle

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.

Michael Ferrante-Oracle

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.

Michael Ferrante-Oracle

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.