Skip to main content
Version: Next

Active transaction

Active transaction : Boolean

ParameterTypeDescription
Function resultBooleanReturns False if the current transaction is suspended

Description

The Active transaction command returns True if the current process is in transaction, and this transaction is not suspended. It returns False if there is no current transaction, or if the current transaction is suspended. A transaction can be suspended using the SUSPEND TRANSACTION command.

Since the command will also return False if the current process is not in transaction, you may need to check using the In transaction command to know whether the process is in transaction.

For more information, please refer to Suspending transactions.

Description

You want to know the current transaction status:

 If(In transaction)
    If(Not(Active transaction))
       ALERT("The current transaction is suspended")
    Else
       ALERT("The current transaction is active")
    End if
 Else
    ALERT("We are not in transaction")
 End if

See also

In transaction
RESUME TRANSACTION
SUSPEND TRANSACTION
Suspending transactions

Properties

Command number1387
Thread safe