Transaction overview

In Dexterity, transactions are supported only for the Microsoft SQL Server™ database. You can’t use transactions with any of the other supported database managers. Use the havetransactions() function to find out whether the default database type supports transactions.

To start a transaction, use the transaction begin statement. Perform the table operations that perform the work of the transaction. If all of the table operations are successful, you can “commit” them using the transaction commit statement. If any table operations fail and can’t be completed, the transaction can be “rolled back” using the transaction rollback statement. The table operations performed in the transaction will be undone, returning the data to the state it was in before the transaction began.

Once a transaction is started, any scripts that are called are also part of the transaction. For instance, any database operations performed by procedures called from within a transaction are part of the transaction.

Documentation Feedback