Main Page   Alphabetical List   Data Structures   File List   Data Fields   Globals  

stmt Struct Reference

#include <sqlite3odbc.h>

Detailed Description

Driver internal structure representing SQL statement (HSTMT).

Definition at line 232 of file sqlite3odbc.h.

Data Fields

stmt * next
 Linkage for STMT list in DBC.

HDBC dbc
 Pointer to DBC.

SQLCHAR cursorname [32]
 Cursor name.

SQLCHAR * query
 Current query, raw string.

int * ov3
 True for SQL_OV_ODBC3.

int * oemcp
 True for Win32 OEM CP translation.

int * jdconv
 True for julian day conversion.

int * ilike
 True for ILIKE fixup.

int isselect
 > 0 if query is a SELECT statement

int ncols
 Number of result columns.

COL * cols
 Result column array.

COL * dyncols
 Column array, but malloc()ed.

int dcols
 Number of entries in dyncols.

int bkmrk
 True when bookmarks used.

SQLINTEGER * bkmrkptr
 SQL_ATTR_FETCH_BOOKMARK_PTR.

BINDCOL bkmrkcol
 Bookmark bound column.

BINDCOL * bindcols
 Array of bound columns.

int nbindcols
 Number of entries in bindcols.

int nbindparms
 Number bound parameters.

BINDPARM * bindparms
 Array of bound parameters.

int nparams
 Number of parameters in query.

int pdcount
 SQLParamData() counter.

int nrows
 Number of result rows.

int rowp
 Current result row.

int rowprs
 Current start row of rowset.

char ** rows
 2-dim array, result set

void(* rowfree )()
 Free function for rows.

int naterr
 Native error code.

char sqlstate [6]
 SQL state for SQLError().

SQLCHAR logmsg [1024]
 Message for SQLError().

int nowchar [2]
 Don't try to use WCHAR.

int dobigint
 Force SQL_BIGINT for INTEGER columns.

int longnames
 Don't shorten column names.

SQLULEN retr_data
 SQL_ATTR_RETRIEVE_DATA.

SQLULEN rowset_size
 Size of rowset.

SQLUSMALLINT * row_status
 Row status pointer.

SQLUSMALLINT * row_status0
 Internal status array.

SQLUSMALLINT row_status1
 Internal status array for 1 row rowsets.

SQLULEN * row_count
 Row count pointer.

SQLULEN row_count0
 Row count.

SQLULEN paramset_size
 SQL_ATTR_PARAMSET_SIZE.

SQLULEN paramset_count
 Internal for paramset.

SQLUINTEGER paramset_nrows
 Row count for paramset handling.

SQLULEN max_rows
 SQL_ATTR_MAX_ROWS.

SQLULEN bind_type
 SQL_ATTR_ROW_BIND_TYPE.

SQLULEN * bind_offs
 SQL_ATTR_ROW_BIND_OFFSET_PTR.

SQLULEN * parm_bind_offs
 SQL_ATTR_PARAM_BIND_OFFSET_PTR.

SQLUSMALLINT * parm_oper
 SQL_ATTR_PARAM_OPERATION_PTR.

SQLUSMALLINT * parm_status
 SQL_ATTR_PARAMS_STATUS_PTR.

SQLULEN * parm_proc
 SQL_ATTR_PARAMS_PROCESSED_PTR.

SQLULEN parm_bind_type
 SQL_ATTR_PARAM_BIND_TYPE.

int curtype
 Cursor type.

sqlite3_stmt * s3stmt
 SQLite statement handle or NULL.

int s3stmt_noreset
 False when sqlite3_reset() needed.

int s3stmt_rownum
 Current row number.

char * bincell
 Cache for blob data.

char * bincache
 Cache for blob data.

int binlen
 Length of blob data.

int guessed_types
 Flag for drvprepare()/drvexecute().

int one_tbl
 Flag for single table (> 0).

int has_pk
 Flag for primary key (> 0).

int has_rowid
 Flag for ROWID (>= 0 or -1).

Field Documentation

char* stmt::bincache
 

Cache for blob data.

Definition at line 290 of file sqlite3odbc.h.

Referenced by freeresult(), and getrowdata().

char* stmt::bincell
 

Cache for blob data.

Definition at line 289 of file sqlite3odbc.h.

Referenced by freeresult(), and getrowdata().

SQLULEN* stmt::bind_offs
 

SQL_ATTR_ROW_BIND_OFFSET_PTR.

Definition at line 278 of file sqlite3odbc.h.

Referenced by dofetchbind(), drvallocstmt(), drvbulkoperations(), drvgetstmtattr(), drvsetstmtattr(), setposbind(), and setposrefr().

SQLULEN stmt::bind_type
 

SQL_ATTR_ROW_BIND_TYPE.

Definition at line 277 of file sqlite3odbc.h.

Referenced by dofetchbind(), drvallocstmt(), drvbulkoperations(), drvgetstmtattr(), drvsetstmtattr(), setposbind(), and setposrefr().

BINDCOL* stmt::bindcols
 

Array of bound columns.

Definition at line 249 of file sqlite3odbc.h.

Referenced by chkunbound(), dofetchbind(), drvbindcol(), drvbulkoperations(), drvfetchscroll(), drvsetpos(), freeresult(), getrowdata(), mkbindcols(), setposbind(), setposrefr(), and unbindcols().

BINDPARM* stmt::bindparms
 

Array of bound parameters.

Definition at line 252 of file sqlite3odbc.h.

Referenced by drvbindparam(), drvputdata(), freeparams(), freestmt(), s3stmt_start(), setupparam(), and SQLParamData().

int stmt::binlen
 

Length of blob data.

Definition at line 291 of file sqlite3odbc.h.

Referenced by freeresult(), and getrowdata().

int stmt::bkmrk
 

True when bookmarks used.

Definition at line 246 of file sqlite3odbc.h.

Referenced by dofetchbind(), drvallocstmt(), drvbindcol(), drvbulkoperations(), drvfetchscroll(), drvgetstmtattr(), drvsetstmtattr(), and SQLGetData().

BINDCOL stmt::bkmrkcol
 

Bookmark bound column.

Definition at line 248 of file sqlite3odbc.h.

Referenced by dofetchbind(), drvbindcol(), and drvbulkoperations().

SQLINTEGER* stmt::bkmrkptr
 

SQL_ATTR_FETCH_BOOKMARK_PTR.

Definition at line 247 of file sqlite3odbc.h.

Referenced by drvallocstmt(), drvfetchscroll(), drvgetstmtattr(), drvsetstmtattr(), and SQLExtendedFetch().

COL* stmt::cols
 

Result column array.

Definition at line 243 of file sqlite3odbc.h.

Referenced by drvbindcol(), drvcolattributes(), drvdescribecol(), freedyncols(), freeresult(), getrowdata(), mkresultset(), s3stmt_step(), setposbind(), and SQLDescribeColW().

SQLCHAR stmt::cursorname[32]
 

Cursor name.

Definition at line 235 of file sqlite3odbc.h.

Referenced by drvallocstmt(), drvgetcursorname(), and drvsetcursorname().

int stmt::curtype
 

Cursor type.

Definition at line 285 of file sqlite3odbc.h.

Referenced by drvallocstmt(), drvbulkoperations(), drvfetchscroll(), drvgetstmtattr(), drvgetstmtoption(), drvsetpos(), drvsetstmtattr(), and drvsetstmtoption().

HDBC stmt::dbc
 

Pointer to DBC.

Definition at line 234 of file sqlite3odbc.h.

Referenced by drvallocstmt(), drvbulkoperations(), drvcolumns(), drvfetchscroll(), drvforeignkeys(), drvfreestmt(), drvgetdiagfield(), drvgettable(), drvprimarykeys(), drvsetpos(), drvspecialcolumns(), drvstatistics(), drvtableprivileges(), drvtables(), freestmt(), mkresultset(), s3stmt_drop(), s3stmt_end(), s3stmt_end_if(), s3stmt_start(), s3stmt_step(), setposbind(), setposibind(), and starttran().

int stmt::dcols
 

Number of entries in dyncols.

Definition at line 245 of file sqlite3odbc.h.

Referenced by fixupdyncols(), freedyncols(), and s3stmt_step().

int stmt::dobigint
 

Force SQL_BIGINT for INTEGER columns.

Definition at line 264 of file sqlite3odbc.h.

Referenced by drvallocstmt(), drvcolumns(), drvspecialcolumns(), and fixupdyncols().

