Commit Transaction

Saves all record changes and ends the current transaction.

Options 

None.

Compatibility 

Product Supported
FileMaker Pro Yes
FileMaker Go Yes
FileMaker WebDirect Yes
FileMaker Server Yes
FileMaker Cloud Yes
FileMaker Data API Yes
Custom Web Publishing Yes

Originated in version 

19.6.1

Description 

Commit Transaction saves all changes and ends the current transaction. This step will either commit every change or revert the entire set of changes made during the transaction. If schema validation rules have been met, then your changes will be allowed to be committed to the database; otherwise the changes will be automatically reverted.

To override validation issues during a transaction, use one of the following Open Transaction script step options

  • Only during data entry field

  • Start Transaction [ Skip data entry validation ]

Note  Overriding validation can break database integrity and should only be used when additional scripted validation is in place.

Commit Transaction:

  • Exits the active record

  • Will trigger appropriate triggers

  • Causes all objects to become inactive

Example 1 

Commits the records in a transaction.

Copy
Open Transaction []
    Open Record/Request
    Set Field [ Assets::Description ; "descriptive text" ]
Commit Transaction