PgDAC

TPgConnection.StartTransaction Method

Starts a new user transaction against the database server.

Class

TPgConnection

Syntax

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

Parameters
IsolationLevel
Specifies how the transactions containing database modifications are handled.
ReadOnly
If True, read-only transaction is started that cannot modify data in the database.

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.

© 1997-2024 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback