This is documentation for Mathematica 6, which was
based on an earlier version of the Wolfram Language.
View current documentation (Version 11.1)
DatabaseLink Transactions and Result Sets
DatabaseLink supports SQL transactions and result sets. These features, useful for advanced users, help to maintain integrity of the data stored in your database as well as increasing efficiency.
Transactions
SQLBeginTransaction mark the beginning of an SQL transaction
SQLCommitTransaction commit a transaction, making the changes permanent
SQLRollbackTransaction revert changes since the beginning of the transaction
    
SQLSetSavepoint mark a savepoint in a transaction
Result Sets
SQLResultSetOpen make a result set from an SQL query
    
SQLResultSetRead read from a result set (shifts the current position)
SQLResultSetCurrent, SQLResultSetTake read from a result set (without shifting)
    
SQLResultSetGoto, SQLResultSetShift change position in a result set
Tutorials
MORE ABOUT