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 227 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 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.

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.

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().

Field Documentation

char* stmt::bincache
 

Cache for blob data.

Definition at line 282 of file sqlite3odbc.h.

Referenced by freeresult(), and getrowdata().

char* stmt::bincell
 

Cache for blob data.

Definition at line 281 of file sqlite3odbc.h.

Referenced by freeresult(), and getrowdata().

SQLULEN* stmt::bind_offs
 

SQL_ATTR_ROW_BIND_OFFSET_PTR.

Definition at line 270 of file sqlite3odbc.h.

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

SQLULEN stmt::bind_type
 

SQL_ATTR_ROW_BIND_TYPE.

Definition at line 269 of file sqlite3odbc.h.

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

BINDCOL* stmt::bindcols
 

Array of bound columns.

Definition at line 242 of file sqlite3odbc.h.

Referenced by dofetchbind(), drvbindcol(), drvfetchscroll(), freeresult(), getrowdata(), mkbindcols(), and unbindcols().

BINDPARM* stmt::bindparms
 

Array of bound parameters.

Definition at line 245 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 283 of file sqlite3odbc.h.

Referenced by freeresult(), and getrowdata().

int stmt::bkmrk
 

True when bookmarks used.

Definition at line 240 of file sqlite3odbc.h.

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

BINDCOL stmt::bkmrkcol
 

Bookmark bound column.

Definition at line 241 of file sqlite3odbc.h.

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

COL* stmt::cols
 

Result column array.

Definition at line 237 of file sqlite3odbc.h.

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

SQLCHAR stmt::cursorname[32]
 

Cursor name.

Definition at line 230 of file sqlite3odbc.h.

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

int stmt::curtype
 

Cursor type.

Definition at line 277 of file sqlite3odbc.h.

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

HDBC stmt::dbc
 

Pointer to DBC.

Definition at line 229 of file sqlite3odbc.h.

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

int stmt::dcols
 

Number of entries in dyncols.

Definition at line 239 of file sqlite3odbc.h.

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

int stmt::dobigint
 

Force SQL_BIGINT for INTEGER columns.

Definition at line 256 of file sqlite3odbc.h.

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

COL* stmt::dyncols
 

Column array, but malloc()ed.

Definition at line 238 of file sqlite3odbc.h.

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

int stmt::guessed_types
 

Flag for drvprepare()/drvexecute().

Definition at line 284 of file sqlite3odbc.h.

Referenced by drvgettable_row().

int stmt::isselect
 

> 0 if query is a SELECT statement

Definition at line 235 of file sqlite3odbc.h.

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

int* stmt::jdconv
 

True for julian day conversion.

Definition at line 234 of file sqlite3odbc.h.

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

SQLCHAR stmt::logmsg[1024]
 

Message for SQLError().

Definition at line 254 of file sqlite3odbc.h.

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

int stmt::longnames
 

Don't shorten column names.

Definition at line 257 of file sqlite3odbc.h.

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

SQLULEN stmt::max_rows
 

SQL_ATTR_MAX_ROWS.

Definition at line 268 of file sqlite3odbc.h.

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

int stmt::naterr
 

Native error code.

Definition at line 252 of file sqlite3odbc.h.

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

int stmt::nbindcols
 

Number of entries in bindcols.

Definition at line 243 of file sqlite3odbc.h.

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

int stmt::nbindparms
 

Number bound parameters.

Definition at line 244 of file sqlite3odbc.h.

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

int stmt::ncols
 

Number of result columns.

Definition at line 236 of file sqlite3odbc.h.

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

struct stmt* stmt::next
 

Linkage for STMT list in DBC.

Definition at line 228 of file sqlite3odbc.h.

Referenced by drvallocstmt(), and freestmt().

int stmt::nowchar[2]
 

Don't try to use WCHAR.

Definition at line 255 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 246 of file sqlite3odbc.h.

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

int stmt::nrows
 

Number of result rows.

Definition at line 248 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 233 of file sqlite3odbc.h.

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

int* stmt::ov3
 

True for SQL_OV_ODBC3.

Definition at line 232 of file sqlite3odbc.h.

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

SQLULEN stmt::paramset_count
 

Internal for paramset.

Definition at line 266 of file sqlite3odbc.h.

Referenced by drvsetstmtattr().

SQLUINTEGER stmt::paramset_nrows
 

Row count for paramset handling.

Definition at line 267 of file sqlite3odbc.h.

SQLULEN stmt::paramset_size
 

SQL_ATTR_PARAMSET_SIZE.

Definition at line 265 of file sqlite3odbc.h.

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

SQLULEN* stmt::parm_bind_offs
 

SQL_ATTR_PARAM_BIND_OFFSET_PTR.

Definition at line 272 of file sqlite3odbc.h.

Referenced by drvgetstmtattr(), and drvsetstmtattr().

SQLULEN stmt::parm_bind_type
 

SQL_ATTR_PARAM_BIND_TYPE.

Definition at line 276 of file sqlite3odbc.h.

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

SQLUSMALLINT* stmt::parm_oper
 

SQL_ATTR_PARAM_OPERATION_PTR.

Definition at line 273 of file sqlite3odbc.h.

Referenced by drvgetstmtattr(), and drvsetstmtattr().

SQLULEN* stmt::parm_proc
 

SQL_ATTR_PARAMS_PROCESSED_PTR.

Definition at line 275 of file sqlite3odbc.h.

Referenced by drvgetstmtattr(), and drvsetstmtattr().

SQLUSMALLINT* stmt::parm_status
 

SQL_ATTR_PARAMS_STATUS_PTR.

Definition at line 274 of file sqlite3odbc.h.

Referenced by drvgetstmtattr(), and drvsetstmtattr().

int stmt::pdcount
 

SQLParamData() counter.

Definition at line 247 of file sqlite3odbc.h.

Referenced by drvputdata(), and SQLParamData().

SQLCHAR* stmt::query
 

Current query, raw string.

Definition at line 231 of file sqlite3odbc.h.

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

SQLULEN stmt::retr_data
 

SQL_ATTR_RETRIEVE_DATA.

Definition at line 258 of file sqlite3odbc.h.

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

SQLULEN* stmt::row_count
 

Row count pointer.

Definition at line 263 of file sqlite3odbc.h.

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

SQLULEN stmt::row_count0
 

Row count.

Definition at line 264 of file sqlite3odbc.h.

Referenced by drvfetchscroll(), and SQLExtendedFetch().

SQLUSMALLINT* stmt::row_status
 

Row status pointer.

Definition at line 260 of file sqlite3odbc.h.

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

SQLUSMALLINT* stmt::row_status0
 

Internal status array.

Definition at line 261 of file sqlite3odbc.h.

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

SQLUSMALLINT stmt::row_status1
 

Internal status array for 1 row rowsets.

Definition at line 262 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 249 of file sqlite3odbc.h.

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

char** stmt::rows
 

2-dim array, result set

Definition at line 250 of file sqlite3odbc.h.

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

SQLULEN stmt::rowset_size
 

Size of rowset.

Definition at line 259 of file sqlite3odbc.h.

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

sqlite3_stmt* stmt::s3stmt
 

SQLite statement handle or NULL.

Definition at line 278 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 279 of file sqlite3odbc.h.

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

int stmt::s3stmt_rownum
 

Current row number.

Definition at line 280 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 253 of file sqlite3odbc.h.

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

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