PostgresDAC
TPSQLDatabase.Properties.TransactionStatus | Previous Next |
Specifies the transaction status.
Syntax:
type
TTransactionStatusType = (
trstIDLE,
trstACTIVE,
trstINTRANS,
trstINERROR,
trstUNKNOWN);
property TransIsolation: TTransIsolation;
Description:
Use TransactionStatus to determine the transaction status. TransactionStatus can be
any one of the three values summarized in the following table:
| Transaction Status | Meaning |
|---|
| trstIDLE | Connection idle. |
| trstACTIVE | Command of SQL statement in progress. |
| trstINTRANS | Idle, within transaction block. |
| trstINERROR | Idle, within failed transaction. |
| trstUNKNOWN | Cannot determine status. |
 | If you get trstINERROR result, then keep in mind that all SQL commands will fail until
ROLLBACK or COMMIT will be executed. If you get trstUNKNOWN result, you are
probably disconnected from server. |
