Forms-Based Application Development Tools User Guide > Part 5: 4GL > J. Notes for Users of QUEL > QUEL Notes for the Writing 4GL Statements Chapter > Committing the Transaction
Was this helpful?
Committing the Transaction
In QUEL, transactions are individually opened and closed with each occurrence of a query statement (retrieve, append, replace and delete) unless you specifically establish a multi-query transaction (MQT). Use the following QUEL transaction control statements:
Begin transaction
Opens a transaction on the first occurrence of a query statement
End transaction
Commits the transaction and closes it
Abort
Terminates a transaction in progress, undoing the effects of all processed statements.
Savepoint
Declares a savepoint. Roll the transaction back to any of its savepoints prior to committing the transaction.
See the QUEL Reference Guide for detailed descriptions of these commands and a full description of transactions in QUEL.
Last modified date: 04/03/2024