Topics
All
Mac OS X
(Only)
Windows
(Only)
Linux
(Only, Not)
iOS
(Only, Not)
Components
Crossplatform Mac & Win
Server
Client
Old
Guides
Examples
New in version:
7.2
7.3
7.4
7.5
8.0
8.1
8.2
8.3
8.4
8.5
Statistic
SQL.Rollback
Cancels any changes made during the current transaction and ends the transaction.
| Component | Version | macOS | Windows | Server | FileMaker Cloud | FileMaker iOS SDK |
| SQL | 2.6 | Yes | Yes | Yes | Yes | Yes |
MBS( "SQL.Rollback"; Connection ) More
Parameters
| Parameter | Description | Example value |
|---|---|---|
| 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
Created 18th August 2014, last changed 18th August 2014
SQL.ResetConnection - SQL.RowsAffected
Feedback: Report problem or ask question.
Links
MBS Xojo blog
