Working with Savepoints
Go Up to Ending Transactions
Savepoints are implemented in stored procedures and triggers.
The InterBase API supports savepoints with the following functions:
To create a savepoint:
ISC_STATUS isc_start_savepoint( ISC_STATUS *status_vector, isc_tr_handle *trans_handle, char *savepoint_name);
To release a savepoint:
ISC_STATUS isc_release_savepoint( ISC_STATUS *status_vector, isc_tr_handle *trans_handle, char *savepoint_name);
To roll back to a savepoint:
ISC_STATUS isc_rollback_savepoint( ISC_STATUS *status_vector, isc_tr_handle *trans_handle, char *savepoint_name short option);