Data.SqlExpr.TSQLConnection.TransactionsSupported

• Up to Parent: TSQLConnection

[–] Properties Type: property Visibility: public Source:

Data.SqlExpr.pas

Data.SqlExpr.hpp

Unit: Data.SqlExpr Parent: TSQLConnection

Delphi

property TransactionsSupported: LongBool read FTransactionsSupported;

C++

__property System::LongBool TransactionsSupported = {read=FTransactionsSupported, nodefault};

Description

Indicates whether the database server supports transactions.

Read TransactionsSupported at runtime to ascertain whether the database server supports transactions. If TransactionsSupported is false, then the BeginTransaction, CommitFreeAndNil, RollbackFreeAndNil, and RollbackIncompleteFreeAndNil methods do nothing. If TransactionsSupported is true, you can use the SQL connection component to manage transactions.

Note: Some servers support multiple transactions (either nested or overlapping). When TransactionsSupported is true, you can test whether the server supports multiple transactions by reading the MultipleTransactionsSupported property.

See Also

• BeginTransaction

• CommitFreeAndNil

• RollbackFreeAndNil

• RollbackIncompleteFreeAndNil

• InTransaction

• MultipleTransactionsSupported