A cursor is used to navigate the results of the query, which can contain data from one or more tables. To create a cursor from an SQL statement, call db_prepare_sql_cursor and then db_execute. After a cursor is executed, it can be navigated with the standard cursor access functions.
SQL support is only available in ITTIA DB-SQL and cannot be accessed in ITTIA DB-Standard.
Functions | |
| db_cursor_t | db_prepare_sql_cursor (db_t, const char *, db_flags_t) |
| db_result_t | db_execute (db_cursor_t) |
| db_result_t | db_unexecute (db_cursor_t) |
| int | db_is_prepared (db_cursor_t) |
| int | db_is_browsable (db_cursor_t) |
| db_result_t | db_get_error_message (db_cursor_t, char **sz_msg) |
| db_row_t | db_alloc_param_row (db_cursor_t) |
| int | db_get_param_count (db_cursor_t) |
| db_result_t | db_get_param (db_cursor_t, db_fieldno_t paramno, db_paramdef_t *) |