SQLBeginTransaction[an error occurred while processing this directive]
[an error occurred while processing this directive]
- To use SQLBeginTransaction, 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:
Commit the transaction:
Select the data: