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

SQLResultSetClose

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

SQLResultSetPosition ▪ SQLResultSetColumnNames

New to Mathematica? Find your learning path »
Have a question? Ask support »