This is the legacy 4D documentation web site. Documentations are progressively being moved to developer.4d.com

Home

 
Home
4D v20 R8
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

 
PAGE CONTENTS 
Description
Example
 
HISTORY 

 
ARTICLE USAGE

4D SQL Reference ( 4D v20 R8)