EPUB | CHM | PDF

TPSQLDatabase.Properties.TransactionStatus

Top 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 values summarized in the following list:

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.