The SQL interface provides access to the database through an SQL query. More...
Data Structures | |
| struct | db_paramdef_t |
| SQL query parameter definition. More... | |
Functions | |
| db_result_t | db_paramdef_init (db_paramdef_t *) |
| db_result_t | db_paramdef_destroy (db_paramdef_t *) |
| db_cursor_t | db_prepare_sql_cursor (db_t, const char *, db_flags_t) |
| db_result_t | db_execute (db_cursor_t, db_row_t param_row, db_object_t param_object) |
| 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_row_num (db_cursor_t hcursor, int64_t *) |
| int | db_get_row_count (db_cursor_t) |
| db_result_t | db_get_row_count_ex (db_cursor_t hcursor, int32_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 *) |
The SQL interface provides access to the database through an SQL query.
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 Standard and cannot be accessed in ITTIA DB Compact.
