[Properties (by Name)] [Methods (by Name)] [Events (by Name)]
Transaction in which a TSQLQuery is handled.
Source position: sqldb.pp line 329
| 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. |