4D v14

ROLLBACK

Home

 
Home
4D v14
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

 
SEE ALSO 

COMMIT

 
ARTICLE USAGE

4D SQL Reference ( 4D v11 SQL Release 4 )
4D SQL Reference ( 4D v14)
4D SQL Reference ( 4D v12.1)
4D SQL Reference ( 4D v13.4)
4D SQL Reference ( 4D v14 R2)
4D SQL Reference ( 4D v14 R3)
4D SQL Reference ( 4D v14 R4)