Server Rollback statement - MapBasic - 2023

Purpose

Discards changes made on the remote data server during the current unit of work. You can issue this statement from the MapBasic window in MapInfo Pro.

Syntax

Server ConnectionNumber Rollback

ConnectionNumber is an integer value that identifies the specific connection.

Description

The Server Rollback statement discards the effects of all SQL statements on the connection back to the Server Begin Transaction statement. You must have an open transaction initiated by Server Begin Transaction statement before you can use this command.

Example

hdbc = Server_Connect("ODBC", "DLG=1")
Server hdbc Begin Transaction

...

' All changes since begin_transaction are about ' to be discarded
Server hdbc Rollback

See Also:

Server Begin Transaction statement, Server Commit statement