| [Overview][Constants][Types][Classes][Procedures and functions][Variables][Index] | 
[Properties (by Name)] [Methods (by Name)] [Events (by Name)]
Transaction in which a TSQLQuery is handled
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  | 
  | 
Database for which this component is handling connections  | 
|
property Params: TStringList; [rw]  | 
  | 
Transaction parameters  | 
property Options: TSQLTransactionOptions; [rw]  | 
  | 
Transaction options  | 
end;  | 
  | 
Transaction in which a TSQLQuery is handled  | 
|
| | | ||
  | 
Encapsulate a transaction  | 
|
| | | ||
| | | ||
| | | ||
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.
  | 
Class to handle SQL commands (with or without result set)  | 
|
  | 
An abstract class representing a connection to a SQL Database  |