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

Created 18th August 2014, last changed 18th August 2014


SQL.ResetConnection - SQL.RowsAffected

Feedback: Report problem or ask question.


Start Chat