Control functions
The database functions are listed in alphabetical order. The correlations and tasks of the functions can be found in the table below.
Please note, that each dbOpenConnection() has to follow a dbCloseConnection(), each dbStartCommand() has to follow a dbFinishCommand() and each dbOpenRecordSet() has to follow a dbCloseRecordset(). For all these operations be sure to handle correctly the db objects (dbConnection, dbCommand, dbRecordset) i.e. do not set global variables for the objects, do not unblock the same object twice and so on.
A cast of a dbConnection variable to string returns an identifier for the connection, which is to be used for the debugging purposes. If the connection was closed using this variable, the cast returns an empty string. But it cannot be used to tell whether the connection is really open or not.
A function call of a database function through ADO only is supported using SELECT, e.g. "SELECT dbStartCommand();".
If a dpOpenConnection()/dbStartCommand()/dpOpenRecordset() returns an error, then never unblock anything.
Table: List of Control functions
| Opens or closes a connection to the data source | ||
|---|---|---|
| dbOpenConnection() | dbCloseConnection() | |
| Beginning or end of a transaction | ||
| dbBeginTransaction() | dbCommitTransaction() | dbRollbackTransaction() |
| Data manipulation commands | ||
| dbStartCommand() | dbExecuteCommand() | dbFinishCommand() |
| dbBulkCommand() | ||
| Opens or closes data sets | ||
| dbOpenRecordset() | dbCloseRecordset() | dbEOF() |
| Commands for moving the data recorder pointer in the data set | ||
| dbMoveFirst() | dbMovePrevious() | dbMoveNext() |
| dbMoveLast() | dbMove() | dbGetResult() |
| For rereading the data source | ||
| dbRequery() | ||
| Command for individual records | ||
| dbAddNew() | dbUpdate() | dbDelete() |
| dbGetField() | dbPutField() | dbGetRecord() |
| Retrieval of error codes | ||
| dbGetError() | ||
Under Linux all db... functions, as they are described in this help, can be used with exception of the following functions: dbAddNew(), dbDelete(), dbUpdate() and dbPutField(). You have to map these functions with appropriate SQL commands with dbExecuteCommand()!
