4D v13.4

ROLLBACK

Home

 
4D v13.4
4D SQL Reference
Transactions
ROLLBACK

ROLLBACK  


 

 

Command ROLLBACKROLLBACK [TRANSACTION]

The ROLLBACK command cancels the transaction underway and restores the data to its previous state at the beginning of the transaction. It also frees up any resources held by the transaction. The TRANSACTION keyword is optional.

Example  

This example illustrates the use of the ROLLBACK command:

START TRANSACTION
SELECT * FROM suppliers
WHERE supplier_name like '%bob%';
ROLLBACK TRANSACTION;

 
PROPERTIES 

Product: 4D
Theme: Transactions

 
INDEX

Alphabetical list of commands

 
SEE ALSO 

COMMIT