[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