Commit Transaction
Saves all record changes and ends the current transaction.
See also
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.
Open Transaction []
Open Record/Request
Set Field [ Assets::Description ; "descriptive text" ]
Commit Transaction