VALIDATE TRANSACTION

4D - Documentation   Français   English   German   Spanish   4D v11 SQL, Command Theme List   4D v11 SQL, Command Alphabetical List   4D v11 SQL, Constant Theme List   Back   Previous   Next

version 11 (Modified)


VALIDATE TRANSACTION

ParameterTypeDescription
This command 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. VALIDATE TRANSACTION 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.

See Also

CANCEL TRANSACTION, In transaction, START TRANSACTION, Using Transactions.


4D - Documentation   Français   English   German   Spanish   4D v11 SQL, Command Theme List   4D v11 SQL, Command Alphabetical List   4D v11 SQL, Constant Theme List   Back   Previous   Next