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