SQL

db_alloc_param_row db_execute db_get_error_message db_get_row_count db_is_browsable db_is_prepared db_prepare_sql_cursor db_unexecute

db_cursor_t db_prepare_sql_cursor ( db_t  hdb, const char *  sql_text, db_flags_t    ) Obtain a cursor to access the data from an SQL statement. Note: db_prepare_sql_cursor requires ITTIA DB-SQL and is not available in ITTIA DB-Standard. Parameters: hdb  Database handle. sql_text  SQL query or command. flags  reserved for future use - set to 0. Returns: Cursor handle. NULL on failure. Note: When no longer needed, the cursor must be closed with db_close_cursor. On failure, one of the following error codes is set: DB_EINVAL Caused by: invalid database handle, SQL query parameter is null, invalid flags value. DB_ESTATE Object state is not compatible with the method called or arguments. This could be caused by invalid transaction state. DB_ESQLTABLENOTEXISTS A referenced table does not exist. DB_ESQLINVALIDCOLUMNNAME A referenced column does not exist. DB_ESQLCOLUMNAMBIGUOUSLYDEFINED A referenced column is not specifically defined. DB_ESQLINCOMPATIBLETYPES Incompatible types between two or more variables. DB_ESQLINVALIDFUNCTIONNAME Unrecognized function used in SQL statement. DB_ESQLINVALIDNUMBEROFARGUMENTS Invalid number of arguments used in SQL function call. DB_ESQLININVALIDARGUMENTTYPE Invalid argument type used in SQL function call. DB_ESQLINVALIDQUALIFIER Invalid SQL qualifier used in SQL statement. DB_ESQLINCOMPATIBLEROWTYPES Incompatible row types used in SQL statement. DB_ESQLPARSEERROR SQL parsing error. Refer to SQL syntax documentation. DB_ESQLNOTAGROUPBYEXPRESSION Invalid Group-By expression in SQL statement. DB_ESQLFEATURENOTALLOWED Invalid feature reference. DB_ESQLDIVIDEBYZERO SQL Statement results in divide-by-zero. DB_ESQLINVALIDRELATION Invalid table relation specified. DB_ESQLNOTSORTABLETYPE Sort specified for unsortable data type. See also: db_close_cursor db_get_error_message, get_db_error, clear_db_error, Error Handling