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