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.


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

SQLResultSetPosition  ▪  SQLResultSetColumnNames