Server Begin Transaction statement - MapBasic - 2023

Purpose

Requests a remote data server to begin a new unit of work. You can issue this statement from the MapBasic window in MapInfo Pro.

Syntax

Server ConnectionNumber Begin Transaction 

ConnectionNumber is an integer value that identifies the specific connection.

Description

The Server Begin Transaction statement is used to mark a beginning point for transaction processing. The database does not save the results of subsequent SQL Insert, Delete, and Update statements issued via the Server_Execute( ) function until a Server Commit statement is issued. Use the Server Rollback statement to discard changes.

Example

Dim hdbc As Integer
hdbc = Server_Connect("ODBC", "DLG=1")
Server hdbc Begin Transaction
' ... other server statements ...
Server hdbc Commit

See Also:

Server Commit statement, Server Rollback statement