Topic: Database Savepoints
Database Savepoints
NOTE: Use this help file with the "TRANSACTIONS - Database - Deleting records" help file
SQL database connections provide one transaction capability that is unavailable for OLE database connections: the ability
to create "SAVE POINTS" within a transaction. Save points let you restore the database state to a specific poistion within
the current transaction. To set a save point within a SQL transaction, use the "Save" method:
trans_Delete.Save("FirstStep");
To restore a SQL transaction to a save point, specify the name of the save point in the "Rollback" method:
trans_Delete.Rollback("FirstStep");