A transactional event handler is one in which all the associated actions must complete successfully before the system can commit data and complete the transaction. If any part of the action sequence fails, the system generates an error and rolls everything back to where it was before the event action sequence began.
A transactional event trigger is one in which the database operations performed by the actions of the associated event handlers either all commit or none commit. If any event handler fails and is not marked to Ignore Failure, the system generates an error and rolls back all database operations performed during the event.
On the Event Handlers form:
To define the event handler as transactional, select this check box.
On the Event Triggers form:
To define the event trigger as transactional, select this check box.
On the Event Action Generate Event form:
To instruct the system to treat the generated event as transactional, select this check box.
When you click OK to return to the Event Actions form, the system "wraps" this content within a TRANSACTIONAL( ) parameter, which yields the following final syntax:
On other forms:
This check box is display-only and indicates that the actions for the selected event handler's database operations either all commit or all roll back as a group.
For more information, see the following topics in the Guide to the Application Event System: