TPgConnection.StartTransaction Method

Starts a new user transaction against the database server.

Class

TPgConnection

Syntax

procedure StartTransaction(IsolationLevel: TPgIsolationLevel; ReadOnly: boolean = False); reintroduce; overload;

Remarks

Call the StartTransaction method to begin a new user transaction against the database server. Before calling StartTransaction, an application should check the status of the InTransaction property. If InTransaction is True, it indicates that a transaction is already in progress, a subsequent call to StartTransaction without first calling TCustomDAConnection.Commit or TCustomDAConnection.Rollback to end the current transaction raises EDatabaseError. Calling StartTransaction when connection is closed also raises EDatabaseError.

Updates, insertions, and deletions that take place after a call to StartTransaction are held by the server until an application calls Commit to save the changes or Rollback to cancel them.