db::Query

close exec_direct execute get_database get_error_message get_row_count is_bof is_eof is_opened param prepare seek_first seek_next unexecute

int db::Query::prepare ( Database &  newdb, const char *  text   ) Parses SQL statements and prepares for SQL execution. Parameters: newdb  Database handle. text  SQL query or command. Returns: DB_NOERROR when successful. Note: When no longer needed, the query object must be closed with close. 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_ESQLNOTSORTABLETYPE Sort specified for unsortable data type. See also: close, get_error_message