Revert Transaction
Returns all records changed in the transaction to their original state and ends the current transaction.
See also
Options
-
Condition reverts a transaction only if evaluated as true.
-
Error Code returns a custom error code for Get(LastError), Get(LastErrorDetail), and Get(LastErrorLocation) if the provided code is in the range of 5000 through 5499.
-
Error Message returns a custom error message for Get(LastErrorDetail) and Get(LastErrorLocation) if an error code is provided and the provided code is in the range of 5000 through 5499.
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
Revert Transaction:
-
Exits the active record
-
Will trigger appropriate triggers
-
Is only allowed between Start Transaction and Commit Transaction
Revert Transaction will:
-
Jump to the matching Commit Transaction step
Revert Transaction will not:
-
Revert Auto Enter Serial Number Increment
-
Revert Truncate Table
Example 1
Reverts the records in a transaction.
Open Transaction []
Open Record/Request
Set Field [ Assets::Description ; "descriptive text" ]
Revert Transaction []
Commit Transaction
Example 2
Reverts the records in a transaction if the condition is met.
Open Transaction []
Open Record/Request
Set Field [ Assets::Description ; "description text" ]
Revert Transaction [ Condition: 1 ]
Commit Transaction
Example 3
Reverts the records in a transaction and returns a custom error.
Open Transaction []
Open Record/Request
Set Field [ Assets::Description ; "descriptive text" ]
Revert Transaction [ Error Code: 5001 ; Error Message: "custom error text" ]
Commit Transaction