COL* stmt::dyncols
 

Column array, but malloc()ed.

Definition at line 244 of file sqlite3odbc.h.

Referenced by drvbulkoperations(), drvsetpos(), fixupdyncols(), freedyncols(), and s3stmt_step().

int stmt::guessed_types
 

Flag for drvprepare()/drvexecute().

Definition at line 292 of file sqlite3odbc.h.

Referenced by drvgettable_row().

int stmt::has_pk
 

Flag for primary key (> 0).

Definition at line 294 of file sqlite3odbc.h.

Referenced by drvallocstmt(), drvsetpos(), fixupdyncols(), and freeresult().

int stmt::has_rowid
 

Flag for ROWID (>= 0 or -1).

Definition at line 295 of file sqlite3odbc.h.

Referenced by dofetchbind(), drvallocstmt(), drvbulkoperations(), drvfetchscroll(), fixupdyncols(), freeresult(), and SQLGetData().

int* stmt::ilike
 

True for ILIKE fixup.

Definition at line 240 of file sqlite3odbc.h.

Referenced by drvallocstmt().

int stmt::isselect
 

> 0 if query is a SELECT statement

Definition at line 241 of file sqlite3odbc.h.

Referenced by drvbulkoperations(), drvfetchscroll(), drvgetdiagfield(), drvsetpos(), mkresultset(), and SQLRowCount().

int* stmt::jdconv
 

True for julian day conversion.

Definition at line 239 of file sqlite3odbc.h.

Referenced by drvallocstmt(), getrowdata(), setposbind(), and setupparam().

SQLCHAR stmt::logmsg[1024]
 

Message for SQLError().

Definition at line 262 of file sqlite3odbc.h.

Referenced by drvgetdiagfield(), drvgetdiagrec(), and setstat().

int stmt::longnames
 

Don't shorten column names.

Definition at line 265 of file sqlite3odbc.h.

Referenced by drvallocstmt(), fixupdyncols(), and s3stmt_step().

SQLULEN stmt::max_rows
 

SQL_ATTR_MAX_ROWS.

Definition at line 276 of file sqlite3odbc.h.

Referenced by drvallocstmt(), drvfetchscroll(), drvgetstmtattr(), drvgetstmtoption(), drvgettable(), drvsetstmtattr(), and drvsetstmtoption().

int stmt::naterr
 

Native error code.

Definition at line 260 of file sqlite3odbc.h.

Referenced by drvgetdiagfield(), drvgetdiagrec(), and setstat().

int stmt::nbindcols
 

Number of entries in bindcols.

Definition at line 250 of file sqlite3odbc.h.

Referenced by chkunbound(), freeresult(), mkbindcols(), and unbindcols().

int stmt::nbindparms
 

Number bound parameters.

Definition at line 251 of file sqlite3odbc.h.

Referenced by drvbindparam(), freeparams(), and setupparam().

int stmt::ncols
 

Number of result columns.

Definition at line 242 of file sqlite3odbc.h.

Referenced by chkunbound(), dofetchbind(), drvbulkoperations(), drvcolattributes(), drvdescribecol(), drvfetchscroll(), drvforeignkeys(), drvgettable_row(), drvprimarykeys(), drvsetpos(), drvspecialcolumns(), drvstatistics(), drvtableprivileges(), drvtables(), freedyncols(), freeresult(), getrowdata(), mkresultset(), s3stmt_step(), setposibind(), setposrefr(), SQLGetData(), and SQLNumResultCols().

struct stmt* stmt::next
 

Linkage for STMT list in DBC.

Definition at line 233 of file sqlite3odbc.h.

Referenced by drvallocstmt(), and freestmt().

int stmt::nowchar[2]
 

Don't try to use WCHAR.

Definition at line 263 of file sqlite3odbc.h.

Referenced by drvallocstmt(), drvbindcol(), drvcolattributes(), drvcolumns(), drvdescribecol(), drvputdata(), drvspecialcolumns(), fixupdyncols(), freeresult(), getrowdata(), mkresultset(), setupparam(), SQLDescribeParam(), and SQLParamData().

int stmt::nparams
 

Number of parameters in query.

Definition at line 253 of file sqlite3odbc.h.

Referenced by drvputdata(), s3stmt_start(), SQLDescribeParam(), SQLNumParams(), and SQLParamData().

