Cancels all modifications to the data made in the current transaction, without ending the current transaction.
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.
What do you think about this topic? Send feedback!