SQLSetSavepoint[an error occurred while processing this directive]
[an error occurred while processing this directive]
creates a savepoint to be used as part of an SQL transaction.
- To use SQLSetSavepoint, you first need to load DatabaseLink using Needs["DatabaseLink`"].
- A group of SQL commands grouped into a transaction will only take effect permanently when the transaction is committed. The transaction can be canceled or returned to a savepoint.
If you find that the examples in this section do not work as shown, you may need to install or restore the example database with the "DatabaseLink`DatabaseExamples`" package, as described in Using the Example Databases.
Open a connection:
Begin a transaction:
Set a savepoint:
Insert more data:
Roll back to the savepoint:
Commit the transaction:
The table only contains data inserted up to the savepoint: