Topics
All
MacOS
(Only)
Windows
(Only)
Linux
(Only, Not)
iOS
(Only, Not)
Components
Crossplatform Mac & Win
Server
Client
Old
Deprecated
Guides
Examples
Videos
New in version:
10.5
11.0
11.1
11.2
11.3
11.4
11.5
12.0
12.1
12.2
Statistic
FMM
Blog
SQL.Rollback
Cancels any changes made during the current transaction and ends the transaction.
Component | Version | macOS | Windows | Linux | Server | iOS SDK | License |
SQL | 2.6 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | Free |
MBS( "SQL.Rollback"; Connection ) More
Parameters
Parameter | Description | Example |
---|---|---|
Connection | The connection reference number gained with SQL.NewConnection. | $Connection |
Result
Returns "OK" or error message.
Description
Cancels any changes made during the current transaction and ends the transaction.Rollback method rolls back the database to the state it was in at the completion of the last commit operation. All uncommitted work is undone.
Rollback method rolls back the work of all commands that associated with that connection.
To commit all changes made since the start of the transaction use SQL.Commit method.
See also
Example Databases
Blog Entries
FileMaker Magazin
Created 18th August 2014, last changed 18th August 2014
SQL.ResetConnection - SQL.RowsAffected
Feedback: Report problem or ask question.
