Unit 'SQLDB' Package
[Overview][Constants][Types][Classes][Procedures and functions][Variables][Index] [#fcl]

TSQLTransaction

[Properties (by Name)] [Methods (by Name)] [Events (by Name)]

Transaction in which a TSQLQuery is handled.

Declaration

Source position: sqldb.pp line 322

type TSQLTransaction = class(TDBTransaction)

public

  constructor Create(); override;

  

Create a new transaction.

  destructor Destroy; override;

  

Destroy transaction component.

  procedure Commit; override;

  

Commit the transaction, end transaction context.

  procedure CommitRetaining; override;

  

Commit the transaction, retain transaction context.

  procedure Rollback; override;

  

Roll back all changes made in the current transaction.

  procedure RollbackRetaining; override;

  

Roll back changes made in the transaction, keep transaction context.

  procedure StartTransaction; override;

  

Start a new transaction.

  procedure EndTransaction; override;

  

End the transaction.

  property Handle: Pointer; [r]

  

Low-level transaction handle.

  property SQLConnection: TSQLConnection; [rw]

  

Database as TSQLConnection.

published

  property Action: TCommitRollbackAction; [rw]

  

Currently unused in SQLDB.

  property Database: TDataBase;

  

Database for which this component is handling connections.

  property Params: TStringList; [rw]

  

Transaction parameters.

  property Options: TSQLTransactionOptions; [rw]

  

Transaction options.

end;

Inheritance

TSQLTransaction

  

Transaction in which a TSQLQuery is handled.

|

TDBTransaction

  

Encapsulate a transaction.

|

TComponent

|

TPersistent,IUnknown,IInterfaceComponentReference

|

TObject,IFPObserved

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.

See also

TSQLQuery

  

Class to handle SQL commands (with or without result set).

TSQLConnection

  

An abstract class representing a connection to a SQL Database.


Documentation generated on: Jul 24 2023