VALIDATE TRANSACTION

Home

4D v18


	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.