Skip to main content
Version: Next

In transaction

In transaction -> Function result

ParameterTypeDescription
Function resultBoolean🡐Returns TRUE if current process is in transaction

Description​

The In transaction command returns TRUE if the current process is in a transaction, otherwise it returns FALSE.

Example​

If you perform a multi-record operation (adding, modifying, or deleting records), you may encounter locked records. In this case, if you have to maintain data integrity, you must be in transaction so you can “roll-back” the whole operation and leave the database untouched.

If you perform the operation from within a trigger or from a subroutine (that can be called while in transaction or not), you can use In transaction to check whether or not the current process method or the caller method started a transaction. If a transaction was not started, you do not even start the operation, because you already know that you will not be able to roll it back if it fails.

See also​

Active transaction
CANCEL TRANSACTION
START TRANSACTION
Triggers
VALIDATE TRANSACTION