int stmt::nrows
 

Number of result rows.

Definition at line 255 of file sqlite3odbc.h.

Referenced by drvcolumns(), drvfetchscroll(), drvforeignkeys(), drvgetdiagfield(), drvgettypeinfo(), drvprimarykeys(), drvsetpos(), drvspecialcolumns(), drvstatistics(), drvtableprivileges(), drvtables(), freeresult(), getrowdata(), mkresultset(), s3stmt_step(), and SQLRowCount().

int* stmt::oemcp
 

True for Win32 OEM CP translation.

Definition at line 238 of file sqlite3odbc.h.

Referenced by drvallocstmt(), drvputdata(), getrowdata(), setposbind(), and setupparam().

int stmt::one_tbl
 

Flag for single table (> 0).

Definition at line 293 of file sqlite3odbc.h.

Referenced by drvallocstmt(), drvbulkoperations(), drvsetpos(), fixupdyncols(), and freeresult().

int* stmt::ov3
 

True for SQL_OV_ODBC3.

Definition at line 237 of file sqlite3odbc.h.

Referenced by chkunbound(), drvallocstmt(), drvbindcol(), drvbindparam(), drvbulkoperations(), drvcolattributes(), drvcolumns(), drvdescribecol(), drvforeignkeys(), drvfreestmt(), drvgettypeinfo(), drvprimarykeys(), drvsetcursorname(), drvsetpos(), drvsetstmtattr(), drvspecialcolumns(), drvstatistics(), fixupdyncols(), getrowdata(), mkresultset(), noconn(), nomem(), s3stmt_start(), s3stmt_step(), setposbind(), setposibind(), setupparam(), SQLDescribeParam(), SQLGetData(), and starttran().

SQLULEN stmt::paramset_count
 

Internal for paramset.

Definition at line 274 of file sqlite3odbc.h.

Referenced by drvsetstmtattr().

SQLUINTEGER stmt::paramset_nrows
 

Row count for paramset handling.

Definition at line 275 of file sqlite3odbc.h.

SQLULEN stmt::paramset_size
 

SQL_ATTR_PARAMSET_SIZE.

Definition at line 273 of file sqlite3odbc.h.

Referenced by drvallocstmt(), drvgetstmtattr(), and drvsetstmtattr().

SQLULEN* stmt::parm_bind_offs
 

SQL_ATTR_PARAM_BIND_OFFSET_PTR.

Definition at line 280 of file sqlite3odbc.h.

Referenced by drvgetstmtattr(), and drvsetstmtattr().

SQLULEN stmt::parm_bind_type
 

SQL_ATTR_PARAM_BIND_TYPE.

Definition at line 284 of file sqlite3odbc.h.

Referenced by drvallocstmt(), drvgetstmtattr(), and drvsetstmtattr().

SQLUSMALLINT* stmt::parm_oper
 

SQL_ATTR_PARAM_OPERATION_PTR.

Definition at line 281 of file sqlite3odbc.h.

Referenced by drvgetstmtattr(), and drvsetstmtattr().

SQLULEN* stmt::parm_proc
 

SQL_ATTR_PARAMS_PROCESSED_PTR.

Definition at line 283 of file sqlite3odbc.h.

Referenced by drvgetstmtattr(), and drvsetstmtattr().

SQLUSMALLINT* stmt::parm_status
 

SQL_ATTR_PARAMS_STATUS_PTR.

Definition at line 282 of file sqlite3odbc.h.

Referenced by drvgetstmtattr(), and drvsetstmtattr().

int stmt::pdcount
 

SQLParamData() counter.

Definition at line 254 of file sqlite3odbc.h.

Referenced by drvputdata(), and SQLParamData().

SQLCHAR* stmt::query
 

Current query, raw string.

Definition at line 236 of file sqlite3odbc.h.

Referenced by drvputdata(), freestmt(), and s3stmt_start().

SQLULEN stmt::retr_data
 

SQL_ATTR_RETRIEVE_DATA.

Definition at line 266 of file sqlite3odbc.h.

Referenced by drvallocstmt(), drvgetstmtattr(), drvgetstmtoption(), drvsetstmtattr(), drvsetstmtoption(), and getrowdata().

SQLULEN* stmt::row_count
 

