TSQLTransaction¶

Transaction in which a TSQLQuery is handled.

Declaration¶

Source position: sqldb.pp line 329

type

  TSQLTransaction = class(TDBTransaction)
  public
    constructor Create;
    destructor Destroy;
    procedure Commit;
    procedure CommitRetaining;
    procedure Rollback;
    procedure RollbackRetaining;
    procedure StartTransaction;
    procedure EndTransaction;
    property Handle: Pointer; {r}
    property SQLConnection: TSQLConnection; {rw}
  published
    property Action: TCommitRollbackAction; {rwd}
    property Database;
    property Params: TStringList; {rw}
    property Options: TSQLTransactionOptions; {rwd}
  end;

Inheritance¶

Description¶

TSQLTransaction represents the transaction in which one or more TSQLQuery instances are doing their work. It contains the methods for committing or doing a rollback of the results of query. At least one TSQLTransaction must be used for each TSQLConnection used in an application.

Properties¶

Member	Visibility	Description
Action	published	Currently unused in SQLDB.
Database read only	published	Database for which this component is handling connections.
Handle read only	public	Low-level transaction handle.
Options	published	Transaction options.
Params	published	Transaction parameters.
SQLConnection	public	Database as TSQLConnection.

See all Properties

Methods¶

Member	Visibility	Description
Commit	public	Commit the transaction, end transaction context.
CommitRetaining	public	Commit the transaction, retain transaction context.
Create	public	Create a new transaction.
Destroy	public	Destroy transaction component.
EndTransaction	public	End the transaction.
Rollback	public	Roll back all changes made in the current transaction.
RollbackRetaining	public	Roll back changes made in the transaction, keep transaction context.
StartTransaction	public	Start a new transaction.

See all Methods

Name	Description
TSQLQuery	Class to handle SQL commands (with or without result set).
TSQLConnection	An abstract class representing a connection to a SQL Database.