4D v16

ROLLBACK

Home

 
Home
4D v16
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;



See also 

COMMIT

Previous page
Next page

 
PROPERTIES 

Product: 4D
Theme: Transactions

 
HISTORY 

 
ARTICLE USAGE

4D SQL Reference ( 4D v16)