Row count pointer.

Definition at line 271 of file sqlite3odbc.h.

Referenced by drvfetchscroll(), drvgetstmtattr(), and drvsetstmtattr().

SQLULEN stmt::row_count0
 

Row count.

Definition at line 272 of file sqlite3odbc.h.

Referenced by drvfetchscroll(), and SQLExtendedFetch().

SQLUSMALLINT* stmt::row_status
 

Row status pointer.

Definition at line 268 of file sqlite3odbc.h.

Referenced by drvbulkoperations(), drvfetchscroll(), drvgetstmtattr(), drvsetpos(), drvsetstmtattr(), and SQLExtendedFetch().

SQLUSMALLINT* stmt::row_status0
 

Internal status array.

Definition at line 269 of file sqlite3odbc.h.

Referenced by dofetchbind(), drvallocstmt(), drvbulkoperations(), drvfetchscroll(), drvsetpos(), drvsetstmtattr(), drvsetstmtoption(), freestmt(), setposrefr(), and SQLExtendedFetch().

SQLUSMALLINT stmt::row_status1
 

Internal status array for 1 row rowsets.

Definition at line 270 of file sqlite3odbc.h.

Referenced by drvallocstmt(), drvsetstmtattr(), drvsetstmtoption(), and freestmt().

void(* stmt::rowfree)()
 

Free function for rows.

Referenced by drvcolumns(), drvforeignkeys(), drvgettypeinfo(), drvprimarykeys(), drvspecialcolumns(), drvstatistics(), drvtableprivileges(), drvtables(), freeresult(), and s3stmt_step().

int stmt::rowp
 

Current result row.

Definition at line 256 of file sqlite3odbc.h.

Referenced by dofetchbind(), drvfetchscroll(), drvgetstmtattr(), drvgetstmtoption(), drvsetpos(), drvtableprivileges(), drvtables(), getrowdata(), mkresultset(), setposrefr(), and SQLGetData().

int stmt::rowprs
 

Current start row of rowset.

Definition at line 257 of file sqlite3odbc.h.

Referenced by drvfetchscroll(), drvtableprivileges(), drvtables(), mkresultset(), setposibind(), and setposrefr().

char** stmt::rows
 

2-dim array, result set

Definition at line 258 of file sqlite3odbc.h.

Referenced by dofetchbind(), drvcolumns(), drvfetchscroll(), drvforeignkeys(), drvgettypeinfo(), drvprimarykeys(), drvsetpos(), drvspecialcolumns(), drvstatistics(), drvtableprivileges(), drvtables(), freeresult(), getrowdata(), mktypeinfo(), s3stmt_step(), setposibind(), and SQLGetData().

SQLULEN stmt::rowset_size
 

Size of rowset.

Definition at line 267 of file sqlite3odbc.h.

Referenced by drvallocstmt(), drvbulkoperations(), drvfetchscroll(), drvgetstmtattr(), drvgetstmtoption(), drvsetpos(), drvsetstmtattr(), drvsetstmtoption(), freestmt(), and SQLExtendedFetch().

sqlite3_stmt* stmt::s3stmt
 

SQLite statement handle or NULL.

Definition at line 286 of file sqlite3odbc.h.

Referenced by drvfetchscroll(), drvgetstmtattr(), drvgetstmtoption(), drvgettable(), s3stmt_drop(), s3stmt_end(), s3stmt_start(), and s3stmt_step().

int stmt::s3stmt_noreset
 

False when sqlite3_reset() needed.

Definition at line 287 of file sqlite3odbc.h.

Referenced by drvgettable(), s3stmt_end(), s3stmt_start(), and s3stmt_step().

int stmt::s3stmt_rownum
 

Current row number.

Definition at line 288 of file sqlite3odbc.h.

Referenced by drvfetchscroll(), drvgetstmtattr(), drvgetstmtoption(), s3stmt_drop(), s3stmt_end(), s3stmt_start(), and s3stmt_step().

char stmt::sqlstate[6]
 

SQL state for SQLError().

Definition at line 261 of file sqlite3odbc.h.

Referenced by drvgetdiagfield(), drvgetdiagrec(), and setstat().

The documentation for this struct was generated from the following file:
Generated on 23 Oct 2023 by doxygen.
Contact: chw@ch-werner.de