[Overview][Constants][Types][Classes][Procedures and functions][Variables][Index] Reference for unit 'SQLDB' (#fcl)

TSQLTransaction

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

Transaction in which a TSQLQuery is handled

Declaration

Source position: sqldb.pp line 321

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,IUnknown,IInterfaceComponentReference

|

TPersistent,IFPObserved

|

TObject

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: May 14 2021