VALIDATE TRANSACTION

VALIDATE TRANSACTION

Does not require any parameters

Description

VALIDATE TRANSACTION accepts the transaction that was started with START TRANSACTION of the corresponding level in the current process. The command saves the changes to the data of the database that occurred during the transaction.

Starting with version 11 of 4D, you can nest several transactions (sub-transactions). If the main transaction is cancelled, all the sub-transactions are cancelled, even if they have been validated individually using this command.

System variables and sets

The system variable OK is set to 1 if the transaction has been validated correctly; otherwise, it is set to 0.

Note that when OK is set to 0, the transaction is automatically cancelled internally (equivalent to CANCEL TRANSACTION). Consequently, you must not explicitly call CANCEL TRANSACTION if OK=0, particularly in the context of nested transactions, because the cancellation will then be applied to the higher level transaction.

See also

CANCEL TRANSACTION
In transaction
START TRANSACTION
Using Transactions

Properties

Command number	240
Thread safe	✓
Modifies variables	OK