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. 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.
Open Transaction []
Open Record/Request
Set Field [ Assets::Description ; "descriptive text" ]
Commit Transaction