Convertigo Public Knowledge base

Manage COMMIT/ROLLBACK in SQL Transaction

Every Convertigo SQL Transaction has an Auto-commit property with value list:

  • disabled, manual commit

  • enabled, after each query (default)

  • enabled, once at the end

Set the property to disabled, manual commit if you want to manage by yourself when to commit query or rollback in case of an error.

Then, create 2 Transactions with COMMIT and ROLLBACK verbs to be called by a sequence when needed.

(c) Convertigo 2023