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. If auto-enter options apply to any fields, then they are performed only when the Commit Transaction script step is reached.

To override validation issues during a transaction, use the Skip data entry validation Open Transaction script step option.

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.

  • Won't activate the OnRecordCommit or OnRecordRevert script triggers but will activate other 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