Call RollbackRetaining to cancel all modifications, like a INSERT's / UPDATE's / DELETE's, made in current transaction to the database. 

AnyDAC supports nested transactions, so the current transaction is the one started with most recent StartTransaction call. If the database does not support nested transactions, like most of DBMS's, then AnyDAC will emulate nested transactions using savepoints. 

Before calling RollbackRetaining, an application may check the status of the Active property. If an application calls RollbackRetaining and there is no current transaction, an exception is raised. 

RollbackRetaining will use native functionality on IB/FB. On other DBMS's the method will be equal to calls of Rollback, then of StartTransaction.

procedure RollbackRetaining;

Managing Transactions, StartTransaction, InTransaction, Commit, Rollback