sqlite3odbc.c File Reference

Detailed Description

SQLite3 ODBC Driver main module.

Id: sqlite3odbc.c,v 1.176 2016/11/20 19:00:52 chw Exp chw

See the file "license.terms" for information on usage and redistribution of this file and for a DISCLAIMER OF ALL WARRANTIES.

Definition in file sqlite3odbc.c.

#include "sqlite3odbc.h"
#include <sqlucode.h>
#include <odbcinst.h>

Go to the source code of this file.

Data Structures

struct dstr

Internal structure representing dynamic strings. More...

struct tblres

Internal structure for managing driver's sqlite3_get_table() implementation. More...

Defines

#define WINTERFACE

#define WCHARSUPPORT

#define ODBC_INI   ".odbc.ini"

#define DRIVER_VER_INFO   "0.0"

#define COLATTRIBUTE_LAST_ARG_TYPE   SQLPOINTER

#define SETSTMTOPTION_LAST_ARG_TYPE   SQLROWCOUNT

#define min(a, b)   ((a) < (b) ? (a) : (b))

#define max(a, b)   ((a) < (b) ? (b) : (a))

#define PTRDIFF_T   int

#define array_size(x)   (sizeof (x) / sizeof (x[0]))

#define stringify1(s)   #s

#define stringify(s)   stringify1(s)

#define verinfo(maj, min, lev)   ((maj) << 16 | (min) << 8 | (lev))

#define SCOL_VARCHAR   SQL_WVARCHAR

#define SCOL_CHAR   SQL_WCHAR

#define ENV_MAGIC   0x53544145

#define DBC_MAGIC   0x53544144

#define DEAD_MAGIC   0xdeadbeef

#define xmalloc(x)   sqlite3_malloc(x)

#define xrealloc(x, y)   sqlite3_realloc(x, y)

#define xfree(x)   sqlite3_free(x)

#define xstrdup(x)   strdup_(x)

#define HDBC_LOCK(hdbc)

#define HDBC_UNLOCK(hdbc)

#define HSTMT_LOCK(hdbc)

#define HSTMT_UNLOCK(hdbc)

#define ISDIGIT(c)   ((c) && strchr(digit_chars, (c)) != NULL)

#define ISSPACE(c)   ((c) && strchr(space_chars, (c)) != NULL)

#define drvgetgpps(d)

#define drvrelgpps(d)

#define strmak(dst, src, max, lenp)

#define SET_EXISTS(x)   flags[(x) >> 4] |= (1 << ((x) & 0xF))

#define CLR_EXISTS(x)   flags[(x) >> 4] &= ~(1 << ((x) & 0xF))

Typedefs

typedef struct tblres TBLRES

Functions

static int TOLOWER (int c)

static void dbtraceapi (DBC *d, char *fn, const char *sql)

Trace function for SQLite API calls.

static void freedyncols (STMT *s)

Free dynamically allocated column descriptions of STMT.

static void freeresult (STMT *s, int clrcols)

Free statement's result.

static void freerows (char **rowp)

Free counted array of char pointers.

static void unbindcols (STMT *s)

Reset bound columns to unbound state.

static void s3stmt_drop (STMT *s)

Drop running sqlite statement in STMT.

static SQLRETURN drvexecute (SQLHSTMT stmt, int initial)

static SQLRETURN freestmt (HSTMT stmt)

static SQLRETURN mkbindcols (STMT *s, int ncols)

Reallocate space for bound columns.

static SQLRETURN setupdyncols (STMT *s, sqlite3_stmt *s3stmt, int *ncolsp)

static SQLRETURN setupparbuf (STMT *s, BINDPARM *p)

Setup parameter buffer for deferred parameter.

static SQLRETURN starttran (STMT *s)

Start transaction when autocommit off.

static SQLRETURN setupparam (STMT *s, char *sql, int pnum)

Setup SQLite3 parameter for statement parameter.

static SQLRETURN getrowdata (STMT *s, SQLUSMALLINT col, SQLSMALLINT otype, SQLPOINTER val, SQLINTEGER len, SQLLEN *lenp, int partial)

Internal function to retrieve row data, used by SQLFetch() and friends and SQLGetData().

static char * strdup_ (const char *str)

Duplicate string using xmalloc().

static dstr * dsappend (dstr *dsp, const char *str)

Append string to dynamic string.

static dstr * dsappendq (dstr *dsp, const char *str)

Append a string double quoted to dynamic string.

static const char * dsval (dstr *dsp)

Return dynamic string's value.

static int dserr (dstr *dsp)

Check error on dynamic string.

static void dsfree (dstr *dsp)

Free dynamic string.

static int uc_strlen (SQLWCHAR *str)

Return length of UNICODE string.

static SQLWCHAR * uc_strncpy (SQLWCHAR *dest, SQLWCHAR *src, int len)

Copy UNICODE string like strncpy().

static void uc_from_utf_buf (unsigned char *str, int len, SQLWCHAR *uc, int ucLen)

Make UNICODE string from UTF8 string into buffer.

static SQLWCHAR * uc_from_utf (unsigned char *str, int len)

Make UNICODE string from UTF8 string.

static char * uc_to_utf (SQLWCHAR *str, int len)

Make UTF8 string from UNICODE string.

static char * uc_to_utf_c (SQLWCHAR *str, int len)

Make UTF8 string from UNICODE string.

static void uc_free (void *str)

Free converted UTF8 or UNICODE string.

static void s3bind (DBC *d, sqlite3_stmt *stmt, int nparams, BINDPARM *p)

static int drvgettable_row (TBLRES *t, int ncol, int rc)

static int drvgettable (STMT *s, const char *sql, char ***resp, int *nrowp, int *ncolp, char **errp, int nparam, BINDPARM *p)

static void setstatd (DBC *d, int naterr, char *msg, char *st,...)

Set error message and SQL state on DBC.

static void setstat (STMT *s, int naterr, char *msg, char *st,...)

Set error message and SQL state on statement.

static SQLRETURN drvunimpldbc (HDBC dbc)

Report IM001 (not implemented) SQL error code for HDBC.

static SQLRETURN drvunimplstmt (HSTMT stmt)

Report IM001 (not implemented) SQL error code for HSTMT.

static void freep (void *x)

Free memory given pointer to memory pointer.

static SQLRETURN nomem (STMT *s)

Report S1000 (out of memory) SQL error given STMT.

static SQLRETURN noconn (STMT *s)

Report S1000 (not connected) SQL error given STMT.

static double ln_strtod (const char *data, char **endp)

Internal locale neutral strtod function.

static char * unquote (char *str)

Strip quotes from quoted string in-place.

static int unescpat (char *str)

Unescape search pattern for e.g.

static int namematch (char *str, char *pat, int esc)

SQL LIKE string match with optional backslash escape handling.

static int busy_handler (void *udata, int count)

Busy callback for SQLite.

static int setsqliteopts (sqlite3 *x, DBC *d)

Set SQLite options (PRAGMAs) given SQLite handle.

static int mapsqltype (const char *typename, int *nosign, int ov3, int nowchar, int dobigint)

Map SQL field type from string to ODBC integer type code.

static void getmd (const char *typename, int sqltype, int *mp, int *dp)

Get maximum display size and number of digits after decimal point from field type specification.

static int mapdeftype (int type, int stype, int nosign, int nowchar)

Map SQL_C_DEFAULT to proper C type.

static char * fixupsql (char *sql, int sqlLen, int cte, int *nparam, int *isselect, char **errmsg)

Fixup query string with optional parameter markers.

static int findcol (char **cols, int ncols, char *name)

Find column given name in string array.

static void fixupdyncols (STMT *s, DBC *d)

Fixup column information for a running statement.

static void convJD2YMD (double jd, DATE_STRUCT *ds)

Convert julian day to year/month/day.

static void convJD2HMS (double jd, TIME_STRUCT *ts, int *fp)

Convert julian day to hour/minute/second.

static int getmdays (int year, int month)

Return number of month days.

static int str2date (int jdconv, char *str, DATE_STRUCT *ds)

Convert string to ODBC DATE_STRUCT.

static int str2time (int jdconv, char *str, TIME_STRUCT *ts)

Convert string to ODBC TIME_STRUCT.

static int str2timestamp (int jdconv, char *str, TIMESTAMP_STRUCT *tss)

Convert string to ODBC TIMESTAMP_STRUCT.

static int getbool (char *string)

Get boolean flag from string.

static void blob_import (sqlite3_context *ctx, int nargs, sqlite3_value **args)

SQLite function to import a BLOB from a file.

static void blob_export (sqlite3_context *ctx, int nargs, sqlite3_value **args)

SQLite function to export a BLOB to a file.

static void dbtrace (void *arg, const char *msg, sqlite_uint64 et)

SQLite trace or profile callback.

static void dbtracerc (DBC *d, int rc, char *err)

Trace function for SQLite return codes.

static SQLRETURN dbopen (DBC *d, char *name, int isu, char *dsn, char *sflag, char *spflag, char *ntflag, char *jmode, char *busy)

Open SQLite database file given file name and flags.

static void dbloadext (DBC *d, char *exts)

Load SQLite extension modules, if any.

static char * s3stmt_coltype (sqlite3_stmt *s3stmt, int col, DBC *d, int *guessed_types)

Find out column type.

static int s3stmt_step (STMT *s)

Do one sqlite statement step gathering one result row.

static void s3stmt_end (STMT *s)

Stop running sqlite statement.

static void s3stmt_end_if (STMT *s)

Conditionally stop running sqlite statement.

static SQLRETURN s3stmt_start (STMT *s)

Start sqlite statement for execution of SELECT statement.

SQLRETURN SQL_API SQLDataSourcesW (SQLHENV env, SQLUSMALLINT dir, SQLWCHAR *srvname, SQLSMALLINT buflen1, SQLSMALLINT *lenp1, SQLWCHAR *desc, SQLSMALLINT buflen2, SQLSMALLINT *lenp2)

Function not implemented.

SQLRETURN SQL_API SQLDriversW (SQLHENV env, SQLUSMALLINT dir, SQLWCHAR *drvdesc, SQLSMALLINT descmax, SQLSMALLINT *desclenp, SQLWCHAR *drvattr, SQLSMALLINT attrmax, SQLSMALLINT *attrlenp)

Function not implemented.

SQLRETURN SQL_API SQLBrowseConnectW (SQLHDBC dbc, SQLWCHAR *connin, SQLSMALLINT conninLen, SQLWCHAR *connout, SQLSMALLINT connoutMax, SQLSMALLINT *connoutLen)

Function not implemented.

static SQLRETURN drvputdata (SQLHSTMT stmt, SQLPOINTER data, SQLLEN len)

Internal put (partial) parameter data into executing statement.

SQLRETURN SQL_API SQLPutData (SQLHSTMT stmt, SQLPOINTER data, SQLLEN len)

Put (partial) parameter data into executing statement.

static SQLRETURN freeparams (STMT *s)

Clear out parameter bindings, if any.

static SQLRETURN drvbindparam (SQLHSTMT stmt, SQLUSMALLINT pnum, SQLSMALLINT iotype, SQLSMALLINT buftype, SQLSMALLINT ptype, SQLUINTEGER coldef, SQLSMALLINT scale, SQLPOINTER data, SQLINTEGER buflen, SQLLEN *len)

Internal bind parameter on HSTMT.

SQLRETURN SQL_API SQLBindParameter (SQLHSTMT stmt, SQLUSMALLINT pnum, SQLSMALLINT iotype, SQLSMALLINT buftype, SQLSMALLINT ptype, SQLULEN coldef, SQLSMALLINT scale, SQLPOINTER data, SQLLEN buflen, SQLLEN *len)

Bind parameter on HSTMT.

SQLRETURN SQL_API SQLBindParam (SQLHSTMT stmt, SQLUSMALLINT pnum, SQLSMALLINT vtype, SQLSMALLINT ptype, SQLULEN lenprec, SQLSMALLINT scale, SQLPOINTER val, SQLLEN *lenp)

Bind parameter on HSTMT.

SQLRETURN SQL_API SQLNumParams (SQLHSTMT stmt, SQLSMALLINT *nparam)

Return number of parameters.

SQLRETURN SQL_API SQLParamData (SQLHSTMT stmt, SQLPOINTER *pind)

Retrieve next parameter for sending data to executing query.

SQLRETURN SQL_API SQLDescribeParam (SQLHSTMT stmt, SQLUSMALLINT pnum, SQLSMALLINT *dtype, SQLULEN *size, SQLSMALLINT *decdigits, SQLSMALLINT *nullable)

Return information about parameter.

SQLRETURN SQL_API SQLSetParam (SQLHSTMT stmt, SQLUSMALLINT par, SQLSMALLINT type, SQLSMALLINT sqltype, SQLULEN coldef, SQLSMALLINT scale, SQLPOINTER val, SQLLEN *nval)

Set information on parameter.

SQLRETURN SQL_API SQLParamOptions (SQLHSTMT stmt, SQLULEN rows, SQLULEN *rowp)

Function not implemented.

SQLRETURN SQL_API SQLGetDescFieldW (SQLHDESC handle, SQLSMALLINT recno, SQLSMALLINT fieldid, SQLPOINTER value, SQLINTEGER buflen, SQLINTEGER *strlen)

Function not implemented.

SQLRETURN SQL_API SQLSetDescFieldW (SQLHDESC handle, SQLSMALLINT recno, SQLSMALLINT fieldid, SQLPOINTER value, SQLINTEGER buflen)

Function not implemented.

SQLRETURN SQL_API SQLGetDescRecW (SQLHDESC handle, SQLSMALLINT recno, SQLWCHAR *name, SQLSMALLINT buflen, SQLSMALLINT *strlen, SQLSMALLINT *type, SQLSMALLINT *subtype, SQLLEN *len, SQLSMALLINT *prec, SQLSMALLINT *scale, SQLSMALLINT *nullable)

Function not implemented.

SQLRETURN SQL_API SQLSetDescRec (SQLHDESC handle, SQLSMALLINT recno, SQLSMALLINT type, SQLSMALLINT subtype, SQLLEN len, SQLSMALLINT prec, SQLSMALLINT scale, SQLPOINTER data, SQLLEN *strlen, SQLLEN *indicator)

Function not implemented.

static SQLRETURN mkresultset (HSTMT stmt, COL *colspec, int ncols, COL *colspec3, int ncols3, int *nret)

Setup empty result set from constant column specification.

static SQLRETURN drvtableprivileges (SQLHSTMT stmt, SQLCHAR *cat, SQLSMALLINT catLen, SQLCHAR *schema, SQLSMALLINT schemaLen, SQLCHAR *table, SQLSMALLINT tableLen)

Retrieve privileges on tables and/or views.

SQLRETURN SQL_API SQLTablePrivilegesW (SQLHSTMT stmt, SQLWCHAR *catalog, SQLSMALLINT catalogLen, SQLWCHAR *schema, SQLSMALLINT schemaLen, SQLWCHAR *table, SQLSMALLINT tableLen)

Retrieve privileges on tables and/or views (UNICODE version).

SQLRETURN SQL_API SQLColumnPrivilegesW (SQLHSTMT stmt, SQLWCHAR *catalog, SQLSMALLINT catalogLen, SQLWCHAR *schema, SQLSMALLINT schemaLen, SQLWCHAR *table, SQLSMALLINT tableLen, SQLWCHAR *column, SQLSMALLINT columnLen)

Retrieve privileges on columns (UNICODE version).

static SQLRETURN drvprimarykeys (SQLHSTMT stmt, SQLCHAR *cat, SQLSMALLINT catLen, SQLCHAR *schema, SQLSMALLINT schemaLen, SQLCHAR *table, SQLSMALLINT tableLen)

Internal retrieve information about indexed columns.

SQLRETURN SQL_API SQLPrimaryKeysW (SQLHSTMT stmt, SQLWCHAR *cat, SQLSMALLINT catLen, SQLWCHAR *schema, SQLSMALLINT schemaLen, SQLWCHAR *table, SQLSMALLINT tableLen)

Retrieve information about indexed columns (UNICODE version).

static SQLRETURN drvspecialcolumns (SQLHSTMT stmt, SQLUSMALLINT id, SQLCHAR *cat, SQLSMALLINT catLen, SQLCHAR *schema, SQLSMALLINT schemaLen, SQLCHAR *table, SQLSMALLINT tableLen, SQLUSMALLINT scope, SQLUSMALLINT nullable)

Internal retrieve information about indexed columns.

SQLRETURN SQL_API SQLSpecialColumnsW (SQLHSTMT stmt, SQLUSMALLINT id, SQLWCHAR *cat, SQLSMALLINT catLen, SQLWCHAR *schema, SQLSMALLINT schemaLen, SQLWCHAR *table, SQLSMALLINT tableLen, SQLUSMALLINT scope, SQLUSMALLINT nullable)

Retrieve information about indexed columns (UNICODE version).

static SQLRETURN SQL_API drvforeignkeys (SQLHSTMT stmt, SQLCHAR *PKcatalog, SQLSMALLINT PKcatalogLen, SQLCHAR *PKschema, SQLSMALLINT PKschemaLen, SQLCHAR *PKtable, SQLSMALLINT PKtableLen, SQLCHAR *FKcatalog, SQLSMALLINT FKcatalogLen, SQLCHAR *FKschema, SQLSMALLINT FKschemaLen, SQLCHAR *FKtable, SQLSMALLINT FKtableLen)

Internal retrieve information about primary/foreign keys.

SQLRETURN SQL_API SQLForeignKeysW (SQLHSTMT stmt, SQLWCHAR *PKcatalog, SQLSMALLINT PKcatalogLen, SQLWCHAR *PKschema, SQLSMALLINT PKschemaLen, SQLWCHAR *PKtable, SQLSMALLINT PKtableLen, SQLWCHAR *FKcatalog, SQLSMALLINT FKcatalogLen, SQLWCHAR *FKschema, SQLSMALLINT FKschemaLen, SQLWCHAR *FKtable, SQLSMALLINT FKtableLen)

Retrieve information about primary/foreign keys (UNICODE version).

static SQLRETURN endtran (DBC *d, SQLSMALLINT comptype, int force)

Internal commit or rollback transaction.

static SQLRETURN drvendtran (SQLSMALLINT type, SQLHANDLE handle, SQLSMALLINT comptype)

Internal commit or rollback transaction.

SQLRETURN SQL_API SQLEndTran (SQLSMALLINT type, SQLHANDLE handle, SQLSMALLINT comptype)

Commit or rollback transaction.

SQLRETURN SQL_API SQLTransact (SQLHENV env, SQLHDBC dbc, SQLUSMALLINT type)

Commit or rollback transaction.

SQLRETURN SQL_API SQLCopyDesc (SQLHDESC source, SQLHDESC target)

Function not implemented.

SQLRETURN SQL_API SQLNativeSqlW (SQLHSTMT stmt, SQLWCHAR *sqlin, SQLINTEGER sqlinLen, SQLWCHAR *sql, SQLINTEGER sqlMax, SQLINTEGER *sqlLen)

Translate SQL string (UNICODE version).

SQLRETURN SQL_API SQLProceduresW (SQLHSTMT stmt, SQLWCHAR *catalog, SQLSMALLINT catalogLen, SQLWCHAR *schema, SQLSMALLINT schemaLen, SQLWCHAR *proc, SQLSMALLINT procLen)

Retrieve information about stored procedures (UNICODE version).

SQLRETURN SQL_API SQLProcedureColumnsW (SQLHSTMT stmt, SQLWCHAR *catalog, SQLSMALLINT catalogLen, SQLWCHAR *schema, SQLSMALLINT schemaLen, SQLWCHAR *proc, SQLSMALLINT procLen, SQLWCHAR *column, SQLSMALLINT columnLen)

Retrieve information about columns in result set of stored procedures (UNICODE version).

SQLRETURN SQL_API SQLGetEnvAttr (SQLHENV env, SQLINTEGER attr, SQLPOINTER val, SQLINTEGER len, SQLINTEGER *lenp)

Get information of HENV.

SQLRETURN SQL_API SQLSetEnvAttr (SQLHENV env, SQLINTEGER attr, SQLPOINTER val, SQLINTEGER len)

Set information in HENV.

static SQLRETURN drvgetdiagrec (SQLSMALLINT htype, SQLHANDLE handle, SQLSMALLINT recno, SQLCHAR *sqlstate, SQLINTEGER *nativeerr, SQLCHAR *msg, SQLSMALLINT buflen, SQLSMALLINT *msglen)

Internal get error message given handle (HENV, HDBC, or HSTMT).

SQLRETURN SQL_API SQLGetDiagRecW (SQLSMALLINT htype, SQLHANDLE handle, SQLSMALLINT recno, SQLWCHAR *sqlstate, SQLINTEGER *nativeerr, SQLWCHAR *msg, SQLSMALLINT buflen, SQLSMALLINT *msglen)

Get error message given handle (HENV, HDBC, or HSTMT) (UNICODE version).

static SQLRETURN drvgetdiagfield (SQLSMALLINT htype, SQLHANDLE handle, SQLSMALLINT recno, SQLSMALLINT id, SQLPOINTER info, SQLSMALLINT buflen, SQLSMALLINT *stringlen)

Get error record given handle (HDBC or HSTMT).

SQLRETURN SQL_API SQLGetDiagFieldW (SQLSMALLINT htype, SQLHANDLE handle, SQLSMALLINT recno, SQLSMALLINT id, SQLPOINTER info, SQLSMALLINT buflen, SQLSMALLINT *stringlen)

Get error record given handle (HDBC or HSTMT).

static SQLRETURN drvgetstmtattr (SQLHSTMT stmt, SQLINTEGER attr, SQLPOINTER val, SQLINTEGER bufmax, SQLINTEGER *buflen)

Internal get option of HSTMT.

SQLRETURN SQL_API SQLGetStmtAttrW (SQLHSTMT stmt, SQLINTEGER attr, SQLPOINTER val, SQLINTEGER bufmax, SQLINTEGER *buflen)

Get option of HSTMT (UNICODE version).

static SQLRETURN drvsetstmtattr (SQLHSTMT stmt, SQLINTEGER attr, SQLPOINTER val, SQLINTEGER buflen)

Internal set option on HSTMT.

SQLRETURN SQL_API SQLSetStmtAttrW (SQLHSTMT stmt, SQLINTEGER attr, SQLPOINTER val, SQLINTEGER buflen)

Set option on HSTMT (UNICODE version).

static SQLRETURN drvgetstmtoption (SQLHSTMT stmt, SQLUSMALLINT opt, SQLPOINTER param)

Internal get option of HSTMT.

SQLRETURN SQL_API SQLGetStmtOption (SQLHSTMT stmt, SQLUSMALLINT opt, SQLPOINTER param)

Get option of HSTMT.

SQLRETURN SQL_API SQLGetStmtOptionW (SQLHSTMT stmt, SQLUSMALLINT opt, SQLPOINTER param)

Get option of HSTMT (UNICODE version).

static SQLRETURN drvsetstmtoption (SQLHSTMT stmt, SQLUSMALLINT opt, SQLUINTEGER param)

Internal set option on HSTMT.

SQLRETURN SQL_API SQLSetStmtOption (SQLHSTMT stmt, SQLUSMALLINT opt, SETSTMTOPTION_LAST_ARG_TYPE param)

Set option on HSTMT.

SQLRETURN SQL_API SQLSetStmtOptionW (SQLHSTMT stmt, SQLUSMALLINT opt, SETSTMTOPTION_LAST_ARG_TYPE param)

Set option on HSTMT (UNICODE version).

static SQLRETURN chkunbound (STMT *s)

Check for unbound result columns.

static SQLRETURN setposbind (STMT *s, sqlite3_stmt *stmt, int i, int si, int rsi)

Internal handler to setup parameters for positional updates from bound user buffers.

static SQLRETURN setposibind (STMT *s, sqlite3_stmt *stmt, int i, int si, int rsi)

Internal handler to setup parameters for positional updates from driver side result set.

static SQLRETURN setposrefr (STMT *s, int rsi)

Internal handler to refresh user buffers from driver side result set.

static SQLRETURN drvsetpos (SQLHSTMT stmt, SQLSETPOSIROW row, SQLUSMALLINT op, SQLUSMALLINT lock)

Internal set position on result in HSTMT.

SQLRETURN SQL_API SQLSetPos (SQLHSTMT stmt, SQLSETPOSIROW row, SQLUSMALLINT op, SQLUSMALLINT lock)

Set position on result in HSTMT.

static SQLRETURN drvbulkoperations (SQLHSTMT stmt, SQLSMALLINT op)

Internal perform bulk operation on HSTMT.

SQLRETURN SQL_API SQLBulkOperations (SQLHSTMT stmt, SQLSMALLINT oper)

Perform bulk operation on HSTMT.

SQLRETURN SQL_API SQLSetScrollOptions (SQLHSTMT stmt, SQLUSMALLINT concur, SQLLEN rowkeyset, SQLUSMALLINT rowset)

Function not implemented.

static SQLRETURN drvgetinfo (SQLHDBC dbc, SQLUSMALLINT type, SQLPOINTER val, SQLSMALLINT valMax, SQLSMALLINT *valLen)

Internal return information about what this ODBC driver supports.

SQLRETURN SQL_API SQLGetInfoW (SQLHDBC dbc, SQLUSMALLINT type, SQLPOINTER val, SQLSMALLINT valMax, SQLSMALLINT *valLen)

Return information about what this ODBC driver supports.

SQLRETURN SQL_API SQLGetFunctions (SQLHDBC dbc, SQLUSMALLINT func, SQLUSMALLINT *flags)

Return information about supported ODBC API functions.

static SQLRETURN drvallocenv (SQLHENV *env)

Internal allocate HENV.

SQLRETURN SQL_API SQLAllocEnv (SQLHENV *env)

Allocate HENV.

static SQLRETURN drvfreeenv (SQLHENV env)

Internal free HENV.

SQLRETURN SQL_API SQLFreeEnv (SQLHENV env)

Free HENV.

static SQLRETURN drvallocconnect (SQLHENV env, SQLHDBC *dbc)

Internal allocate HDBC.

SQLRETURN SQL_API SQLAllocConnect (SQLHENV env, SQLHDBC *dbc)

Allocate HDBC.

static SQLRETURN drvfreeconnect (SQLHDBC dbc)

Internal free connection (HDBC).

SQLRETURN SQL_API SQLFreeConnect (SQLHDBC dbc)

Free connection (HDBC).

static SQLRETURN drvgetconnectattr (SQLHDBC dbc, SQLINTEGER attr, SQLPOINTER val, SQLINTEGER bufmax, SQLINTEGER *buflen)

Internal get connect attribute of HDBC.

SQLRETURN SQL_API SQLGetConnectAttrW (SQLHDBC dbc, SQLINTEGER attr, SQLPOINTER val, SQLINTEGER bufmax, SQLINTEGER *buflen)

Get connect attribute of HDBC (UNICODE version).

static SQLRETURN drvsetconnectattr (SQLHDBC dbc, SQLINTEGER attr, SQLPOINTER val, SQLINTEGER len)

Internal set connect attribute of HDBC.

SQLRETURN SQL_API SQLSetConnectAttrW (SQLHDBC dbc, SQLINTEGER attr, SQLPOINTER val, SQLINTEGER len)

Set connect attribute of HDBC (UNICODE version).

static SQLRETURN drvgetconnectoption (SQLHDBC dbc, SQLUSMALLINT opt, SQLPOINTER param)

Internal get connect option of HDBC.

SQLRETURN SQL_API SQLGetConnectOptionW (SQLHDBC dbc, SQLUSMALLINT opt, SQLPOINTER param)

Get connect option of HDBC (UNICODE version).

static SQLRETURN drvsetconnectoption (SQLHDBC dbc, SQLUSMALLINT opt, SQLUINTEGER param)

Internal set option on HDBC.

SQLRETURN SQL_API SQLSetConnectOptionW (SQLHDBC dbc, SQLUSMALLINT opt, SQLULEN param)

Set option on HDBC (UNICODE version).

static int getdsnattr (char *dsn, char *attr, char *out, int outLen)

Handling of SQLConnect() connection attributes for standalone operation without driver manager.

static SQLRETURN drvconnect (SQLHDBC dbc, SQLCHAR *dsn, SQLSMALLINT dsnLen, char *pwd, int pwdLen, int isu)

Internal connect to SQLite database.

SQLRETURN SQL_API SQLConnectW (SQLHDBC dbc, SQLWCHAR *dsn, SQLSMALLINT dsnLen, SQLWCHAR *uid, SQLSMALLINT uidLen, SQLWCHAR *pwd, SQLSMALLINT pwdLen)

Connect to SQLite database.

static SQLRETURN drvdisconnect (SQLHDBC dbc)

Internal disconnect given HDBC.

SQLRETURN SQL_API SQLDisconnect (SQLHDBC dbc)

Disconnect given HDBC.

static SQLRETURN drvdriverconnect (SQLHDBC dbc, SQLHWND hwnd, SQLCHAR *connIn, SQLSMALLINT connInLen, SQLCHAR *connOut, SQLSMALLINT connOutMax, SQLSMALLINT *connOutLen, SQLUSMALLINT drvcompl)

Internal standalone (w/o driver manager) database connect.

static SQLRETURN freestmt (SQLHSTMT stmt)

Internal free function for HSTMT.

static SQLRETURN drvallocstmt (SQLHDBC dbc, SQLHSTMT *stmt)

Allocate HSTMT given HDBC (driver internal version).

SQLRETURN SQL_API SQLAllocStmt (SQLHDBC dbc, SQLHSTMT *stmt)

Allocate HSTMT given HDBC.

static SQLRETURN drvfreestmt (SQLHSTMT stmt, SQLUSMALLINT opt)

Internal function to perform certain kinds of free/close on STMT.

SQLRETURN SQL_API SQLFreeStmt (SQLHSTMT stmt, SQLUSMALLINT opt)

Free HSTMT.

SQLRETURN SQL_API SQLCancel (SQLHSTMT stmt)

Cancel HSTMT closing cursor.

static SQLRETURN drvgetcursorname (SQLHSTMT stmt, SQLCHAR *cursor, SQLSMALLINT buflen, SQLSMALLINT *lenp)

Internal function to get cursor name of STMT.

SQLRETURN SQL_API SQLGetCursorNameW (SQLHSTMT stmt, SQLWCHAR *cursor, SQLSMALLINT buflen, SQLSMALLINT *lenp)

Get cursor name of STMT (UNICODE version).

static SQLRETURN drvsetcursorname (SQLHSTMT stmt, SQLCHAR *cursor, SQLSMALLINT len)

Internal function to set cursor name on STMT.

SQLRETURN SQL_API SQLSetCursorNameW (SQLHSTMT stmt, SQLWCHAR *cursor, SQLSMALLINT len)

Set cursor name on STMT (UNICODE version).

SQLRETURN SQL_API SQLCloseCursor (SQLHSTMT stmt)

Close open cursor.

SQLRETURN SQL_API SQLAllocHandle (SQLSMALLINT type, SQLHANDLE input, SQLHANDLE *output)

Allocate a HENV, HDBC, or HSTMT handle.

SQLRETURN SQL_API SQLFreeHandle (SQLSMALLINT type, SQLHANDLE h)

Free a HENV, HDBC, or HSTMT handle.

static SQLRETURN drvbindcol (SQLHSTMT stmt, SQLUSMALLINT col, SQLSMALLINT type, SQLPOINTER val, SQLLEN max, SQLLEN *lenp)

Internal bind C variable to column of result set.

SQLRETURN SQL_API SQLBindCol (SQLHSTMT stmt, SQLUSMALLINT col, SQLSMALLINT type, SQLPOINTER val, SQLLEN max, SQLLEN *lenp)

Bind C variable to column of result set.

static SQLRETURN drvtables (SQLHSTMT stmt, SQLCHAR *cat, SQLSMALLINT catLen, SQLCHAR *schema, SQLSMALLINT schemaLen, SQLCHAR *table, SQLSMALLINT tableLen, SQLCHAR *type, SQLSMALLINT typeLen)

Retrieve information on tables and/or views.

SQLRETURN SQL_API SQLTablesW (SQLHSTMT stmt, SQLWCHAR *cat, SQLSMALLINT catLen, SQLWCHAR *schema, SQLSMALLINT schemaLen, SQLWCHAR *table, SQLSMALLINT tableLen, SQLWCHAR *type, SQLSMALLINT typeLen)

Retrieve information on tables and/or views.

static SQLRETURN drvcolumns (SQLHSTMT stmt, SQLCHAR *cat, SQLSMALLINT catLen, SQLCHAR *schema, SQLSMALLINT schemaLen, SQLCHAR *table, SQLSMALLINT tableLen, SQLCHAR *col, SQLSMALLINT colLen)

Internal retrieve column information on table.

SQLRETURN SQL_API SQLColumnsW (SQLHSTMT stmt, SQLWCHAR *cat, SQLSMALLINT catLen, SQLWCHAR *schema, SQLSMALLINT schemaLen, SQLWCHAR *table, SQLSMALLINT tableLen, SQLWCHAR *col, SQLSMALLINT colLen)

Retrieve column information on table (UNICODE version).

static void mktypeinfo (STMT *s, int row, int asize, char *typename, int type, int tind)

Internal function to build up data type information as row in result set.

static int typeinfosort (const void *a, const void *b)

Helper function to sort type information.

static SQLRETURN drvgettypeinfo (SQLHSTMT stmt, SQLSMALLINT sqltype)

Internal return data type information.

SQLRETURN SQL_API SQLGetTypeInfoW (SQLHSTMT stmt, SQLSMALLINT sqltype)

Return data type information (UNICODE version).

static SQLRETURN drvstatistics (SQLHSTMT stmt, SQLCHAR *cat, SQLSMALLINT catLen, SQLCHAR *schema, SQLSMALLINT schemaLen, SQLCHAR *table, SQLSMALLINT tableLen, SQLUSMALLINT itype, SQLUSMALLINT resv)

Internal return statistic information on table indices.

SQLRETURN SQL_API SQLStatisticsW (SQLHSTMT stmt, SQLWCHAR *cat, SQLSMALLINT catLen, SQLWCHAR *schema, SQLSMALLINT schemaLen, SQLWCHAR *table, SQLSMALLINT tableLen, SQLUSMALLINT itype, SQLUSMALLINT resv)

Return statistic information on table indices (UNICODE version).

SQLRETURN SQL_API SQLGetData (SQLHSTMT stmt, SQLUSMALLINT col, SQLSMALLINT type, SQLPOINTER val, SQLLEN len, SQLLEN *lenp)

Retrieve row data after fetch.

static SQLRETURN dofetchbind (STMT *s, int rsi)

Internal: fetch and bind from statement's current row.

static SQLRETURN drvfetchscroll (SQLHSTMT stmt, SQLSMALLINT orient, SQLINTEGER offset)

Internal fetch function for SQLFetchScroll() and SQLExtendedFetch().

SQLRETURN SQL_API SQLFetch (SQLHSTMT stmt)

Fetch next result row.

SQLRETURN SQL_API SQLFetchScroll (SQLHSTMT stmt, SQLSMALLINT orient, SQLLEN offset)

Fetch result row with scrolling.

SQLRETURN SQL_API SQLExtendedFetch (SQLHSTMT stmt, SQLUSMALLINT orient, SQLROWOFFSET offset, SQLROWSETSIZE *rowcount, SQLUSMALLINT *rowstatus)

Fetch result row with scrolling and row status.

SQLRETURN SQL_API SQLRowCount (SQLHSTMT stmt, SQLLEN *nrows)

Return number of affected rows of HSTMT.

SQLRETURN SQL_API SQLNumResultCols (SQLHSTMT stmt, SQLSMALLINT *ncols)

Return number of columns of result set given HSTMT.

static SQLRETURN drvdescribecol (SQLHSTMT stmt, SQLUSMALLINT col, SQLCHAR *name, SQLSMALLINT nameMax, SQLSMALLINT *nameLen, SQLSMALLINT *type, SQLULEN *size, SQLSMALLINT *digits, SQLSMALLINT *nullable)

Internal describe column information.

SQLRETURN SQL_API SQLDescribeColW (SQLHSTMT stmt, SQLUSMALLINT col, SQLWCHAR *name, SQLSMALLINT nameMax, SQLSMALLINT *nameLen, SQLSMALLINT *type, SQLULEN *size, SQLSMALLINT *digits, SQLSMALLINT *nullable)

Describe column information (UNICODE version).

static SQLRETURN drvcolattributes (SQLHSTMT stmt, SQLUSMALLINT col, SQLUSMALLINT id, SQLPOINTER val, SQLSMALLINT valMax, SQLSMALLINT *valLen, SQLLEN *val2)

Internal retrieve column attributes.

Variables

static const char * xdigits = "0123456789ABCDEFabcdef"

static const char upper_chars [] = "ABCDEFGHIJKLMNOPQRSTUVWXYZ"

static const char lower_chars [] = "abcdefghijklmnopqrstuvwxyz"

static const char digit_chars [] = "0123456789"

static const char space_chars [] = " \f\n\r\t\v"

static COL tablePrivSpec2 []

Columns for result set of SQLTablePrivileges().

static COL tablePrivSpec3 []

static COL colPrivSpec2 []

Columns for result set of SQLColumnPrivileges().

static COL colPrivSpec3 []

static COL pkeySpec2 []

Columns for result set of SQLPrimaryKeys().

static COL pkeySpec3 []

static COL scolSpec2 []

Columns for result set of SQLSpecialColumns().

static COL scolSpec3 []

static COL fkeySpec2 []

Columns for result set of SQLForeignKeys().

static COL fkeySpec3 []

static COL procSpec2 []

Columns for result set of SQLProcedures().

static COL procSpec3 []

static COL procColSpec2 []

Columns for result set of SQLProcedureColumns().

static COL procColSpec3 []

static COL tableSpec2 []

Columns for result set of SQLTables().

static COL tableSpec3 []

static COL colSpec2 []

Columns for result set of SQLColumns().

static COL colSpec3 []

static COL typeSpec2 []

Columns for result set of SQLGetTypeInfo().

static COL typeSpec3 []

static COL statSpec2 []

Columns for result set of SQLStatistics().

static COL statSpec3 []

Define Documentation

#define array_size ( x ) (sizeof (x) / sizeof (x[0]))

Definition at line 233 of file sqlite3odbc.c.

Referenced by drvcolumns(), drvforeignkeys(), drvgettypeinfo(), drvprimarykeys(), drvspecialcolumns(), drvstatistics(), drvtableprivileges(), drvtables(), fixupdyncols(), fixupsql(), SQLColumnPrivilegesW(), SQLGetFunctions(), SQLProcedureColumnsW(), and SQLProceduresW().

#define CLR_EXISTS ( x ) flags[(x) >> 4] &= ~(1 << ((x) & 0xF))

#define COLATTRIBUTE_LAST_ARG_TYPE SQLPOINTER

Definition at line 216 of file sqlite3odbc.c.

#define DBC_MAGIC 0x53544144

Definition at line 263 of file sqlite3odbc.c.

Referenced by drvallocconnect(), drvallocstmt(), drvconnect(), drvdisconnect(), drvfreeconnect(), freestmt(), and SQLCancel().

#define DEAD_MAGIC 0xdeadbeef

Definition at line 264 of file sqlite3odbc.c.

Referenced by drvfreeconnect(), drvfreeenv(), and drvgetstmtattr().

#define DRIVER_VER_INFO "0.0"

Definition at line 209 of file sqlite3odbc.c.

Referenced by drvgetinfo().

#define drvgetgpps ( d )

Definition at line 1326 of file sqlite3odbc.c.

Referenced by drvallocconnect().

#define drvrelgpps ( d )

Definition at line 1327 of file sqlite3odbc.c.

Referenced by drvfreeconnect().

#define ENV_MAGIC 0x53544145

Definition at line 262 of file sqlite3odbc.c.

Referenced by drvallocconnect(), drvallocenv(), drvendtran(), drvfreeconnect(), drvfreeenv(), SQLAllocHandle(), SQLGetEnvAttr(), and SQLSetEnvAttr().

#define HDBC_LOCK ( hdbc )

Definition at line 530 of file sqlite3odbc.c.

Referenced by drvendtran(), drvfreeconnect(), drvgetdiagfield(), drvgetdiagrec(), SQLAllocHandle(), SQLAllocStmt(), SQLBrowseConnectW(), SQLConnectW(), SQLDisconnect(), SQLGetConnectAttrW(), SQLGetConnectOptionW(), SQLGetInfoW(), SQLSetConnectAttrW(), and SQLSetConnectOptionW().

#define HDBC_UNLOCK ( hdbc )

Definition at line 531 of file sqlite3odbc.c.

Referenced by drvendtran(), drvfreeconnect(), drvfreestmt(), drvgetdiagfield(), drvgetdiagrec(), SQLAllocHandle(), SQLAllocStmt(), SQLBrowseConnectW(), SQLConnectW(), SQLDisconnect(), SQLGetConnectAttrW(), SQLGetConnectOptionW(), SQLGetInfoW(), SQLSetConnectAttrW(), and SQLSetConnectOptionW().

#define HSTMT_LOCK ( hdbc )

Definition at line 532 of file sqlite3odbc.c.

Referenced by drvfreestmt(), drvgetdiagfield(), drvgetdiagrec(), SQLBindCol(), SQLBindParam(), SQLBindParameter(), SQLBulkOperations(), SQLColumnPrivilegesW(), SQLColumnsW(), SQLDescribeColW(), SQLDescribeParam(), SQLExtendedFetch(), SQLFetch(), SQLFetchScroll(), SQLForeignKeysW(), SQLGetCursorNameW(), SQLGetData(), SQLGetStmtAttrW(), SQLGetStmtOption(), SQLGetStmtOptionW(), SQLGetTypeInfoW(), SQLNativeSqlW(), SQLNumParams(), SQLNumResultCols(), SQLParamData(), SQLParamOptions(), SQLPrimaryKeysW(), SQLProcedureColumnsW(), SQLProceduresW(), SQLPutData(), SQLRowCount(), SQLSetCursorNameW(), SQLSetParam(), SQLSetPos(), SQLSetScrollOptions(), SQLSetStmtAttrW(), SQLSetStmtOption(), SQLSetStmtOptionW(), SQLSpecialColumnsW(), SQLStatisticsW(), SQLTablePrivilegesW(), and SQLTablesW().

#define HSTMT_UNLOCK ( hdbc )

#define ISDIGIT ( c ) ((c) && strchr(digit_chars, (c)) != NULL)

Definition at line 568 of file sqlite3odbc.c.

Referenced by str2date(), str2time(), and str2timestamp().

#define ISSPACE ( c ) ((c) && strchr(space_chars, (c)) != NULL)

Definition at line 577 of file sqlite3odbc.c.

Referenced by all_whitespace(), drvcolattributes(), drvgettable(), ends_with_semicolon(), fixupsql(), and process_input().

#define max	(	a,
		b		)	((a) < (b) ? (b) : (a))

Definition at line 227 of file sqlite3odbc.c.

Referenced by drvbindparam(), dsappend(), dsappendq(), and setsqliteopts().

#define min	(	a,
		b		)	((a) < (b) ? (a) : (b))

Definition at line 225 of file sqlite3odbc.c.

Referenced by csv_guess(), drvallocconnect(), drvcolumns(), drvconnect(), drvdriverconnect(), drvforeignkeys(), drvgetcursorname(), drvprimarykeys(), drvputdata(), drvsetcursorname(), drvspecialcolumns(), drvstatistics(), drvtableprivileges(), drvtables(), getdsnattr(), getrowdata(), SQLDescribeColW(), SQLGetConnectAttrW(), SQLGetCursorNameW(), SQLGetDiagFieldW(), SQLGetDiagRecW(), SQLGetInfoW(), and SQLNativeSqlW().

#define ODBC_INI ".odbc.ini"

Definition at line 205 of file sqlite3odbc.c.

Referenced by drvconnect(), and drvdriverconnect().

#define PTRDIFF_T int

Definition at line 230 of file sqlite3odbc.c.

Referenced by drvcolumns(), drvforeignkeys(), drvprimarykeys(), drvspecialcolumns(), drvstatistics(), freerows(), and s3stmt_step().

#define SCOL_CHAR SQL_WCHAR

Definition at line 256 of file sqlite3odbc.c.

#define SCOL_VARCHAR SQL_WVARCHAR

Definition at line 255 of file sqlite3odbc.c.

#define SET_EXISTS ( x ) flags[(x) >> 4] |= (1 << ((x) & 0xF))

Referenced by SQLGetFunctions().

#define SETSTMTOPTION_LAST_ARG_TYPE SQLROWCOUNT

Definition at line 221 of file sqlite3odbc.c.

#define stringify ( s ) stringify1(s)

Definition at line 236 of file sqlite3odbc.c.

Referenced by drvcolumns(), drvforeignkeys(), drvspecialcolumns(), drvstatistics(), and mktypeinfo().

#define stringify1 ( s ) #s

Definition at line 235 of file sqlite3odbc.c.

#define strmak	(	dst,
		src,
		max,
		lenp	)

Value:

{ \
    int len = strlen(src); \
    int cnt = min(len + 1, max); \
    strncpy(dst, src, cnt); \
    *lenp = (cnt > len) ? len : cnt; \
}

Definition at line 10899 of file sqlite3odbc.c.

Referenced by drvgetinfo().

#define verinfo	(	maj,
		min,
		lev	)	((maj) << 16 \| (min) << 8 \| (lev))

Definition at line 238 of file sqlite3odbc.c.

Referenced by drvallocconnect().

#define WCHARSUPPORT

Definition at line 185 of file sqlite3odbc.c.

Referenced by drvputdata().

#define WINTERFACE

Definition at line 184 of file sqlite3odbc.c.

#define xfree ( x ) sqlite3_free(x)

Definition at line 405 of file sqlite3odbc.c.

Referenced by drvfreeconnect(), drvfreeenv(), dsfree(), freep(), freestmt(), mapsqltype(), and uc_free().

#define xmalloc ( x ) sqlite3_malloc(x)

Definition at line 403 of file sqlite3odbc.c.

Referenced by drvallocconnect(), drvallocenv(), drvallocstmt(), drvbindparam(), drvcolumns(), drvforeignkeys(), drvgettable(), drvgettable_row(), drvgettypeinfo(), drvprimarykeys(), drvputdata(), drvsetstmtattr(), drvsetstmtoption(), drvspecialcolumns(), drvstatistics(), drvtables(), dsappend(), dsappendq(), fixupdyncols(), fixupsql(), getrowdata(), mapsqltype(), mkbindcols(), s3stmt_step(), setupparam(), setupparbuf(), strdup_(), uc_from_utf(), and uc_to_utf().

#define xrealloc	(	x,
		y		)	sqlite3_realloc(x, y)

Definition at line 404 of file sqlite3odbc.c.

Referenced by drvbindparam(), drvgettable_row(), dsappend(), dsappendq(), and mkbindcols().

#define xstrdup ( x ) strdup_(x)

Definition at line 406 of file sqlite3odbc.c.

Referenced by dbopen(), drvcolumns(), drvforeignkeys(), drvgettable_row(), drvprimarykeys(), drvspecialcolumns(), drvstatistics(), fixupdyncols(), and s3stmt_step().

Typedef Documentation

typedef struct tblres TBLRES

Function Documentation

static void blob_export	(	sqlite3_context *	ctx,
		int	nargs,
		sqlite3_value **	args
	)			`[static]`

SQLite function to export a BLOB to a file.

Parameters:

	ctx	function context
	nargs	number arguments
	args	arguments

Definition at line 3773 of file sqlite3odbc.c.

References uc_free().

Referenced by dbopen().

static void blob_import	(	sqlite3_context *	ctx,
		int	nargs,
		sqlite3_value **	args
	)			`[static]`

SQLite function to import a BLOB from a file.

Parameters:

	ctx	function context
	nargs	number arguments
	args	arguments

Definition at line 3703 of file sqlite3odbc.c.

References uc_free().

Referenced by dbopen().

static int busy_handler	(	void *	udata,
		int	count
	)			`[static]`

Busy callback for SQLite.

Parameters:

	udata	user data, pointer to DBC
	count	count of subsequenct calls

Returns:: true or false

Definition at line 2053 of file sqlite3odbc.c.

References dbc::busyint, dbc::t0, and dbc::timeout.

Referenced by endtran(), setsqliteopts(), and starttran().

static SQLRETURN chkunbound ( STMT * s ) [static]

Check for unbound result columns.

Parameters:

s

statement handle

Returns:: ODBC error code

Definition at line 9604 of file sqlite3odbc.c.

References stmt::bindcols, stmt::nbindcols, stmt::ncols, stmt::ov3, setstat(), BINDCOL::type, and BINDCOL::valp.

Referenced by drvbulkoperations(), and drvsetpos().

static void convJD2HMS	(	double	jd,
		TIME_STRUCT *	ts,
		int *	fp
	)			`[static]`

Convert julian day to hour/minute/second.

Parameters:

	jd	julian day as stored in database
	ts	output TIME_STRUCT
	fp	optional fractional part output

Definition at line 3056 of file sqlite3odbc.c.

Referenced by str2time(), and str2timestamp().

static void convJD2YMD	(	double	jd,
		DATE_STRUCT *	ds
	)			`[static]`

Convert julian day to year/month/day.

Parameters:

	jd	julian day as stored in database
	ds	output DATE_STRUCT

Definition at line 3028 of file sqlite3odbc.c.

Referenced by str2date(), and str2timestamp().

static void dbloadext	(	DBC *	d,
		char *	exts
	)			`[static]`

Load SQLite extension modules, if any.

Parameters:

	d	DBC pointer
	exts	string, comma separated extension names

Definition at line 4134 of file sqlite3odbc.c.

References dbc::sqlite.

Referenced by drvconnect(), and drvdriverconnect().

static SQLRETURN dbopen	(	DBC *	d,
		char *	name,
		int	isu,
		char *	dsn,
		char *	sflag,
		char *	spflag,
		char *	ntflag,
		char *	jmode,
		char *	busy
	)			`[static]`

Open SQLite database file given file name and flags.

Parameters:

	d	DBC pointer
	name	file name
	isu	true/false: file name is UTF8 encoded
	dsn	data source name
	sflag	STEPAPI flag
	spflag	SyncPragma string
	ntflag	NoTransaction string
	jmode	JournalMode string
	busy	busy/lock timeout

Returns:: ODBC error code

Definition at line 3920 of file sqlite3odbc.c.

References blob_export(), blob_import(), dbc::curtype, dbc::dbname, dbtrace(), dbc::dsn, freep(), getbool(), dbc::nocreat, dbc::ov3, dbc::pwd, dbc::pwdLen, setsqliteopts(), setstatd(), dbc::sqlite, dbc::step_enable, dbc::timeout, dbc::trace, dbc::trans_disable, uc_free(), and xstrdup.

Referenced by drvconnect(), and drvdriverconnect().

static void dbtrace	(	void *	arg,
		const char *	msg,
		sqlite_uint64	et
	)			`[static]`

SQLite trace or profile callback.

Parameters:

	arg	DBC pointer
	msg	log message, SQL text
	et	elapsed time

Definition at line 3838 of file sqlite3odbc.c.

References dbc::trace.

Referenced by dbopen().

static void dbtraceapi	(	DBC *	d,
		char *	fn,
		const char *	sql
	)			`[static]`

Trace function for SQLite API calls.

Parameters:

	d	pointer to database connection handle
	fn	SQLite function name
	sql	SQL string

Definition at line 3876 of file sqlite3odbc.c.

References dbc::trace.

Referenced by drvbulkoperations(), drvcolumns(), drvforeignkeys(), drvgettable(), drvprimarykeys(), drvsetpos(), drvspecialcolumns(), drvstatistics(), drvtableprivileges(), drvtables(), fixupdyncols(), s3stmt_drop(), s3stmt_end(), s3stmt_start(), and s3stmt_step().

static void dbtracerc	(	DBC *	d,
		int	rc,
		char *	err
	)			`[static]`

Trace function for SQLite return codes.

Parameters:

	d	pointer to database connection handle
	rc	SQLite return code
	err	error string or NULL

Definition at line 3896 of file sqlite3odbc.c.

References dbc::trace.

Referenced by drvbulkoperations(), drvsetpos(), endtran(), s3stmt_start(), and starttran().

static SQLRETURN dofetchbind	(	STMT *	s,
		int	rsi
	)			`[static]`

Internal: fetch and bind from statement's current row.

Parameters:

	s	statement pointer
	rsi	rowset index

Returns:: ODBC error code

Definition at line 16316 of file sqlite3odbc.c.

References stmt::bind_offs, stmt::bind_type, stmt::bindcols, stmt::bkmrk, stmt::bkmrkcol, getrowdata(), stmt::has_rowid, BINDCOL::lenp, BINDCOL::max, stmt::ncols, BINDCOL::offs, stmt::row_status0, stmt::rowp, stmt::rows, SQLLEN, BINDCOL::type, and BINDCOL::valp.

Referenced by drvfetchscroll().

static SQLRETURN drvallocconnect	(	SQLHENV	env,
		SQLHDBC *	dbc
	)			`[static]`

Internal allocate HDBC.

Parameters:

	env	environment handle
	dbc	pointer to database connection handle

Returns:: ODBC error code

Definition at line 11787 of file sqlite3odbc.c.

References dbc::autocommit, dbc::curtype, DBC_MAGIC, ENV::dbcs, drvgetgpps, dbc::env, ENV_MAGIC, dbc::magic, ENV::magic, min, dbc::next, dbc::oemcp, ENV::ov3, dbc::ov3, dbc::ov3val, verinfo, dbc::version, and xmalloc.

Referenced by SQLAllocConnect(), and SQLAllocHandle().

static SQLRETURN drvallocenv ( SQLHENV * env ) [static]

Internal allocate HENV.

Parameters:

env

pointer to environment handle

Returns:: ODBC error code

Definition at line 11693 of file sqlite3odbc.c.

References ENV::dbcs, ENV_MAGIC, ENV::magic, ENV::ov3, and xmalloc.

Referenced by SQLAllocEnv(), and SQLAllocHandle().

static SQLRETURN drvallocstmt	(	SQLHDBC	dbc,
		SQLHSTMT *	stmt
	)			`[static]`

Allocate HSTMT given HDBC (driver internal version).

Parameters:

	dbc	database connection handle
	stmt	pointer to statement handle

Returns:: ODBC error code

Definition at line 13165 of file sqlite3odbc.c.

References stmt::bind_offs, stmt::bind_type, stmt::bkmrk, stmt::bkmrkptr, stmt::cursorname, dbc::curtype, stmt::curtype, stmt::dbc, DBC_MAGIC, dbc::dobigint, stmt::dobigint, stmt::has_pk, stmt::has_rowid, dbc::jdconv, stmt::jdconv, dbc::longnames, stmt::longnames, dbc::magic, stmt::max_rows, stmt::next, dbc::nowchar, stmt::nowchar, dbc::oemcp, stmt::oemcp, stmt::one_tbl, dbc::ov3, stmt::ov3, stmt::paramset_size, stmt::parm_bind_type, stmt::retr_data, stmt::row_status0, stmt::row_status1, stmt::rowset_size, dbc::stmt, and xmalloc.

Referenced by SQLAllocHandle(), and SQLAllocStmt().

static SQLRETURN drvbindcol	(	SQLHSTMT	stmt,
		SQLUSMALLINT	col,
		SQLSMALLINT	type,
		SQLPOINTER	val,
		SQLLEN	max,
		SQLLEN *	lenp
	)			`[static]`

Internal bind C variable to column of result set.

Parameters:

	stmt	statement handle
	col	column number, starting at 1
	type	output type
	val	output buffer
	max	length of output buffer
	lenp	output length pointer

Returns:: ODBC error code

Definition at line 14322 of file sqlite3odbc.c.

References stmt::bindcols, stmt::bkmrk, stmt::bkmrkcol, stmt::cols, BINDCOL::lenp, mapdeftype(), BINDCOL::max, mkbindcols(), stmt::nowchar, BINDCOL::offs, stmt::ov3, setstat(), COL::type, BINDCOL::type, and BINDCOL::valp.

Referenced by SQLBindCol().

static SQLRETURN drvbindparam	(	SQLHSTMT	stmt,
		SQLUSMALLINT	pnum,
		SQLSMALLINT	iotype,
		SQLSMALLINT	buftype,
		SQLSMALLINT	ptype,
		SQLUINTEGER	coldef,
		SQLSMALLINT	scale,
		SQLPOINTER	data,
		SQLINTEGER	buflen,
		SQLLEN *	len
	)			`[static]`

Internal bind parameter on HSTMT.

Parameters:

	stmt	statement handle
	pnum	parameter number, starting at 1
	iotype	input/output type of parameter
	buftype	type of host variable
	ptype
	coldef
	scale
	data	pointer to host variable
	buflen	length of host variable
	len	output length pointer

Returns:: ODBC error code

Definition at line 5397 of file sqlite3odbc.c.

References stmt::bindparms, BINDPARM::bound, BINDPARM::coldef, freep(), BINDPARM::inc, BINDPARM::len, BINDPARM::lenp, BINDPARM::lenp0, BINDPARM::max, max, stmt::nbindparms, BINDPARM::need, nomem(), BINDPARM::offs, stmt::ov3, BINDPARM::param, BINDPARM::param0, BINDPARM::parbuf, BINDPARM::scale, setstat(), BINDPARM::stype, BINDPARM::type, xmalloc, and xrealloc.

Referenced by SQLBindParam(), SQLBindParameter(), and SQLSetParam().

static SQLRETURN drvbulkoperations	(	SQLHSTMT	stmt,
		SQLSMALLINT	op
	)			`[static]`

Internal perform bulk operation on HSTMT.

Parameters:

	stmt	statement handle
	op	operation to be performed

Returns:: ODBC error code

Definition at line 10441 of file sqlite3odbc.c.

References stmt::bind_offs, stmt::bind_type, stmt::bindcols, stmt::bkmrk, stmt::bkmrkcol, chkunbound(), COL::column, stmt::curtype, COL::db, stmt::dbc, dbtraceapi(), dbtracerc(), dsappend(), dsappendq(), dserr(), dsfree(), dsval(), stmt::dyncols, stmt::has_rowid, stmt::isselect, BINDCOL::lenp, BINDCOL::max, stmt::ncols, nomem(), stmt::one_tbl, stmt::ov3, stmt::row_status, stmt::row_status0, stmt::rowset_size, setposbind(), setstat(), dbc::sqlite, SQLLEN, COL::table, dbc::trace, BINDCOL::type, and BINDCOL::valp.

Referenced by SQLBulkOperations().

static SQLRETURN drvcolattributes	(	SQLHSTMT	stmt,
		SQLUSMALLINT	col,
		SQLUSMALLINT	id,
		SQLPOINTER	val,
		SQLSMALLINT	valMax,
		SQLSMALLINT *	valLen,
		SQLLEN *	val2
	)			`[static]`

Internal retrieve column attributes.

Parameters:

	stmt	statement handle
	col	column number, starting at 1
	id	attribute id
	val	output buffer
	valMax	length of output buffer
	valLen	output length
	val2	integer output buffer

Returns:: ODBC error code

Retrieve column attributes (UNICODE version).

Parameters:

	stmt	statement handle
	col	column number, starting at 1
	id	attribute id
	val	output buffer
	valMax	length of output buffer
	valLen	output length
	val2	integer output buffer

Returns:: ODBC error code

Internal retrieve column attributes.

Parameters:

	stmt	statement handle
	col	column number, starting at 1
	id	attribute id
	val	output buffer
	valMax	length of output buffer
	valLen	output length
	val2	integer output buffer

Returns:: ODBC error code

Retrieve column attributes (UNICODE version).

Parameters:

	stmt	statement handle
	col	column number, starting at 1
	id	attribute id
	val	output buffer
	valMax	length of output buffer
	valLen	output length
	val2	integer output buffer

Returns:: ODBC error code

Internal return last HDBC or HSTMT error message.

Parameters:

	env	environment handle or NULL
	dbc	database connection handle or NULL
	stmt	statement handle or NULL
	sqlState	output buffer for SQL state
	nativeErr	output buffer for native error code
	errmsg	output buffer for error message
	errmax	length of output buffer for error message
	errlen	output length of error message

Returns:: ODBC error code

Return last HDBC or HSTMT error message (UNICODE version).

Parameters:

	env	environment handle or NULL
	dbc	database connection handle or NULL
	stmt	statement handle or NULL
	sqlState	output buffer for SQL state
	nativeErr	output buffer for native error code
	errmsg	output buffer for error message
	errmax	length of output buffer for error message
	errlen	output length of error message

Returns:: ODBC error code

Return information for more result sets.

Parameters:

stmt

statement handle

Returns:: ODBC error code

Internal function to setup column name/type information

Parameters:

	s	statement poiner
	s3stmt	SQLite3 statement pointer
	ncolsp	pointer to preinitialized number of columns

Returns:: ODBC error code

Internal query preparation used by SQLPrepare() and SQLExecDirect().

Parameters:

	stmt	statement handle
	query	query string
	queryLen	length of query string or SQL_NTS

Returns:: ODBC error code

Internal query execution used by SQLExecute() and SQLExecDirect().

Parameters:

	stmt	statement handle
	initial	false when called from SQLPutData()

Returns:: ODBC error code

Prepare HSTMT (UNICODE version).

Parameters:

	stmt	statement handle
	query	query string
	queryLen	length of query string or SQL_NTS

Returns:: ODBC error code

Execute query.

Parameters:

stmt

statement handle

Returns:: ODBC error code

Execute query directly (UNICODE version).

Parameters:

	stmt	statement handle
	query	query string
	queryLen	length of query string or SQL_NTS

Returns:: ODBC error code

Connect using a driver connection string (UNICODE version).

Parameters:

	dbc	database connection handle
	hwnd	parent window handle
	connIn	driver connect input string
	connInLen	length of driver connect input string or SQL_NTS
	connOut	driver connect output string
	connOutMax	length of driver connect output string
	connOutLen	output length of driver connect output string
	drvcompl	completion type

Returns:: ODBC error code

Definition at line 17025 of file sqlite3odbc.c.

References COL::autoinc, stmt::cols, COL::column, ISSPACE, COL::label, stmt::ncols, COL::nosign, COL::notnull, stmt::nowchar, stmt::ov3, COL::prec, COL::scale, setstat(), COL::size, COL::table, COL::type, and COL::typename.

static SQLRETURN drvcolumns	(	SQLHSTMT	stmt,
		SQLCHAR *	cat,
		SQLSMALLINT	catLen,
		SQLCHAR *	schema,
		SQLSMALLINT	schemaLen,
		SQLCHAR *	table,
		SQLSMALLINT	tableLen,
		SQLCHAR *	col,
		SQLSMALLINT	colLen
	)			`[static]`

Internal retrieve column information on table.

Parameters:

	stmt	statement handle
	cat	catalog name/pattern or NULL
	catLen	length of catalog name/pattern or SQL_NTS
	schema	schema name/pattern or NULL
	schemaLen	length of schema name/pattern or SQL_NTS
	table	table name/pattern or NULL
	tableLen	length of table name/pattern or SQL_NTS
	col	column name/pattern or NULL
	colLen	length of column name/pattern or SQL_NTS

Returns:: ODBC error code

Definition at line 14902 of file sqlite3odbc.c.

References array_size, stmt::dbc, dbtraceapi(), stmt::dobigint, freerows(), getmd(), mapsqltype(), min, mkresultset(), namematch(), nomem(), stmt::nowchar, stmt::nrows, stmt::ov3, PTRDIFF_T, stmt::rowfree, stmt::rows, setstat(), dbc::sqlite, starttran(), stringify, unescpat(), unquote(), xmalloc, and xstrdup.

Referenced by SQLColumnsW().

static SQLRETURN drvconnect	(	SQLHDBC	dbc,
		SQLCHAR *	dsn,
		SQLSMALLINT	dsnLen,
		char *	pwd,
		int	pwdLen,
		int	isu
	)			`[static]`

Internal connect to SQLite database.

Parameters:

	dbc	database connection handle
	dsn	DSN string
	dsnLen	length of DSN string or SQL_NTS
	pwd	password or NULL
	pwdLen	length of password or SQL_NTS
	isu	true/false: file name is UTF8 encoded

Returns:: ODBC error code

Definition at line 12548 of file sqlite3odbc.c.

References DBC_MAGIC, dbloadext(), dbopen(), dbc::dobigint, dbc::fksupport, getbool(), getdsnattr(), dbc::jdconv, dbc::longnames, dbc::magic, min, dbc::nocreat, dbc::nowchar, ODBC_INI, dbc::oemcp, dbc::ov3, dbc::pwd, dbc::pwdLen, setstatd(), dbc::shortnames, dbc::sqlite, dbc::trace, and uc_free().

Referenced by SQLConnectW().

static SQLRETURN drvdescribecol	(	SQLHSTMT	stmt,
		SQLUSMALLINT	col,
		SQLCHAR *	name,
		SQLSMALLINT	nameMax,
		SQLSMALLINT *	nameLen,
		SQLSMALLINT *	type,
		SQLULEN *	size,
		SQLSMALLINT *	digits,
		SQLSMALLINT *	nullable
	)			`[static]`

Internal describe column information.

Parameters:

	stmt	statement handle
	col	column number, starting at 1
	name	buffer for column name
	nameMax	length of name buffer
	nameLen	output length of column name
	type	output SQL type
	size	output column size
	digits	output number of digits
	nullable	output NULL allowed indicator

Returns:: ODBC error code

Definition at line 16799 of file sqlite3odbc.c.

References stmt::cols, COL::column, stmt::ncols, stmt::nowchar, stmt::ov3, setstat(), COL::size, and COL::type.

Referenced by SQLDescribeColW().

static SQLRETURN drvdisconnect ( SQLHDBC dbc ) [static]

Internal disconnect given HDBC.

Parameters:

dbc

database connection handle

Returns:: ODBC error code

Definition at line 12801 of file sqlite3odbc.c.

References dbc::cur_s3stmt, DBC_MAGIC, dbc::dbname, dbc::dsn, freep(), dbc::intrans, dbc::magic, s3stmt_end(), setstatd(), dbc::sqlite, and dbc::trace.

Referenced by SQLDisconnect().

static SQLRETURN drvdriverconnect	(	SQLHDBC	dbc,
		SQLHWND	hwnd,
		SQLCHAR *	connIn,
		SQLSMALLINT	connInLen,
		SQLCHAR *	connOut,
		SQLSMALLINT	connOutMax,
		SQLSMALLINT *	connOutLen,
		SQLUSMALLINT	drvcompl
	)			`[static]`

Internal standalone (w/o driver manager) database connect.

Parameters:

	dbc	database connection handle
	hwnd	dummy window handle or NULL
	connIn	driver connect input string
	connInLen	length of driver connect input string or SQL_NTS
	connOut	driver connect output string
	connOutMax	length of driver connect output string
	connOutLen	output length of driver connect output string
	drvcompl	completion type

Returns:: ODBC error code

Definition at line 12871 of file sqlite3odbc.c.

References dbloadext(), dbopen(), dbc::dobigint, dbc::fksupport, getbool(), getdsnattr(), dbc::jdconv, dbc::longnames, min, dbc::nocreat, dbc::nowchar, ODBC_INI, dbc::oemcp, dbc::ov3, dbc::pwd, dbc::pwdLen, setstatd(), dbc::shortnames, dbc::sqlite, and dbc::trace.

static SQLRETURN drvendtran	(	SQLSMALLINT	type,
		SQLHANDLE	handle,
		SQLSMALLINT	comptype
	)			`[static]`

Internal commit or rollback transaction.

Parameters:

	type	type of handle
	handle	HDBC, HENV, or HSTMT handle
	comptype	SQL_COMMIT or SQL_ROLLBACK

Returns:: ODBC error code

Definition at line 8003 of file sqlite3odbc.c.

References endtran(), ENV_MAGIC, HDBC_LOCK, HDBC_UNLOCK, and ENV::magic.

Referenced by SQLEndTran(), and SQLTransact().

static SQLRETURN drvexecute	(	SQLHSTMT	stmt,
		int	initial
	)			`[static]`

Referenced by SQLParamData().

static SQLRETURN drvfetchscroll	(	SQLHSTMT	stmt,
		SQLSMALLINT	orient,
		SQLINTEGER	offset
	)			`[static]`

Internal fetch function for SQLFetchScroll() and SQLExtendedFetch().

Parameters:

	stmt	statement handle
	orient	fetch direction
	offset	offset for fetch direction

Returns:: ODBC error code

Definition at line 16436 of file sqlite3odbc.c.

References stmt::bindcols, stmt::bkmrk, stmt::bkmrkptr, stmt::curtype, stmt::dbc, dofetchbind(), stmt::has_rowid, stmt::isselect, stmt::max_rows, stmt::ncols, stmt::nrows, stmt::row_count, stmt::row_count0, stmt::row_status, stmt::row_status0, stmt::rowp, stmt::rowprs, stmt::rows, stmt::rowset_size, stmt::s3stmt, stmt::s3stmt_rownum, s3stmt_step(), and setstat().

Referenced by SQLExtendedFetch(), SQLFetch(), and SQLFetchScroll().

static SQLRETURN SQL_API drvforeignkeys	(	SQLHSTMT	stmt,
		SQLCHAR *	PKcatalog,
		SQLSMALLINT	PKcatalogLen,
		SQLCHAR *	PKschema,
		SQLSMALLINT	PKschemaLen,
		SQLCHAR *	PKtable,
		SQLSMALLINT	PKtableLen,
		SQLCHAR *	FKcatalog,
		SQLSMALLINT	FKcatalogLen,
		SQLCHAR *	FKschema,
		SQLSMALLINT	FKschemaLen,
		SQLCHAR *	FKtable,
		SQLSMALLINT	FKtableLen
	)			`[static]`

Internal retrieve information about primary/foreign keys.

Parameters:

	stmt	statement handle
	PKcatalog	primary key catalog name/pattern or NULL
	PKcatalogLen	length of PKcatalog or SQL_NTS
	PKschema	primary key schema name/pattern or NULL
	PKschemaLen	length of PKschema or SQL_NTS
	PKtable	primary key table name/pattern or NULL
	PKtableLen	length of PKtable or SQL_NTS
	FKcatalog	foreign key catalog name/pattern or NULL
	FKcatalogLen	length of FKcatalog or SQL_NTS
	FKschema	foreign key schema name/pattern or NULL
	FKschemaLen	length of FKschema or SQL_NTS
	FKtable	foreign key table name/pattern or NULL
	FKtableLen	length of FKtable or SQL_NTS

Returns:: ODBC error code

Definition at line 7315 of file sqlite3odbc.c.

References array_size, stmt::dbc, dbtraceapi(), findcol(), freerows(), min, mkresultset(), stmt::ncols, nomem(), stmt::nrows, stmt::ov3, PTRDIFF_T, stmt::rowfree, stmt::rows, setstat(), dbc::sqlite, starttran(), stringify, unquote(), xmalloc, and xstrdup.

Referenced by SQLForeignKeysW().

static SQLRETURN drvfreeconnect ( SQLHDBC dbc ) [static]

Internal free connection (HDBC).

Parameters:

dbc

database connection handle

Returns:: ODBC error code

Definition at line 11866 of file sqlite3odbc.c.

References DBC_MAGIC, ENV::dbcs, DEAD_MAGIC, drvrelgpps, dbc::env, ENV_MAGIC, freestmt(), HDBC_LOCK, HDBC_UNLOCK, ENV::magic, dbc::magic, dbc::next, dbc::ov3, setstatd(), dbc::sqlite, dbc::stmt, dbc::trace, and xfree.

Referenced by SQLFreeConnect(), and SQLFreeHandle().

static SQLRETURN drvfreeenv ( SQLHENV env ) [static]

Internal free HENV.

Parameters:

env

environment handle

Returns:: ODBC error code

Definition at line 11738 of file sqlite3odbc.c.

References ENV::dbcs, DEAD_MAGIC, ENV_MAGIC, ENV::magic, and xfree.

Referenced by SQLFreeEnv(), and SQLFreeHandle().

static SQLRETURN drvfreestmt	(	SQLHSTMT	stmt,
		SQLUSMALLINT	opt
	)			`[static]`

Internal function to perform certain kinds of free/close on STMT.

Parameters:

	stmt	statement handle
	opt	SQL_RESET_PARAMS, SQL_UNBIND, SQL_CLOSE, or SQL_DROP

Returns:: ODBC error code

Definition at line 13251 of file sqlite3odbc.c.

References stmt::dbc, freeparams(), freeresult(), freestmt(), HDBC_UNLOCK, HSTMT_LOCK, stmt::ov3, s3stmt_end_if(), setstat(), and unbindcols().

Referenced by SQLCancel(), SQLCloseCursor(), SQLFreeHandle(), and SQLFreeStmt().

static SQLRETURN drvgetconnectattr	(	SQLHDBC	dbc,
		SQLINTEGER	attr,
		SQLPOINTER	val,
		SQLINTEGER	bufmax,
		SQLINTEGER *	buflen
	)			`[static]`

Internal get connect attribute of HDBC.

Parameters:

	dbc	database connection handle
	attr	option to be retrieved
	val	output buffer
	bufmax	size of output buffer
	buflen	output length

Returns:: ODBC error code

Definition at line 11960 of file sqlite3odbc.c.

References dbc::autocommit, dbc::curtype, dbc::ov3, setstatd(), dbc::sqlite, and SQLULEN.

Referenced by SQLGetConnectAttrW().

static SQLRETURN drvgetconnectoption	(	SQLHDBC	dbc,
		SQLUSMALLINT	opt,
		SQLPOINTER	param
	)			`[static]`

Internal get connect option of HDBC.

Parameters:

	dbc	database connection handle
	opt	option to be retrieved
	param	output buffer

Returns:: ODBC error code

Definition at line 12284 of file sqlite3odbc.c.

References dbc::autocommit, dbc::curtype, dbc::ov3, and setstatd().

Referenced by SQLGetConnectOptionW().

static SQLRETURN drvgetcursorname	(	SQLHSTMT	stmt,
		SQLCHAR *	cursor,
		SQLSMALLINT	buflen,
		SQLSMALLINT *	lenp
	)			`[static]`

Internal function to get cursor name of STMT.

Parameters:

	stmt	statement handle
	cursor	output buffer
	buflen	length of output buffer
	lenp	output length

Returns:: ODBC error code

Definition at line 13339 of file sqlite3odbc.c.

References stmt::cursorname, and min.

Referenced by SQLGetCursorNameW().

static SQLRETURN drvgetdiagfield	(	SQLSMALLINT	htype,
		SQLHANDLE	handle,
		SQLSMALLINT	recno,
		SQLSMALLINT	id,
		SQLPOINTER	info,
		SQLSMALLINT	buflen,
		SQLSMALLINT *	stringlen
	)			`[static]`

Get error record given handle (HDBC or HSTMT).

Parameters:

	htype	handle type
	handle	HDBC or HSTMT
	recno	diag record number for which info to be retrieved
	id	diag id for which info to be retrieved
	info	output buffer for error message
	buflen	length of output buffer
	stringlen	output length

Returns:: ODBC error code

Definition at line 8716 of file sqlite3odbc.c.

References stmt::dbc, dbc::dsn, HDBC_LOCK, HDBC_UNLOCK, HSTMT_LOCK, HSTMT_UNLOCK, stmt::isselect, stmt::logmsg, dbc::logmsg, stmt::naterr, dbc::naterr, stmt::nrows, stmt::sqlstate, dbc::sqlstate, and SQLULEN.

Referenced by SQLGetDiagFieldW().

static SQLRETURN drvgetdiagrec	(	SQLSMALLINT	htype,
		SQLHANDLE	handle,
		SQLSMALLINT	recno,
		SQLCHAR *	sqlstate,
		SQLINTEGER *	nativeerr,
		SQLCHAR *	msg,
		SQLSMALLINT	buflen,
		SQLSMALLINT *	msglen
	)			`[static]`

Internal get error message given handle (HENV, HDBC, or HSTMT).

Parameters:

	htype	handle type
	handle	HENV, HDBC, or HSTMT
	recno
	sqlstate	output buffer for SQL state
	nativeerr	output buffer of native error code
	msg	output buffer for error message
	buflen	length of output buffer
	msglen	output length

Returns:: ODBC error code

Definition at line 8507 of file sqlite3odbc.c.

References HDBC_LOCK, HDBC_UNLOCK, HSTMT_LOCK, HSTMT_UNLOCK, stmt::logmsg, dbc::logmsg, stmt::naterr, dbc::naterr, stmt::sqlstate, and dbc::sqlstate.

Referenced by SQLGetDiagRecW().

static SQLRETURN drvgetinfo	(	SQLHDBC	dbc,
		SQLUSMALLINT	type,
		SQLPOINTER	val,
		SQLSMALLINT	valMax,
		SQLSMALLINT *	valLen
	)			`[static]`

Internal return information about what this ODBC driver supports.

Parameters:

	dbc	database connection handle
	type	type of information to be retrieved
	val	output buffer
	valMax	length of output buffer
	valLen	output length

Returns:: ODBC error code

Definition at line 10917 of file sqlite3odbc.c.

References dbc::dbname, DRIVER_VER_INFO, dbc::dsn, dbc::ov3, setstatd(), and strmak.

Referenced by SQLGetInfoW().

static SQLRETURN drvgetstmtattr	(	SQLHSTMT	stmt,
		SQLINTEGER	attr,
		SQLPOINTER	val,
		SQLINTEGER	bufmax,
		SQLINTEGER *	buflen
	)			`[static]`

Internal get option of HSTMT.

Parameters:

	stmt	statement handle
	attr	attribute to be retrieved
	val	output buffer
	bufmax	length of output buffer
	buflen	output length

Returns:: ODBC error code

Definition at line 8991 of file sqlite3odbc.c.

References stmt::bind_offs, stmt::bind_type, stmt::bkmrk, stmt::bkmrkptr, stmt::curtype, DEAD_MAGIC, drvunimplstmt(), stmt::max_rows, stmt::paramset_size, stmt::parm_bind_offs, stmt::parm_bind_type, stmt::parm_oper, stmt::parm_proc, stmt::parm_status, stmt::retr_data, stmt::row_count, stmt::row_status, stmt::rowp, stmt::rowset_size, stmt::s3stmt, stmt::s3stmt_rownum, and SQLULEN.

Referenced by SQLGetStmtAttrW().

static SQLRETURN drvgetstmtoption	(	SQLHSTMT	stmt,
		SQLUSMALLINT	opt,
		SQLPOINTER	param
	)			`[static]`

Internal get option of HSTMT.

Parameters:

	stmt	statement handle
	opt	option to be retrieved
	param	output buffer

Returns:: ODBC error code

Definition at line 9394 of file sqlite3odbc.c.

References stmt::curtype, drvunimplstmt(), stmt::max_rows, stmt::retr_data, stmt::rowp, stmt::rowset_size, stmt::s3stmt, and stmt::s3stmt_rownum.

Referenced by SQLGetStmtOption(), and SQLGetStmtOptionW().

static int drvgettable	(	STMT *	s,
		const char *	sql,
		char ***	resp,
		int *	nrowp,
		int *	ncolp,
		char **	errp,
		int	nparam,
		BINDPARM *	p
	)			`[static]`

Definition at line 1544 of file sqlite3odbc.c.

References stmt::dbc, dbtraceapi(), drvgettable_row(), freerows(), ISSPACE, stmt::max_rows, s3bind(), stmt::s3stmt, stmt::s3stmt_noreset, dbc::sqlite, dbc::stmt, and xmalloc.

static int drvgettable_row	(	TBLRES *	t,
		int	ncol,
		int	rc
	)			`[static]`

Definition at line 1427 of file sqlite3odbc.c.

References tblres::errmsg, stmt::guessed_types, tblres::nalloc, tblres::ncol, stmt::ncols, tblres::ndata, nomem(), tblres::nrow, tblres::rc, tblres::resarr, tblres::s, setupdyncols(), tblres::stmt, xdigits, xmalloc, xrealloc, and xstrdup.

Referenced by drvgettable().

static SQLRETURN drvgettypeinfo	(	SQLHSTMT	stmt,
		SQLSMALLINT	sqltype
	)			`[static]`

Internal return data type information.

Parameters:

	stmt	statement handle
	sqltype	which type to retrieve

Returns:: ODBC error code

Definition at line 15572 of file sqlite3odbc.c.

References array_size, mkresultset(), mktypeinfo(), nomem(), stmt::nrows, stmt::ov3, stmt::rowfree, stmt::rows, typeinfosort(), and xmalloc.

Referenced by SQLGetTypeInfoW().

static SQLRETURN drvprimarykeys	(	SQLHSTMT	stmt,
		SQLCHAR *	cat,
		SQLSMALLINT	catLen,
		SQLCHAR *	schema,
		SQLSMALLINT	schemaLen,
		SQLCHAR *	table,
		SQLSMALLINT	tableLen
	)			`[static]`

Internal retrieve information about indexed columns.

Parameters:

	stmt	statement handle
	cat	catalog name/pattern or NULL
	catLen	length of catalog name/pattern or SQL_NTS
	schema	schema name/pattern or NULL
	schemaLen	length of schema name/pattern or SQL_NTS
	table	table name/pattern or NULL
	tableLen	length of table name/pattern or SQL_NTS

Returns:: ODBC error code

Definition at line 6449 of file sqlite3odbc.c.

References array_size, stmt::dbc, dbtraceapi(), findcol(), freerows(), min, mkresultset(), stmt::ncols, nomem(), stmt::nrows, stmt::ov3, PTRDIFF_T, stmt::rowfree, stmt::rows, setstat(), dbc::sqlite, starttran(), unescpat(), xmalloc, and xstrdup.

Referenced by SQLPrimaryKeysW().

static SQLRETURN drvputdata	(	SQLHSTMT	stmt,
		SQLPOINTER	data,
		SQLLEN	len
	)			`[static]`

Internal put (partial) parameter data into executing statement.

Parameters:

	stmt	statement handle
	data	pointer to data
	len	length of data

Returns:: ODBC error code

Definition at line 4794 of file sqlite3odbc.c.

References stmt::bindparms, BINDPARM::coldef, freep(), BINDPARM::len, mapdeftype(), min, BINDPARM::need, nomem(), stmt::nowchar, stmt::nparams, stmt::oemcp, BINDPARM::offs, BINDPARM::param, BINDPARM::parbuf, stmt::pdcount, stmt::query, setstat(), BINDPARM::stype, BINDPARM::type, uc_free(), uc_to_utf(), WCHARSUPPORT, and xmalloc.

Referenced by SQLPutData().

static SQLRETURN drvsetconnectattr	(	SQLHDBC	dbc,
		SQLINTEGER	attr,
		SQLPOINTER	val,
		SQLINTEGER	len
	)			`[static]`

Internal set connect attribute of HDBC.

Parameters:

	dbc	database connection handle
	attr	option to be set
	val	option value
	len	size of option

Returns:: ODBC error code

Definition at line 12196 of file sqlite3odbc.c.

References dbc::autocommit, dbc::cur_s3stmt, endtran(), dbc::intrans, s3stmt_end(), and setstatd().

Referenced by SQLSetConnectAttrW().

static SQLRETURN drvsetconnectoption	(	SQLHDBC	dbc,
		SQLUSMALLINT	opt,
		SQLUINTEGER	param
	)			`[static]`

Internal set option on HDBC.

Parameters:

	dbc	database connection handle
	opt	option to be set
	param	option value

Returns:: ODBC error code

Definition at line 12426 of file sqlite3odbc.c.

References dbc::autocommit, dbc::cur_s3stmt, endtran(), dbc::intrans, s3stmt_end(), and setstatd().

Referenced by SQLSetConnectOptionW().

static SQLRETURN drvsetcursorname	(	SQLHSTMT	stmt,
		SQLCHAR *	cursor,
		SQLSMALLINT	len
	)			`[static]`

Internal function to set cursor name on STMT.

Parameters:

	stmt	statement handle
	cursor	new cursor name
	len	length of cursor name or SQL_NTS

Returns:: ODBC error code

Definition at line 13476 of file sqlite3odbc.c.

References stmt::cursorname, min, stmt::ov3, and setstat().

Referenced by SQLSetCursorNameW().

static SQLRETURN drvsetpos	(	SQLHSTMT	stmt,
		SQLSETPOSIROW	row,
		SQLUSMALLINT	op,
		SQLUSMALLINT	lock
	)			`[static]`

Internal set position on result in HSTMT.

Parameters:

	stmt	statement handle
	row	row to be positioned
	op	operation code
	lock	locking type

Returns:: ODBC error code

Definition at line 10078 of file sqlite3odbc.c.

References stmt::bindcols, chkunbound(), COL::column, stmt::curtype, COL::db, stmt::dbc, dbtraceapi(), dbtracerc(), drvunimplstmt(), dsappend(), dsappendq(), dserr(), dsfree(), dsval(), stmt::dyncols, stmt::has_pk, COL::ispk, stmt::isselect, stmt::ncols, nomem(), stmt::nrows, stmt::one_tbl, stmt::ov3, stmt::row_status, stmt::row_status0, stmt::rowp, stmt::rows, stmt::rowset_size, setposbind(), setposibind(), setposrefr(), setstat(), dbc::sqlite, and COL::table.

Referenced by SQLSetPos().

static SQLRETURN drvsetstmtattr	(	SQLHSTMT	stmt,
		SQLINTEGER	attr,
		SQLPOINTER	val,
		SQLINTEGER	buflen
	)			`[static]`

Internal set option on HSTMT.

Parameters:

	stmt	statement handle
	attr	attribute to be set
	val	input buffer (attribute value)
	buflen	length of input buffer

Returns:: ODBC error code

Definition at line 9186 of file sqlite3odbc.c.

References stmt::bind_offs, stmt::bind_type, stmt::bkmrk, stmt::bkmrkptr, stmt::curtype, drvunimplstmt(), freep(), stmt::max_rows, nomem(), stmt::ov3, stmt::paramset_count, stmt::paramset_size, stmt::parm_bind_offs, stmt::parm_bind_type, stmt::parm_oper, stmt::parm_proc, stmt::parm_status, stmt::retr_data, stmt::row_count, stmt::row_status, stmt::row_status0, stmt::row_status1, stmt::rowset_size, setstat(), SQLULEN, and xmalloc.

Referenced by SQLSetStmtAttrW().

static SQLRETURN drvsetstmtoption	(	SQLHSTMT	stmt,
		SQLUSMALLINT	opt,
		SQLUINTEGER	param
	)			`[static]`

Internal set option on HSTMT.

Parameters:

	stmt	statement handle
	opt	option to be set
	param	input buffer (option value)

Returns:: ODBC error code

Definition at line 9486 of file sqlite3odbc.c.

References stmt::curtype, drvunimplstmt(), freep(), stmt::max_rows, nomem(), stmt::retr_data, stmt::row_status0, stmt::row_status1, stmt::rowset_size, setstat(), and xmalloc.

Referenced by SQLSetStmtOption(), and SQLSetStmtOptionW().

static SQLRETURN drvspecialcolumns	(	SQLHSTMT	stmt,
		SQLUSMALLINT	id,
		SQLCHAR *	cat,
		SQLSMALLINT	catLen,
		SQLCHAR *	schema,
		SQLSMALLINT	schemaLen,
		SQLCHAR *	table,
		SQLSMALLINT	tableLen,
		SQLUSMALLINT	scope,
		SQLUSMALLINT	nullable
	)			`[static]`

Internal retrieve information about indexed columns.

Parameters:

	stmt	statement handle
	id	type of information, e.g. best row id
	cat	catalog name/pattern or NULL
	catLen	length of catalog name/pattern or SQL_NTS
	schema	schema name/pattern or NULL
	schemaLen	length of schema name/pattern or SQL_NTS
	table	table name/pattern or NULL
	tableLen	length of table name/pattern or SQL_NTS
	scope
	nullable

Returns:: ODBC error code

Definition at line 6862 of file sqlite3odbc.c.

References array_size, stmt::dbc, dbtraceapi(), stmt::dobigint, findcol(), freep(), freerows(), getmd(), mapsqltype(), min, mkresultset(), stmt::ncols, nomem(), stmt::nowchar, stmt::nrows, stmt::ov3, PTRDIFF_T, stmt::rowfree, stmt::rows, setstat(), dbc::sqlite, starttran(), stringify, unescpat(), xmalloc, and xstrdup.

Referenced by SQLSpecialColumnsW().

static SQLRETURN drvstatistics	(	SQLHSTMT	stmt,
		SQLCHAR *	cat,
		SQLSMALLINT	catLen,
		SQLCHAR *	schema,
		SQLSMALLINT	schemaLen,
		SQLCHAR *	table,
		SQLSMALLINT	tableLen,
		SQLUSMALLINT	itype,
		SQLUSMALLINT	resv
	)			`[static]`

Internal return statistic information on table indices.

Parameters:

	stmt	statement handle
	cat	catalog name/pattern or NULL
	catLen	length of catalog name/pattern or SQL_NTS
	schema	schema name/pattern or NULL
	schemaLen	length of schema name/pattern or SQL_NTS
	table	table name/pattern or NULL
	tableLen	length of table name/pattern or SQL_NTS
	itype	type of index information
	resv	reserved

Returns:: ODBC error code

Definition at line 15853 of file sqlite3odbc.c.

References array_size, stmt::dbc, dbtraceapi(), findcol(), freerows(), min, mkresultset(), stmt::ncols, nomem(), stmt::nrows, stmt::ov3, PTRDIFF_T, stmt::rowfree, stmt::rows, setstat(), dbc::sqlite, starttran(), stringify, unescpat(), xmalloc, and xstrdup.

Referenced by SQLStatisticsW().

static SQLRETURN drvtableprivileges	(	SQLHSTMT	stmt,
		SQLCHAR *	cat,
		SQLSMALLINT	catLen,
		SQLCHAR *	schema,
		SQLSMALLINT	schemaLen,
		SQLCHAR *	table,
		SQLSMALLINT	tableLen
	)			`[static]`

Retrieve privileges on tables and/or views.

Parameters:

	stmt	statement handle
	cat	catalog name/pattern or NULL
	catLen	length of catalog name/pattern or SQL_NTS
	schema	schema name/pattern or NULL
	schemaLen	length of schema name/pattern or SQL_NTS
	table	table name/pattern or NULL
	tableLen	length of table name/pattern or SQL_NTS

Returns:: ODBC error code

Definition at line 5987 of file sqlite3odbc.c.

References array_size, stmt::dbc, dbtraceapi(), freeresult(), min, mkresultset(), stmt::ncols, nomem(), stmt::nrows, stmt::rowfree, stmt::rowp, stmt::rowprs, stmt::rows, dbc::sqlite, starttran(), and unescpat().

Referenced by SQLTablePrivilegesW().

static SQLRETURN drvtables	(	SQLHSTMT	stmt,
		SQLCHAR *	cat,
		SQLSMALLINT	catLen,
		SQLCHAR *	schema,
		SQLSMALLINT	schemaLen,
		SQLCHAR *	table,
		SQLSMALLINT	tableLen,
		SQLCHAR *	type,
		SQLSMALLINT	typeLen
	)			`[static]`

Retrieve information on tables and/or views.

Parameters:

	stmt	statement handle
	cat	catalog name/pattern or NULL
	catLen	length of catalog name/pattern or SQL_NTS
	schema	schema name/pattern or NULL
	schemaLen	length of schema name/pattern or SQL_NTS
	table	table name/pattern or NULL
	tableLen	length of table name/pattern or SQL_NTS
	type	types of tables string or NULL
	typeLen	length of types of tables string or SQL_NTS

Returns:: ODBC error code

Definition at line 14523 of file sqlite3odbc.c.

References array_size, stmt::dbc, dbtraceapi(), freeresult(), min, mkresultset(), stmt::ncols, nomem(), stmt::nrows, stmt::rowfree, stmt::rowp, stmt::rowprs, stmt::rows, dbc::sqlite, starttran(), TOLOWER(), unescpat(), and xmalloc.

Referenced by SQLTablesW().

static SQLRETURN drvunimpldbc ( HDBC dbc ) [static]

Report IM001 (not implemented) SQL error code for HDBC.

Parameters:

dbc

database connection handle

Returns:: ODBC error code

Definition at line 1795 of file sqlite3odbc.c.

References setstatd().

Referenced by SQLBrowseConnectW().

static SQLRETURN drvunimplstmt ( HSTMT stmt ) [static]

Report IM001 (not implemented) SQL error code for HSTMT.

Parameters:

stmt

statement handle

Returns:: ODBC error code

Definition at line 1814 of file sqlite3odbc.c.

References setstat().

Referenced by drvgetstmtattr(), drvgetstmtoption(), drvsetpos(), drvsetstmtattr(), drvsetstmtoption(), SQLParamOptions(), and SQLSetScrollOptions().

static dstr* dsappend	(	dstr *	dsp,
		const char *	str
	)			`[static]`

Append string to dynamic string.

Parameters:

	dsp	dstr pointer
	str	string to append

Returns:: dsp result dstr pointer or NULL.

Definition at line 638 of file sqlite3odbc.c.

References dstr::buffer, dstr::len, dstr::max, max, dstr::oom, xmalloc, and xrealloc.

Referenced by drvbulkoperations(), and drvsetpos().

static dstr* dsappendq	(	dstr *	dsp,
		const char *	str
	)			`[static]`

Append a string double quoted to dynamic string.

Parameters:

	dsp	dstr pointer
	str	string to append

Returns:: dsp result dstr pointer or NULL.

Definition at line 690 of file sqlite3odbc.c.

References dstr::buffer, dstr::len, dstr::max, max, dstr::oom, xmalloc, and xrealloc.

Referenced by drvbulkoperations(), and drvsetpos().

static int dserr ( dstr * dsp ) [static]

Check error on dynamic string.

Parameters:

dsp

dstr pointer

Returns:: true when error pending

Definition at line 773 of file sqlite3odbc.c.

References dstr::oom.

Referenced by drvbulkoperations(), and drvsetpos().

static void dsfree ( dstr * dsp ) [static]

Free dynamic string.

Parameters:

dsp

dstr pointer

Definition at line 784 of file sqlite3odbc.c.

References xfree.

Referenced by drvbulkoperations(), and drvsetpos().

static const char* dsval ( dstr * dsp ) [static]

Return dynamic string's value.

Parameters:

dsp

dstr pointer

Returns:: string value

Definition at line 758 of file sqlite3odbc.c.

References dstr::buffer.

Referenced by drvbulkoperations(), and drvsetpos().

static SQLRETURN endtran	(	DBC *	d,
		SQLSMALLINT	comptype,
		int	force
	)			`[static]`

Internal commit or rollback transaction.

Parameters:

	d	database connection pointer
	comptype	type of transaction's end, SQL_COMMIT or SQL_ROLLBACK
	force	force action regardless of DBC's autocommit state

Returns:: ODBC error code

Definition at line 7944 of file sqlite3odbc.c.

References dbc::autocommit, busy_handler(), dbtracerc(), dbc::intrans, dbc::ov3, setstatd(), and dbc::sqlite.

Referenced by drvendtran(), drvsetconnectattr(), and drvsetconnectoption().

static int findcol	(	char **	cols,
		int	ncols,
		char *	name
	)			`[static]`

Find column given name in string array.

Parameters:

	cols	string array
	ncols	number of strings
	name	column name

Returns:: >= 0 on success, -1 on error

Definition at line 2777 of file sqlite3odbc.c.

Referenced by drvforeignkeys(), drvprimarykeys(), drvspecialcolumns(), drvstatistics(), and fixupdyncols().

static void fixupdyncols	(	STMT *	s,
		DBC *	d
	)			`[static]`

Fixup column information for a running statement.

Parameters:

	s	statement to get fresh column information
	d	DBC pointer

The column labels get the table names stripped when there's more than one column and all table names are identical.

The "dyncols" field of STMT is filled with column information obtained by SQLite "PRAGMA table_info" for each column whose table name is known. If the types are already present as with SQLite 2.5.7 this information is used instead.

Definition at line 2808 of file sqlite3odbc.c.

References array_size, COL::autoinc, COL::column, dbtraceapi(), stmt::dcols, stmt::dobigint, stmt::dyncols, findcol(), freep(), getmd(), stmt::has_pk, stmt::has_rowid, COL::ispk, COL::isrowid, COL::label, stmt::longnames, mapsqltype(), COL::nosign, COL::notnull, stmt::nowchar, stmt::one_tbl, stmt::ov3, COL::prec, COL::size, dbc::sqlite, COL::table, COL::type, COL::typename, xmalloc, and xstrdup.

Referenced by s3stmt_step().

static char* fixupsql	(	char *	sql,
		int	sqlLen,
		int	cte,
		int *	nparam,
		int *	isselect,
		char **	errmsg
	)			`[static]`

Fixup query string with optional parameter markers.

Parameters:

	sql	original query string
	sqlLen	length of query string or SQL_NTS
	cte	when true, WITH is treated as SELECT
	nparam	output number of parameters
	isselect	output indicator for SELECT (1) or DDL statement (2)
	errmsg	output error message

Returns:: newly allocated string containing query string for SQLite or NULL

Definition at line 2511 of file sqlite3odbc.c.

References array_size, freep(), ISSPACE, and xmalloc.

static void freedyncols ( STMT * s ) [static]

Free dynamically allocated column descriptions of STMT.

Parameters:

s

statement pointer

Definition at line 13650 of file sqlite3odbc.c.

References stmt::cols, stmt::dcols, stmt::dyncols, freep(), stmt::ncols, and COL::typename.

Referenced by freeresult(), and s3stmt_step().

static void freep ( void * x ) [static]

Free memory given pointer to memory pointer.

Parameters:

x

pointer to pointer to memory to be free'd

Definition at line 1832 of file sqlite3odbc.c.

References xfree.

Referenced by dbopen(), drvbindparam(), drvdisconnect(), drvputdata(), drvsetstmtattr(), drvsetstmtoption(), drvspecialcolumns(), fixupdyncols(), fixupsql(), freedyncols(), freeparams(), freeresult(), freerows(), freestmt(), getrowdata(), and setupparam().

static SQLRETURN freeparams ( STMT * s ) [static]

Clear out parameter bindings, if any.

Parameters:

s

statement pointer

Definition at line 5029 of file sqlite3odbc.c.

References stmt::bindparms, freep(), stmt::nbindparms, and BINDPARM::parbuf.

Referenced by drvfreestmt(), and freestmt().

static void freeresult	(	STMT *	s,
		int	clrcols
	)			`[static]`

Free statement's result.

Parameters:

	s	statement pointer
	clrcols	flag to clear column information

The result rows are free'd using the rowfree function pointer. If clrcols is greater than zero, then column bindings and dynamic column descriptions are free'd. If clrcols is less than zero, then dynamic column descriptions are free'd.

Definition at line 13679 of file sqlite3odbc.c.

References stmt::bincache, stmt::bincell, stmt::bindcols, stmt::binlen, stmt::cols, freedyncols(), freep(), stmt::has_pk, stmt::has_rowid, stmt::nbindcols, stmt::ncols, stmt::nowchar, stmt::nrows, stmt::one_tbl, stmt::rowfree, and stmt::rows.

Referenced by drvfreestmt(), drvtableprivileges(), drvtables(), freestmt(), mkresultset(), and s3stmt_step().

static void freerows ( char ** rowp ) [static]

Free counted array of char pointers.

Parameters:

rowp

pointer to char pointer array

The -1-th element of the array holds the array size. All non-NULL pointers of the array and then the array itself are free'd.

Definition at line 2185 of file sqlite3odbc.c.

References freep(), and PTRDIFF_T.

Referenced by drvcolumns(), drvforeignkeys(), drvgettable(), drvprimarykeys(), drvspecialcolumns(), drvstatistics(), and s3stmt_step().

static SQLRETURN freestmt ( SQLHSTMT stmt ) [static]

Internal free function for HSTMT.

Parameters:

stmt

statement handle

Returns:: ODBC error code

Definition at line 13113 of file sqlite3odbc.c.

References stmt::bindparms, stmt::dbc, DBC_MAGIC, freep(), freeparams(), freeresult(), dbc::magic, stmt::next, stmt::query, stmt::row_status0, stmt::row_status1, stmt::rowset_size, s3stmt_drop(), dbc::stmt, and xfree.

static SQLRETURN freestmt ( HSTMT stmt ) [static]

Referenced by drvfreeconnect(), and drvfreestmt().

static int getbool ( char * string ) [static]

Get boolean flag from string.

Parameters:

string

string to be inspected

Returns:: true or false

Definition at line 3687 of file sqlite3odbc.c.

Referenced by dbopen(), drvconnect(), drvdriverconnect(), and getrowdata().

static int getdsnattr	(	char *	dsn,
		char *	attr,
		char *	out,
		int	outLen
	)			`[static]`

Handling of SQLConnect() connection attributes for standalone operation without driver manager.

Parameters:

	dsn	DSN/driver connection string
	attr	attribute string to be retrieved
	out	output buffer
	outLen	length of output buffer

Returns:: true or false

Definition at line 12505 of file sqlite3odbc.c.

References min.

Referenced by drvconnect(), and drvdriverconnect().

static void getmd	(	const char *	typename,
		int	sqltype,
		int *	mp,
		int *	dp
	)			`[static]`

Get maximum display size and number of digits after decimal point from field type specification.

Parameters:

	typename	field type specification
	sqltype	target SQL data type
	mp	pointer to maximum display size or NULL
	dp	pointer to number of digits after decimal point or NULL

Definition at line 2335 of file sqlite3odbc.c.

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

static int getmdays	(	int	year,
		int	month
	)			`[static]`

Return number of month days.

Parameters:

	year
	month	1..12

Returns:: number of month days or 0

Definition at line 3085 of file sqlite3odbc.c.

Referenced by str2date(), and str2timestamp().

static SQLRETURN getrowdata	(	STMT *	s,
		SQLUSMALLINT	col,
		SQLSMALLINT	otype,
		SQLPOINTER	val,
		SQLINTEGER	len,
		SQLLEN *	lenp,
		int	partial
	)			`[static]`

Internal function to retrieve row data, used by SQLFetch() and friends and SQLGetData().

Parameters:

	s	statement pointer
	col	column number, 0 based
	otype	output data type
	val	output buffer
	len	length of output buffer
	lenp	output length
	partial	flag for partial data retrieval

Returns:: ODBC error code

Definition at line 13782 of file sqlite3odbc.c.

References stmt::bincache, stmt::bincell, stmt::bindcols, stmt::binlen, stmt::cols, freep(), getbool(), stmt::jdconv, BINDCOL::lenp, ln_strtod(), mapdeftype(), min, stmt::ncols, nomem(), COL::nosign, stmt::nowchar, stmt::nrows, stmt::oemcp, BINDCOL::offs, stmt::ov3, COL::prec, stmt::retr_data, stmt::rowp, stmt::rows, setstat(), SQLLEN, str2date(), str2time(), str2timestamp(), COL::type, uc_free(), uc_from_utf(), uc_strlen(), uc_strncpy(), xdigits, and xmalloc.

Referenced by dofetchbind(), setposrefr(), and SQLGetData().

static double ln_strtod	(	const char *	data,
		char **	endp
	)			`[static]`

Internal locale neutral strtod function.

Parameters:

	data	pointer to string
	endp	pointer for ending character

Returns:: double value

Definition at line 1876 of file sqlite3odbc.c.

Referenced by getrowdata(), str2date(), str2time(), and str2timestamp().

static int mapdeftype	(	int	type,
		int	stype,
		int	nosign,
		int	nowchar
	)			`[static]`

Map SQL_C_DEFAULT to proper C type.

Parameters:

	type	input C type
	stype	input SQL type
	nosign	0=signed, 0>unsigned, 0<undefined
	nowchar	when compiled with WINTERFACE don't use WCHAR

Returns:: C type

Definition at line 2420 of file sqlite3odbc.c.

Referenced by drvbindcol(), drvputdata(), getrowdata(), setupparam(), and SQLParamData().

static int mapsqltype	(	const char *	typename,
		int *	nosign,
		int	ov3,
		int	nowchar,
		int	dobigint
	)			`[static]`

Map SQL field type from string to ODBC integer type code.

Parameters:

	typename	field type string
	nosign	pointer to indicator for unsigned field or NULL
	ov3	boolean, true for SQL_OV_ODBC3
	nowchar	boolean, for WINTERFACE don't use WCHAR
	dobigint	boolean, force SQL_BIGINT on INTEGER columns

Returns:: SQL data type

Definition at line 2211 of file sqlite3odbc.c.

References TOLOWER(), xfree, and xmalloc.

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

static SQLRETURN mkbindcols	(	STMT *	s,
		int	ncols
	)			`[static]`

Reallocate space for bound columns.

Parameters:

	s	statement pointer
	ncols	number of columns

Returns:: ODBC error code

Definition at line 13735 of file sqlite3odbc.c.

References stmt::bindcols, BINDCOL::index, BINDCOL::lenp, BINDCOL::max, stmt::nbindcols, nomem(), BINDCOL::offs, BINDCOL::type, unbindcols(), BINDCOL::valp, xmalloc, and xrealloc.

Referenced by drvbindcol(), mkresultset(), and s3stmt_step().

static SQLRETURN mkresultset	(	HSTMT	stmt,
		COL *	colspec,
		int	ncols,
		COL *	colspec3,
		int	ncols3,
		int *	nret
	)			`[static]`

Setup empty result set from constant column specification.

Parameters:

	stmt	statement handle
	colspec	column specification array (default, ODBC2)
	ncols	number of columns (default, ODBC2)
	colspec3	column specification array (ODBC3)
	ncols3	number of columns (ODBC3)
	nret	returns number of columns

Returns:: ODBC error code

Definition at line 5912 of file sqlite3odbc.c.

References stmt::cols, stmt::dbc, freeresult(), stmt::isselect, mkbindcols(), stmt::ncols, noconn(), stmt::nowchar, stmt::nrows, stmt::ov3, stmt::rowp, stmt::rowprs, s3stmt_end_if(), and dbc::sqlite.

Referenced by drvcolumns(), drvforeignkeys(), drvgettypeinfo(), drvprimarykeys(), drvspecialcolumns(), drvstatistics(), drvtableprivileges(), drvtables(), SQLColumnPrivilegesW(), SQLProcedureColumnsW(), and SQLProceduresW().

static void mktypeinfo	(	STMT *	s,
		int	row,
		int	asize,
		char *	typename,
		int	type,
		int	tind
	)			`[static]`

Internal function to build up data type information as row in result set.

Parameters:

	s	statement pointer
	row	row number
	asize	number of items in a row
	typename	name of type
	type	integer SQL type
	tind	type index

Definition at line 15415 of file sqlite3odbc.c.

References stmt::rows, and stringify.

Referenced by drvgettypeinfo().

static int namematch	(	char *	str,
		char *	pat,
		int	esc
	)			`[static]`

SQL LIKE string match with optional backslash escape handling.

Parameters:

	str	string
	pat	pattern
	esc	when true, treat literally "\\" as "\", "\%" as "%", "\_" as "_"

Returns:: true when pattern matched

Definition at line 1980 of file sqlite3odbc.c.

References TOLOWER().

Referenced by drvcolumns().

static SQLRETURN noconn ( STMT * s ) [static]

Report S1000 (not connected) SQL error given STMT.

Parameters:

s

statement pointer

Returns:: ODBC error code

Definition at line 1860 of file sqlite3odbc.c.

References stmt::ov3, and setstat().

Referenced by mkresultset().

static SQLRETURN nomem ( STMT * s ) [static]

Report S1000 (out of memory) SQL error given STMT.

Parameters:

s

statement pointer

Returns:: ODBC error code

Definition at line 1847 of file sqlite3odbc.c.

References stmt::ov3, and setstat().

Referenced by drvbindparam(), drvbulkoperations(), drvcolumns(), drvforeignkeys(), drvgettable_row(), drvgettypeinfo(), drvprimarykeys(), drvputdata(), drvsetpos(), drvsetstmtattr(), drvsetstmtoption(), drvspecialcolumns(), drvstatistics(), drvtableprivileges(), drvtables(), getrowdata(), mkbindcols(), s3stmt_step(), setposbind(), setupparam(), setupparbuf(), SQLColumnsW(), SQLForeignKeysW(), SQLGetCursorNameW(), SQLPrimaryKeysW(), SQLSetCursorNameW(), SQLSpecialColumnsW(), SQLStatisticsW(), SQLTablePrivilegesW(), SQLTablesW(), xpath_connect(), xpath_update(), and zip_inflate_func().

static void s3bind	(	DBC *	d,
		sqlite3_stmt *	stmt,
		int	nparams,
		BINDPARM *	p
	)			`[static]`

Definition at line 1335 of file sqlite3odbc.c.

References BINDPARM::s3dval, BINDPARM::s3ival, BINDPARM::s3lival, BINDPARM::s3size, BINDPARM::s3type, BINDPARM::s3val, and dbc::trace.

Referenced by drvgettable(), and s3stmt_start().

static char* s3stmt_coltype	(	sqlite3_stmt *	s3stmt,
		int	col,
		DBC *	d,
		int *	guessed_types
	)			`[static]`

Find out column type.

Parameters:

	s3stmt	SQLite statement pointer
	col	column number
	d	DBC pointer (for tracing only)
	guessed_types	flag array

Returns:: type name as string

Definition at line 4215 of file sqlite3odbc.c.

References dbc::trace.

Referenced by s3stmt_step().

static void s3stmt_drop ( STMT * s ) [static]

Drop running sqlite statement in STMT.

Parameters:

s

statement pointer

Definition at line 4601 of file sqlite3odbc.c.

References stmt::dbc, dbtraceapi(), stmt::s3stmt, and stmt::s3stmt_rownum.

Referenced by freestmt().

static void s3stmt_end ( STMT * s ) [static]

Stop running sqlite statement.

Parameters:

s

statement pointer

Definition at line 4555 of file sqlite3odbc.c.

References dbc::busyint, dbc::cur_s3stmt, stmt::dbc, dbtraceapi(), stmt::s3stmt, stmt::s3stmt_noreset, and stmt::s3stmt_rownum.

Referenced by drvdisconnect(), drvsetconnectattr(), drvsetconnectoption(), and s3stmt_end_if().

static void s3stmt_end_if ( STMT * s ) [static]

Conditionally stop running sqlite statement.

Parameters:

s

statement pointer

Definition at line 4583 of file sqlite3odbc.c.

References dbc::busyint, dbc::cur_s3stmt, stmt::dbc, and s3stmt_end().

Referenced by drvfreestmt(), and mkresultset().

static SQLRETURN s3stmt_start ( STMT * s ) [static]

Start sqlite statement for execution of SELECT statement.

Parameters:

s

statement pointer

Returns:: ODBC error code

Definition at line 4622 of file sqlite3odbc.c.

References stmt::bindparms, dbc::cur_s3stmt, stmt::dbc, dbtraceapi(), dbtracerc(), stmt::nparams, stmt::ov3, stmt::query, s3bind(), stmt::s3stmt, dbc::s3stmt_needmeta, stmt::s3stmt_noreset, stmt::s3stmt_rownum, setstat(), and dbc::sqlite.

static int s3stmt_step ( STMT * s ) [static]

Do one sqlite statement step gathering one result row.

Parameters:

s

statement pointer

Returns:: ODBC error code

Definition at line 4308 of file sqlite3odbc.c.

References COL::autoinc, stmt::cols, COL::column, dbc::cur_s3stmt, COL::db, stmt::dbc, dbtraceapi(), stmt::dcols, stmt::dyncols, fixupdyncols(), freedyncols(), freeresult(), freerows(), COL::index, COL::ispk, COL::isrowid, COL::label, stmt::longnames, mkbindcols(), stmt::ncols, nomem(), COL::nosign, COL::notnull, stmt::nrows, stmt::ov3, COL::prec, PTRDIFF_T, stmt::rowfree, stmt::rows, stmt::s3stmt, s3stmt_coltype(), dbc::s3stmt_needmeta, stmt::s3stmt_noreset, stmt::s3stmt_rownum, COL::scale, setstat(), COL::size, dbc::sqlite, COL::table, dbc::trace, COL::type, COL::typename, xdigits, xmalloc, and xstrdup.

Referenced by drvfetchscroll().

static SQLRETURN setposbind	(	STMT *	s,
		sqlite3_stmt *	stmt,
		int	i,
		int	si,
		int	rsi
	)			`[static]`

Internal handler to setup parameters for positional updates from bound user buffers.

Parameters:

	s	statement handle
	stmt	SQLite3 statement pointer
	i	result set column index
	si	SQLite3 parameter index
	rsi	result set row index

Returns:: ODBC error code

Definition at line 9635 of file sqlite3odbc.c.

References stmt::bind_offs, stmt::bind_type, stmt::bindcols, stmt::cols, stmt::dbc, stmt::jdconv, nomem(), stmt::oemcp, stmt::ov3, setstat(), SQLLEN, dbc::trace, uc_free(), and uc_to_utf().

Referenced by drvbulkoperations(), and drvsetpos().

static SQLRETURN setposibind	(	STMT *	s,
		sqlite3_stmt *	stmt,
		int	i,
		int	si,
		int	rsi
	)			`[static]`

Internal handler to setup parameters for positional updates from driver side result set.

Parameters:

	s	statement handle
	stmt	SQLite3 statement pointer
	i	result set column index
	si	SQLite3 parameter index
	rsi	result set row index

Returns:: ODBC error code

Definition at line 9975 of file sqlite3odbc.c.

References stmt::dbc, stmt::ncols, stmt::ov3, stmt::rowprs, stmt::rows, setstat(), and dbc::trace.

Referenced by drvsetpos().

static SQLRETURN setposrefr	(	STMT *	s,
		int	rsi
	)			`[static]`

Internal handler to refresh user buffers from driver side result set.

Parameters:

	s	statement handle
	rsi	result set row index

Returns:: ODBC error code

Definition at line 10012 of file sqlite3odbc.c.

References stmt::bind_offs, stmt::bind_type, stmt::bindcols, getrowdata(), BINDCOL::lenp, BINDCOL::max, stmt::ncols, BINDCOL::offs, stmt::row_status0, stmt::rowp, stmt::rowprs, SQLLEN, BINDCOL::type, and BINDCOL::valp.

Referenced by drvsetpos().

static int setsqliteopts	(	sqlite3 *	x,
		DBC *	d
	)			`[static]`

Set SQLite options (PRAGMAs) given SQLite handle.

Parameters:

	x	SQLite database handle
	d	DBC pointer

Returns:: SQLite error code

SQLite < 3.3.x and not shortnames DSN option: "full_column_names" is always turned on and "short_column_names" is always turned off, to get the table names in column labels.

Definition at line 2128 of file sqlite3odbc.c.

References busy_handler(), dbc::fksupport, dbc::longnames, max, and dbc::shortnames.

Referenced by dbopen().

static void setstat	(	STMT *	s,
		int	naterr,
		char *	msg,
		char *	st,
			...
	)			`[static]`

Set error message and SQL state on statement.

Parameters:

	s	statement pointer
	naterr	native error code
	msg	error message
	st	SQL state

Definition at line 1762 of file sqlite3odbc.c.

References stmt::logmsg, stmt::naterr, and stmt::sqlstate.

Referenced by chkunbound(), drvbindcol(), drvbindparam(), drvbulkoperations(), drvcolattributes(), drvcolumns(), drvdescribecol(), drvfetchscroll(), drvforeignkeys(), drvfreestmt(), drvprimarykeys(), drvputdata(), drvsetcursorname(), drvsetpos(), drvsetstmtattr(), drvsetstmtoption(), drvspecialcolumns(), drvstatistics(), drvunimplstmt(), getrowdata(), noconn(), nomem(), s3stmt_start(), s3stmt_step(), setposbind(), setposibind(), setupparam(), setupparbuf(), SQLDescribeParam(), SQLGetData(), SQLNativeSqlW(), and starttran().

static void setstatd	(	DBC *	d,
		int	naterr,
		char *	msg,
		char *	st,
			...
	)			`[static]`

Set error message and SQL state on DBC.

Parameters:

	d	database connection pointer
	naterr	native error code
	msg	error message
	st	SQL state

Definition at line 1722 of file sqlite3odbc.c.

References dbc::logmsg, dbc::naterr, and dbc::sqlstate.

Referenced by dbopen(), drvconnect(), drvdisconnect(), drvdriverconnect(), drvfreeconnect(), drvgetconnectattr(), drvgetconnectoption(), drvgetinfo(), drvsetconnectattr(), drvsetconnectoption(), drvunimpldbc(), endtran(), and SQLConnectW().

static SQLRETURN setupdyncols	(	STMT *	s,
		sqlite3_stmt *	s3stmt,
		int *	ncolsp
	)			`[static]`

Referenced by drvgettable_row().

static SQLRETURN setupparam	(	STMT *	s,
		char *	sql,
		int	pnum
	)			`[static]`

Setup SQLite3 parameter for statement parameter.

Parameters:

	s	statement pointer
	sql	sql string
	pnum	parameter number

Returns:: ODBC error code

The parameter is converted within BINDPARM in order to be presented to sqlite3_bind_*() functions.

Definition at line 5054 of file sqlite3odbc.c.

References stmt::bindparms, BINDPARM::coldef, freep(), stmt::jdconv, BINDPARM::len, BINDPARM::lenp, mapdeftype(), BINDPARM::max, stmt::nbindparms, BINDPARM::need, nomem(), stmt::nowchar, stmt::oemcp, stmt::ov3, BINDPARM::param, BINDPARM::parbuf, BINDPARM::s3dval, BINDPARM::s3ival, BINDPARM::s3lival, BINDPARM::s3size, BINDPARM::s3type, BINDPARM::s3val, setstat(), setupparbuf(), BINDPARM::strbuf, BINDPARM::stype, BINDPARM::type, uc_strlen(), uc_to_utf(), and xmalloc.

static SQLRETURN setupparbuf	(	STMT *	s,
		BINDPARM *	p
	)			`[static]`

Setup parameter buffer for deferred parameter.

Parameters:

	s	pointer to STMT
	p	pointer to BINDPARM

Returns:: ODBC error code (success indicated by SQL_NEED_DATA)

Definition at line 5614 of file sqlite3odbc.c.

References BINDPARM::len, BINDPARM::lenp, BINDPARM::max, nomem(), BINDPARM::param, BINDPARM::parbuf, setstat(), and xmalloc.

Referenced by setupparam(), and SQLParamData().

SQLRETURN SQL_API SQLAllocConnect	(	SQLHENV	env,
		SQLHDBC *	dbc
	)

Allocate HDBC.

Parameters:

	env	environment handle
	dbc	pointer to database connection handle

Returns:: ODBC error code

Definition at line 11854 of file sqlite3odbc.c.

References drvallocconnect().

SQLRETURN SQL_API SQLAllocEnv ( SQLHENV * env )

Allocate HENV.

Parameters:

env

pointer to environment handle

Returns:: ODBC error code

Definition at line 11726 of file sqlite3odbc.c.

References drvallocenv().

SQLRETURN SQL_API SQLAllocHandle	(	SQLSMALLINT	type,
		SQLHANDLE	input,
		SQLHANDLE *	output
	)

Allocate a HENV, HDBC, or HSTMT handle.

Parameters:

	type	handle type
	input	input handle (HENV, HDBC)
	output	pointer to output handle (HENV, HDBC, HSTMT)

Returns:: ODBC error code

Definition at line 13597 of file sqlite3odbc.c.

References drvallocconnect(), drvallocenv(), drvallocstmt(), ENV_MAGIC, HDBC_LOCK, HDBC_UNLOCK, ENV::magic, and ENV::ov3.

SQLRETURN SQL_API SQLAllocStmt	(	SQLHDBC	dbc,
		SQLHSTMT *	stmt
	)

Allocate HSTMT given HDBC.

Parameters:

	dbc	database connection handle
	stmt	pointer to statement handle

Returns:: ODBC error code

Definition at line 13233 of file sqlite3odbc.c.

References drvallocstmt(), HDBC_LOCK, and HDBC_UNLOCK.

SQLRETURN SQL_API SQLBindCol	(	SQLHSTMT	stmt,
		SQLUSMALLINT	col,
		SQLSMALLINT	type,
		SQLPOINTER	val,
		SQLLEN	max,
		SQLLEN *	lenp
	)

Bind C variable to column of result set.

Parameters:

	stmt	statement handle
	col	column number, starting at 1
	type	output type
	val	output buffer
	max	length of output buffer
	lenp	output length pointer

Returns:: ODBC error code

Definition at line 14477 of file sqlite3odbc.c.

References drvbindcol(), HSTMT_LOCK, and HSTMT_UNLOCK.

SQLRETURN SQL_API SQLBindParam	(	SQLHSTMT	stmt,
		SQLUSMALLINT	pnum,
		SQLSMALLINT	vtype,
		SQLSMALLINT	ptype,
		SQLULEN	lenprec,
		SQLSMALLINT	scale,
		SQLPOINTER	val,
		SQLLEN *	lenp
	)

Bind parameter on HSTMT.

Parameters:

	stmt	statement handle
	pnum	parameter number, starting at 1
	vtype	input/output type of parameter
	ptype
	lenprec
	scale
	val	pointer to host variable
	lenp	output length pointer

Returns:: ODBC error code

Definition at line 5565 of file sqlite3odbc.c.

References drvbindparam(), HSTMT_LOCK, and HSTMT_UNLOCK.

SQLRETURN SQL_API SQLBindParameter	(	SQLHSTMT	stmt,
		SQLUSMALLINT	pnum,
		SQLSMALLINT	iotype,
		SQLSMALLINT	buftype,
		SQLSMALLINT	ptype,
		SQLULEN	coldef,
		SQLSMALLINT	scale,
		SQLPOINTER	data,
		SQLLEN	buflen,
		SQLLEN *	len
	)

Bind parameter on HSTMT.

Parameters:

	stmt	statement handle
	pnum	parameter number, starting at 1
	iotype	input/output type of parameter
	buftype	type of host variable
	ptype
	coldef
	scale
	data	pointer to host variable
	buflen	length of host variable
	len	output length pointer

Returns:: ODBC error code

Definition at line 5536 of file sqlite3odbc.c.

References drvbindparam(), HSTMT_LOCK, and HSTMT_UNLOCK.

SQLRETURN SQL_API SQLBrowseConnectW	(	SQLHDBC	dbc,
		SQLWCHAR *	connin,
		SQLSMALLINT	conninLen,
		SQLWCHAR *	connout,
		SQLSMALLINT	connoutMax,
		SQLSMALLINT *	connoutLen
	)

Function not implemented.

Definition at line 4772 of file sqlite3odbc.c.

References drvunimpldbc(), HDBC_LOCK, and HDBC_UNLOCK.

SQLRETURN SQL_API SQLBulkOperations	(	SQLHSTMT	stmt,
		SQLSMALLINT	oper
	)

Perform bulk operation on HSTMT.

Parameters:

	stmt	statement handle
	oper	operation to be performed

Returns:: ODBC error code

Definition at line 10872 of file sqlite3odbc.c.

References drvbulkoperations(), HSTMT_LOCK, and HSTMT_UNLOCK.

SQLRETURN SQL_API SQLCancel ( SQLHSTMT stmt )

Cancel HSTMT closing cursor.

Parameters:

stmt

statement handle

Returns:: ODBC error code

Definition at line 13307 of file sqlite3odbc.c.

References dbc::busyint, DBC_MAGIC, drvfreestmt(), dbc::magic, and dbc::sqlite.

SQLRETURN SQL_API SQLCloseCursor ( SQLHSTMT stmt )

Close open cursor.

Parameters:

stmt

statement handle

Returns:: ODBC error code

Definition at line 13583 of file sqlite3odbc.c.

References drvfreestmt().

SQLRETURN SQL_API SQLColumnPrivilegesW	(	SQLHSTMT	stmt,
		SQLWCHAR *	catalog,
		SQLSMALLINT	catalogLen,
		SQLWCHAR *	schema,
		SQLSMALLINT	schemaLen,
		SQLWCHAR *	table,
		SQLSMALLINT	tableLen,
		SQLWCHAR *	column,
		SQLSMALLINT	columnLen
	)

Retrieve privileges on columns (UNICODE version).

Parameters:

	stmt	statement handle
	catalog	catalog name/pattern or NULL
	catalogLen	length of catalog name/pattern or SQL_NTS
	schema	schema name/pattern or NULL
	schemaLen	length of schema name/pattern or SQL_NTS
	table	table name/pattern or NULL
	tableLen	length of table name/pattern or SQL_NTS
	column	column name or NULL
	columnLen	length of column name or SQL_NTS

Returns:: ODBC error code

Definition at line 6397 of file sqlite3odbc.c.

References array_size, HSTMT_LOCK, HSTMT_UNLOCK, and mkresultset().

SQLRETURN SQL_API SQLColumnsW	(	SQLHSTMT	stmt,
		SQLWCHAR *	cat,
		SQLSMALLINT	catLen,
		SQLWCHAR *	schema,
		SQLSMALLINT	schemaLen,
		SQLWCHAR *	table,
		SQLSMALLINT	tableLen,
		SQLWCHAR *	col,
		SQLSMALLINT	colLen
	)

Retrieve column information on table (UNICODE version).

Parameters:

	stmt	statement handle
	cat	catalog name/pattern or NULL
	catLen	length of catalog name/pattern or SQL_NTS
	schema	schema name/pattern or NULL
	schemaLen	length of schema name/pattern or SQL_NTS
	table	table name/pattern or NULL
	tableLen	length of table name/pattern or SQL_NTS
	col	column name/pattern or NULL
	colLen	length of column name/pattern or SQL_NTS

Returns:: ODBC error code

Definition at line 15309 of file sqlite3odbc.c.

References drvcolumns(), HSTMT_LOCK, HSTMT_UNLOCK, nomem(), uc_free(), and uc_to_utf_c().

SQLRETURN SQL_API SQLConnectW	(	SQLHDBC	dbc,
		SQLWCHAR *	dsn,
		SQLSMALLINT	dsnLen,
		SQLWCHAR *	uid,
		SQLSMALLINT	uidLen,
		SQLWCHAR *	pwd,
		SQLSMALLINT	pwdLen
	)

Connect to SQLite database.

Parameters:

	dbc	database connection handle
	dsn	DSN string
	dsnLen	length of DSN string or SQL_NTS
	uid	user id string or NULL
	uidLen	length of user id string or SQL_NTS
	pwd	password string or NULL
	pwdLen	length of password string or SQL_NTS

Returns:: ODBC error code

Definition at line 12756 of file sqlite3odbc.c.

References drvconnect(), HDBC_LOCK, HDBC_UNLOCK, dbc::ov3, setstatd(), uc_free(), and uc_to_utf_c().

SQLRETURN SQL_API SQLCopyDesc	(	SQLHDESC	source,
		SQLHDESC	target
	)

Function not implemented.

Definition at line 8087 of file sqlite3odbc.c.

SQLRETURN SQL_API SQLDataSourcesW	(	SQLHENV	env,
		SQLUSMALLINT	dir,
		SQLWCHAR *	srvname,
		SQLSMALLINT	buflen1,
		SQLSMALLINT *	lenp1,
		SQLWCHAR *	desc,
		SQLSMALLINT	buflen2,
		SQLSMALLINT *	lenp2
	)

Function not implemented.

Definition at line 4702 of file sqlite3odbc.c.

SQLRETURN SQL_API SQLDescribeColW	(	SQLHSTMT	stmt,
		SQLUSMALLINT	col,
		SQLWCHAR *	name,
		SQLSMALLINT	nameMax,
		SQLSMALLINT *	nameLen,
		SQLSMALLINT *	type,
		SQLULEN *	size,
		SQLSMALLINT *	digits,
		SQLSMALLINT *	nullable
	)

Describe column information (UNICODE version).

Parameters:

	stmt	statement handle
	col	column number, starting at 1
	name	buffer for column name
	nameMax	length of name buffer
	nameLen	output length of column name
	type	output SQL type
	size	output column size
	digits	output number of digits
	nullable	output NULL allowed indicator

Returns:: ODBC error code

Definition at line 16961 of file sqlite3odbc.c.

References stmt::cols, COL::column, drvdescribecol(), HSTMT_LOCK, HSTMT_UNLOCK, min, uc_free(), uc_from_utf(), uc_strlen(), and uc_strncpy().

SQLRETURN SQL_API SQLDescribeParam	(	SQLHSTMT	stmt,
		SQLUSMALLINT	pnum,
		SQLSMALLINT *	dtype,
		SQLULEN *	size,
		SQLSMALLINT *	decdigits,
		SQLSMALLINT *	nullable
	)

Return information about parameter.

Parameters:

	stmt	statement handle
	pnum	parameter number, starting at 1
	dtype	output type indicator
	size	output size indicator
	decdigits	output number of digits
	nullable	output NULL allowed indicator

Returns:: ODBC error code

Definition at line 5702 of file sqlite3odbc.c.

References HSTMT_LOCK, HSTMT_UNLOCK, stmt::nowchar, stmt::nparams, stmt::ov3, and setstat().

SQLRETURN SQL_API SQLDisconnect ( SQLHDBC dbc )

Disconnect given HDBC.

Parameters:

dbc

database connection handle

Returns:: ODBC error code

Definition at line 12845 of file sqlite3odbc.c.

References drvdisconnect(), HDBC_LOCK, and HDBC_UNLOCK.

SQLRETURN SQL_API SQLDriversW	(	SQLHENV	env,
		SQLUSMALLINT	dir,
		SQLWCHAR *	drvdesc,
		SQLSMALLINT	descmax,
		SQLSMALLINT *	desclenp,
		SQLWCHAR *	drvattr,
		SQLSMALLINT	attrmax,
		SQLSMALLINT *	attrlenp
	)

Function not implemented.

Definition at line 4736 of file sqlite3odbc.c.

SQLRETURN SQL_API SQLEndTran	(	SQLSMALLINT	type,
		SQLHANDLE	handle,
		SQLSMALLINT	comptype
	)

Commit or rollback transaction.

Parameters:

	type	type of handle
	handle	HDBC, HENV, or HSTMT handle
	comptype	SQL_COMMIT or SQL_ROLLBACK

Returns:: ODBC error code

Definition at line 8060 of file sqlite3odbc.c.

References drvendtran().

SQLRETURN SQL_API SQLExtendedFetch	(	SQLHSTMT	stmt,
		SQLUSMALLINT	orient,
		SQLROWOFFSET	offset,
		SQLROWSETSIZE *	rowcount,
		SQLUSMALLINT *	rowstatus
	)

Fetch result row with scrolling and row status.

Parameters:

	stmt	statement handle
	orient	fetch direction
	offset	offset for fetch direction
	rowcount	output number of fetched rows
	rowstatus	array for row stati

Returns:: ODBC error code

Definition at line 16704 of file sqlite3odbc.c.

References stmt::bkmrkptr, drvfetchscroll(), HSTMT_LOCK, HSTMT_UNLOCK, stmt::row_count0, stmt::row_status, stmt::row_status0, and stmt::rowset_size.

SQLRETURN SQL_API SQLFetch ( SQLHSTMT stmt )

Fetch next result row.

Parameters:

stmt

statement handle

Returns:: ODBC error code

Definition at line 16664 of file sqlite3odbc.c.

References drvfetchscroll(), HSTMT_LOCK, and HSTMT_UNLOCK.

SQLRETURN SQL_API SQLFetchScroll	(	SQLHSTMT	stmt,
		SQLSMALLINT	orient,
		SQLLEN	offset
	)

Fetch result row with scrolling.

Parameters:

	stmt	statement handle
	orient	fetch direction
	offset	offset for fetch direction

Returns:: ODBC error code

Definition at line 16683 of file sqlite3odbc.c.

References drvfetchscroll(), HSTMT_LOCK, and HSTMT_UNLOCK.

SQLRETURN SQL_API SQLForeignKeysW	(	SQLHSTMT	stmt,
		SQLWCHAR *	PKcatalog,
		SQLSMALLINT	PKcatalogLen,
		SQLWCHAR *	PKschema,
		SQLSMALLINT	PKschemaLen,
		SQLWCHAR *	PKtable,
		SQLSMALLINT	PKtableLen,
		SQLWCHAR *	FKcatalog,
		SQLSMALLINT	FKcatalogLen,
		SQLWCHAR *	FKschema,
		SQLSMALLINT	FKschemaLen,
		SQLWCHAR *	FKtable,
		SQLSMALLINT	FKtableLen
	)

Retrieve information about primary/foreign keys (UNICODE version).

Parameters:

	stmt	statement handle
	PKcatalog	primary key catalog name/pattern or NULL
	PKcatalogLen	length of PKcatalog or SQL_NTS
	PKschema	primary key schema name/pattern or NULL
	PKschemaLen	length of PKschema or SQL_NTS
	PKtable	primary key table name/pattern or NULL
	PKtableLen	length of PKtable or SQL_NTS
	FKcatalog	foreign key catalog name/pattern or NULL
	FKcatalogLen	length of FKcatalog or SQL_NTS
	FKschema	foreign key schema name/pattern or NULL
	FKschemaLen	length of FKschema or SQL_NTS
	FKtable	foreign key table name/pattern or NULL
	FKtableLen	length of FKtable or SQL_NTS

Returns:: ODBC error code

Definition at line 7823 of file sqlite3odbc.c.

References drvforeignkeys(), HSTMT_LOCK, HSTMT_UNLOCK, nomem(), uc_free(), and uc_to_utf_c().

SQLRETURN SQL_API SQLFreeConnect ( SQLHDBC dbc )

Free connection (HDBC).

Parameters:

dbc

database connection handle

Returns:: ODBC error code

Definition at line 11944 of file sqlite3odbc.c.

References drvfreeconnect().

SQLRETURN SQL_API SQLFreeEnv ( SQLHENV env )

Free HENV.

Parameters:

env

environment handle

Returns:: ODBC error code

Definition at line 11774 of file sqlite3odbc.c.

References drvfreeenv().

SQLRETURN SQL_API SQLFreeHandle	(	SQLSMALLINT	type,
		SQLHANDLE	h
	)

Free a HENV, HDBC, or HSTMT handle.

Parameters:

	type	handle type
	h	handle (HENV, HDBC, or HSTMT)

Returns:: ODBC error code

Definition at line 13631 of file sqlite3odbc.c.

References drvfreeconnect(), drvfreeenv(), and drvfreestmt().

SQLRETURN SQL_API SQLFreeStmt	(	SQLHSTMT	stmt,
		SQLUSMALLINT	opt
	)

Free HSTMT.

Parameters:

	stmt	statement handle
	opt	SQL_RESET_PARAMS, SQL_UNBIND, SQL_CLOSE, or SQL_DROP

Returns:: ODBC error code

Definition at line 13295 of file sqlite3odbc.c.

References drvfreestmt().

SQLRETURN SQL_API SQLGetConnectAttrW	(	SQLHDBC	dbc,
		SQLINTEGER	attr,
		SQLPOINTER	val,
		SQLINTEGER	bufmax,
		SQLINTEGER *	buflen
	)

Get connect attribute of HDBC (UNICODE version).

Parameters:

	dbc	database connection handle
	attr	option to be retrieved
	val	output buffer
	bufmax	size of output buffer
	buflen	output length

Returns:: ODBC error code

Definition at line 12132 of file sqlite3odbc.c.

References drvgetconnectattr(), HDBC_LOCK, HDBC_UNLOCK, min, uc_free(), uc_from_utf(), uc_strlen(), and uc_strncpy().

SQLRETURN SQL_API SQLGetConnectOptionW	(	SQLHDBC	dbc,
		SQLUSMALLINT	opt,
		SQLPOINTER	param
	)

Get connect option of HDBC (UNICODE version).

Parameters:

	dbc	database connection handle
	opt	option to be retrieved
	param	output buffer

Returns:: ODBC error code

Definition at line 12395 of file sqlite3odbc.c.

References drvgetconnectoption(), HDBC_LOCK, and HDBC_UNLOCK.

SQLRETURN SQL_API SQLGetCursorNameW	(	SQLHSTMT	stmt,
		SQLWCHAR *	cursor,
		SQLSMALLINT	buflen,
		SQLSMALLINT *	lenp
	)

Get cursor name of STMT (UNICODE version).

Parameters:

	stmt	statement handle
	cursor	output buffer
	buflen	length of output buffer
	lenp	output length

Returns:: ODBC error code

Definition at line 13432 of file sqlite3odbc.c.

References drvgetcursorname(), HSTMT_LOCK, HSTMT_UNLOCK, min, nomem(), uc_free(), uc_from_utf(), uc_strlen(), and uc_strncpy().

SQLRETURN SQL_API SQLGetData	(	SQLHSTMT	stmt,
		SQLUSMALLINT	col,
		SQLSMALLINT	type,
		SQLPOINTER	val,
		SQLLEN	len,
		SQLLEN *	lenp
	)

Retrieve row data after fetch.

Parameters:

	stmt	statement handle
	col	column number, starting at 1
	type	output type
	val	output buffer
	len	length of output buffer
	lenp	output length

Returns:: ODBC error code

Definition at line 16257 of file sqlite3odbc.c.

References stmt::bkmrk, getrowdata(), stmt::has_rowid, HSTMT_LOCK, HSTMT_UNLOCK, stmt::ncols, stmt::ov3, stmt::rowp, stmt::rows, and setstat().

SQLRETURN SQL_API SQLGetDescFieldW	(	SQLHDESC	handle,
		SQLSMALLINT	recno,
		SQLSMALLINT	fieldid,
		SQLPOINTER	value,
		SQLINTEGER	buflen,
		SQLINTEGER *	strlen
	)

Function not implemented.

Definition at line 5816 of file sqlite3odbc.c.

SQLRETURN SQL_API SQLGetDescRecW	(	SQLHDESC	handle,
		SQLSMALLINT	recno,
		SQLWCHAR *	name,
		SQLSMALLINT	buflen,
		SQLSMALLINT *	strlen,
		SQLSMALLINT *	type,
		SQLSMALLINT *	subtype,
		SQLLEN *	len,
		SQLSMALLINT *	prec,
		SQLSMALLINT *	scale,
		SQLSMALLINT *	nullable
	)

Function not implemented.

Definition at line 5875 of file sqlite3odbc.c.

SQLRETURN SQL_API SQLGetDiagFieldW	(	SQLSMALLINT	htype,
		SQLHANDLE	handle,
		SQLSMALLINT	recno,
		SQLSMALLINT	id,
		SQLPOINTER	info,
		SQLSMALLINT	buflen,
		SQLSMALLINT *	stringlen
	)

Get error record given handle (HDBC or HSTMT).

Parameters:

	htype	handle type
	handle	HDBC or HSTMT
	recno	diag record number for which info to be retrieved
	id	diag id for which info to be retrieved
	info	output buffer for error message
	buflen	length of output buffer
	stringlen	output length

Returns:: ODBC error code

Definition at line 8915 of file sqlite3odbc.c.

References drvgetdiagfield(), min, uc_free(), uc_from_utf(), uc_strlen(), and uc_strncpy().

SQLRETURN SQL_API SQLGetDiagRecW	(	SQLSMALLINT	htype,
		SQLHANDLE	handle,
		SQLSMALLINT	recno,
		SQLWCHAR *	sqlstate,
		SQLINTEGER *	nativeerr,
		SQLWCHAR *	msg,
		SQLSMALLINT	buflen,
		SQLSMALLINT *	msglen
	)

Get error message given handle (HENV, HDBC, or HSTMT) (UNICODE version).

Parameters:

	htype	handle type
	handle	HENV, HDBC, or HSTMT
	recno
	sqlstate	output buffer for SQL state
	nativeerr	output buffer of native error code
	msg	output buffer for error message
	buflen	length of output buffer
	msglen	output length

Returns:: ODBC error code

Definition at line 8638 of file sqlite3odbc.c.

References drvgetdiagrec(), min, uc_free(), uc_from_utf(), uc_from_utf_buf(), uc_strlen(), and uc_strncpy().

SQLRETURN SQL_API SQLGetEnvAttr	(	SQLHENV	env,
		SQLINTEGER	attr,
		SQLPOINTER	val,
		SQLINTEGER	len,
		SQLINTEGER *	lenp
	)

Get information of HENV.

Parameters:

	env	environment handle
	attr	attribute to be retrieved
	val	output buffer
	len	length of output buffer
	lenp	output length

Returns:: ODBC error code

Definition at line 8388 of file sqlite3odbc.c.

References ENV_MAGIC, ENV::magic, and ENV::ov3.

SQLRETURN SQL_API SQLGetFunctions	(	SQLHDBC	dbc,
		SQLUSMALLINT	func,
		SQLUSMALLINT *	flags
	)

Return information about supported ODBC API functions.

Parameters:

	dbc	database connection handle
	func	function code to be retrieved
	flags	output indicator

Returns:: ODBC error code

Definition at line 11544 of file sqlite3odbc.c.

References array_size, and SET_EXISTS.

SQLRETURN SQL_API SQLGetInfoW	(	SQLHDBC	dbc,
		SQLUSMALLINT	type,
		SQLPOINTER	val,
		SQLSMALLINT	valMax,
		SQLSMALLINT *	valLen
	)

Return information about what this ODBC driver supports.

Parameters:

	dbc	database connection handle
	type	type of information to be retrieved
	val	output buffer
	valMax	length of output buffer
	valLen	output length

Returns:: ODBC error code

Definition at line 11441 of file sqlite3odbc.c.

References drvgetinfo(), HDBC_LOCK, HDBC_UNLOCK, min, uc_free(), uc_from_utf(), uc_strlen(), and uc_strncpy().

SQLRETURN SQL_API SQLGetStmtAttrW	(	SQLHSTMT	stmt,
		SQLINTEGER	attr,
		SQLPOINTER	val,
		SQLINTEGER	bufmax,
		SQLINTEGER *	buflen
	)

Get option of HSTMT (UNICODE version).

Parameters:

	stmt	statement handle
	attr	attribute to be retrieved
	val	output buffer
	bufmax	length of output buffer
	buflen	output length

Returns:: ODBC error code

Definition at line 9164 of file sqlite3odbc.c.

References drvgetstmtattr(), HSTMT_LOCK, and HSTMT_UNLOCK.

SQLRETURN SQL_API SQLGetStmtOption	(	SQLHSTMT	stmt,
		SQLUSMALLINT	opt,
		SQLPOINTER	param
	)

Get option of HSTMT.

Parameters:

	stmt	statement handle
	opt	option to be retrieved
	param	output buffer

Returns:: ODBC error code

Definition at line 9446 of file sqlite3odbc.c.

References drvgetstmtoption(), HSTMT_LOCK, and HSTMT_UNLOCK.

SQLRETURN SQL_API SQLGetStmtOptionW	(	SQLHSTMT	stmt,
		SQLUSMALLINT	opt,
		SQLPOINTER	param
	)

Get option of HSTMT (UNICODE version).

Parameters:

	stmt	statement handle
	opt	option to be retrieved
	param	output buffer

Returns:: ODBC error code

Definition at line 9466 of file sqlite3odbc.c.

References drvgetstmtoption(), HSTMT_LOCK, and HSTMT_UNLOCK.

SQLRETURN SQL_API SQLGetTypeInfoW	(	SQLHSTMT	stmt,
		SQLSMALLINT	sqltype
	)

Return data type information (UNICODE version).

Parameters:

	stmt	statement handle
	sqltype	which type to retrieve

Returns:: ODBC error code

Definition at line 15791 of file sqlite3odbc.c.

References drvgettypeinfo(), HSTMT_LOCK, and HSTMT_UNLOCK.

SQLRETURN SQL_API SQLNativeSqlW	(	SQLHSTMT	stmt,
		SQLWCHAR *	sqlin,
		SQLINTEGER	sqlinLen,
		SQLWCHAR *	sql,
		SQLINTEGER	sqlMax,
		SQLINTEGER *	sqlLen
	)

Translate SQL string (UNICODE version).

Parameters:

	stmt	statement handle
	sqlin	input string
	sqlinLen	length of input string
	sql	output string
	sqlMax	max space in output string
	sqlLen	value return for length of output string

Returns:: ODBC error code

Definition at line 8149 of file sqlite3odbc.c.

References HSTMT_LOCK, HSTMT_UNLOCK, min, setstat(), uc_strlen(), and uc_strncpy().

SQLRETURN SQL_API SQLNumParams	(	SQLHSTMT	stmt,
		SQLSMALLINT *	nparam
	)

Return number of parameters.

Parameters:

	stmt	statement handle
	nparam	output parameter count

Returns:: ODBC error code

Definition at line 5588 of file sqlite3odbc.c.

References HSTMT_LOCK, HSTMT_UNLOCK, and stmt::nparams.

SQLRETURN SQL_API SQLNumResultCols	(	SQLHSTMT	stmt,
		SQLSMALLINT *	ncols
	)

Return number of columns of result set given HSTMT.

Parameters:

	stmt	statement handle
	ncols	output number of columns

Returns:: ODBC error code

Definition at line 16768 of file sqlite3odbc.c.

References HSTMT_LOCK, HSTMT_UNLOCK, and stmt::ncols.

SQLRETURN SQL_API SQLParamData	(	SQLHSTMT	stmt,
		SQLPOINTER *	pind
	)

Retrieve next parameter for sending data to executing query.

Parameters:

	stmt	statement handle
	pind	pointer to output parameter indicator

Returns:: ODBC error code

Definition at line 5648 of file sqlite3odbc.c.

References stmt::bindparms, drvexecute(), HSTMT_LOCK, HSTMT_UNLOCK, mapdeftype(), BINDPARM::need, stmt::nowchar, stmt::nparams, BINDPARM::param0, stmt::pdcount, setupparbuf(), BINDPARM::stype, and BINDPARM::type.

SQLRETURN SQL_API SQLParamOptions	(	SQLHSTMT	stmt,
		SQLULEN	rows,
		SQLULEN *	rowp
	)

Function not implemented.

Definition at line 5786 of file sqlite3odbc.c.

References drvunimplstmt(), HSTMT_LOCK, and HSTMT_UNLOCK.

SQLRETURN SQL_API SQLPrimaryKeysW	(	SQLHSTMT	stmt,
		SQLWCHAR *	cat,
		SQLSMALLINT	catLen,
		SQLWCHAR *	schema,
		SQLSMALLINT	schemaLen,
		SQLWCHAR *	table,
		SQLSMALLINT	tableLen
	)

Retrieve information about indexed columns (UNICODE version).

Parameters:

	stmt	statement handle
	cat	catalog name/pattern or NULL
	catLen	length of catalog name/pattern or SQL_NTS
	schema	schema name/pattern or NULL
	schemaLen	length of schema name/pattern or SQL_NTS
	table	table name/pattern or NULL
	tableLen	length of table name/pattern or SQL_NTS

Returns:: ODBC error code

Definition at line 6777 of file sqlite3odbc.c.

References drvprimarykeys(), HSTMT_LOCK, HSTMT_UNLOCK, nomem(), uc_free(), and uc_to_utf_c().

SQLRETURN SQL_API SQLProcedureColumnsW	(	SQLHSTMT	stmt,
		SQLWCHAR *	catalog,
		SQLSMALLINT	catalogLen,
		SQLWCHAR *	schema,
		SQLSMALLINT	schemaLen,
		SQLWCHAR *	proc,
		SQLSMALLINT	procLen,
		SQLWCHAR *	column,
		SQLSMALLINT	columnLen
	)

Retrieve information about columns in result set of stored procedures (UNICODE version).

Parameters:

	stmt	statement handle
	catalog	catalog name/pattern or NULL
	catalogLen	length of catalog or SQL_NTS
	schema	schema name/pattern or NULL
	schemaLen	length of schema or SQL_NTS
	proc	procedure name/pattern or NULL
	procLen	length of proc or SQL_NTS
	column	column name/pattern or NULL
	columnLen	length of column or SQL_NTS

Returns:: ODBC error code

Definition at line 8361 of file sqlite3odbc.c.

References array_size, HSTMT_LOCK, HSTMT_UNLOCK, and mkresultset().

SQLRETURN SQL_API SQLProceduresW	(	SQLHSTMT	stmt,
		SQLWCHAR *	catalog,
		SQLSMALLINT	catalogLen,
		SQLWCHAR *	schema,
		SQLSMALLINT	schemaLen,
		SQLWCHAR *	proc,
		SQLSMALLINT	procLen
	)

Retrieve information about stored procedures (UNICODE version).

Parameters:

	stmt	statement handle
	catalog	catalog name/pattern or NULL
	catalogLen	length of catalog or SQL_NTS
	schema	schema name/pattern or NULL
	schemaLen	length of schema or SQL_NTS
	proc	procedure name/pattern or NULL
	procLen	length of proc or SQL_NTS

Returns:: ODBC error code

Definition at line 8249 of file sqlite3odbc.c.

References array_size, HSTMT_LOCK, HSTMT_UNLOCK, and mkresultset().

SQLRETURN SQL_API SQLPutData	(	SQLHSTMT	stmt,
		SQLPOINTER	data,
		SQLLEN	len
	)

Put (partial) parameter data into executing statement.

Parameters:

	stmt	statement handle
	data	pointer to data
	len	length of data

Returns:: ODBC error code

Definition at line 5013 of file sqlite3odbc.c.

References drvputdata(), HSTMT_LOCK, and HSTMT_UNLOCK.

SQLRETURN SQL_API SQLRowCount	(	SQLHSTMT	stmt,
		SQLLEN *	nrows
	)

Return number of affected rows of HSTMT.

Parameters:

	stmt	statement handle
	nrows	output number of rows

Returns:: ODBC error code

Definition at line 16744 of file sqlite3odbc.c.

References HSTMT_LOCK, HSTMT_UNLOCK, stmt::isselect, and stmt::nrows.

SQLRETURN SQL_API SQLSetConnectAttrW	(	SQLHDBC	dbc,
		SQLINTEGER	attr,
		SQLPOINTER	val,
		SQLINTEGER	len
	)

Set connect attribute of HDBC (UNICODE version).

Parameters:

	dbc	database connection handle
	attr	option to be set
	val	option value
	len	size of option

Returns:: ODBC error code

Definition at line 12263 of file sqlite3odbc.c.

References drvsetconnectattr(), HDBC_LOCK, and HDBC_UNLOCK.

SQLRETURN SQL_API SQLSetConnectOptionW	(	SQLHDBC	dbc,
		SQLUSMALLINT	opt,
		SQLULEN	param
	)

Set option on HDBC (UNICODE version).

Parameters:

	dbc	database connection handle
	opt	option to be set
	param	option value

Returns:: ODBC error code

Definition at line 12481 of file sqlite3odbc.c.

References drvsetconnectoption(), HDBC_LOCK, and HDBC_UNLOCK.

SQLRETURN SQL_API SQLSetCursorNameW	(	SQLHSTMT	stmt,
		SQLWCHAR *	cursor,
		SQLSMALLINT	len
	)

Set cursor name on STMT (UNICODE version).

Parameters:

	stmt	statement handle
	cursor	new cursor name
	len	length of cursor name or SQL_NTS

Returns:: ODBC error code

Definition at line 13555 of file sqlite3odbc.c.

References drvsetcursorname(), HSTMT_LOCK, HSTMT_UNLOCK, nomem(), uc_free(), and uc_to_utf_c().

SQLRETURN SQL_API SQLSetDescFieldW	(	SQLHDESC	handle,
		SQLSMALLINT	recno,
		SQLSMALLINT	fieldid,
		SQLPOINTER	value,
		SQLINTEGER	buflen
	)

Function not implemented.

Definition at line 5844 of file sqlite3odbc.c.

SQLRETURN SQL_API SQLSetDescRec	(	SQLHDESC	handle,
		SQLSMALLINT	recno,
		SQLSMALLINT	type,
		SQLSMALLINT	subtype,
		SQLLEN	len,
		SQLSMALLINT	prec,
		SQLSMALLINT	scale,
		SQLPOINTER	data,
		SQLLEN *	strlen,
		SQLLEN *	indicator
	)

Function not implemented.

Definition at line 5891 of file sqlite3odbc.c.

SQLRETURN SQL_API SQLSetEnvAttr	(	SQLHENV	env,
		SQLINTEGER	attr,
		SQLPOINTER	val,
		SQLINTEGER	len
	)

Set information in HENV.

Parameters:

	env	environment handle
	attr	attribute to be retrieved
	val	parameter buffer
	len	length of parameter

Returns:: ODBC error code

Definition at line 8446 of file sqlite3odbc.c.

References ENV_MAGIC, ENV::magic, and ENV::ov3.

SQLRETURN SQL_API SQLSetParam	(	SQLHSTMT	stmt,
		SQLUSMALLINT	par,
		SQLSMALLINT	type,
		SQLSMALLINT	sqltype,
		SQLULEN	coldef,
		SQLSMALLINT	scale,
		SQLPOINTER	val,
		SQLLEN *	nval
	)

Set information on parameter.

Parameters:

	stmt	statement handle
	par	parameter number, starting at 1
	type	type of host variable
	sqltype
	coldef
	scale
	val	pointer to host variable
	nval	output length pointer

Returns:: ODBC error code

Definition at line 5767 of file sqlite3odbc.c.

References drvbindparam(), HSTMT_LOCK, and HSTMT_UNLOCK.

SQLRETURN SQL_API SQLSetPos	(	SQLHSTMT	stmt,
		SQLSETPOSIROW	row,
		SQLUSMALLINT	op,
		SQLUSMALLINT	lock
	)

Set position on result in HSTMT.

Parameters:

	stmt	statement handle
	row	row to be positioned
	op	operation code
	lock	locking type

Returns:: ODBC error code

Definition at line 10423 of file sqlite3odbc.c.

References drvsetpos(), HSTMT_LOCK, and HSTMT_UNLOCK.

SQLRETURN SQL_API SQLSetScrollOptions	(	SQLHSTMT	stmt,
		SQLUSMALLINT	concur,
		SQLLEN	rowkeyset,
		SQLUSMALLINT	rowset
	)

Function not implemented.

Definition at line 10888 of file sqlite3odbc.c.

References drvunimplstmt(), HSTMT_LOCK, and HSTMT_UNLOCK.

SQLRETURN SQL_API SQLSetStmtAttrW	(	SQLHSTMT	stmt,
		SQLINTEGER	attr,
		SQLPOINTER	val,
		SQLINTEGER	buflen
	)

Set option on HSTMT (UNICODE version).

Parameters:

	stmt	statement handle
	attr	attribute to be set
	val	input buffer (attribute value)
	buflen	length of input buffer

Returns:: ODBC error code

Definition at line 9373 of file sqlite3odbc.c.

References drvsetstmtattr(), HSTMT_LOCK, and HSTMT_UNLOCK.

SQLRETURN SQL_API SQLSetStmtOption	(	SQLHSTMT	stmt,
		SQLUSMALLINT	opt,
		SETSTMTOPTION_LAST_ARG_TYPE	param
	)

Set option on HSTMT.

Parameters:

	stmt	statement handle
	opt	option to be set
	param	input buffer (option value)

Returns:: ODBC error code

Definition at line 9564 of file sqlite3odbc.c.

References drvsetstmtoption(), HSTMT_LOCK, and HSTMT_UNLOCK.

SQLRETURN SQL_API SQLSetStmtOptionW	(	SQLHSTMT	stmt,
		SQLUSMALLINT	opt,
		SETSTMTOPTION_LAST_ARG_TYPE	param
	)

Set option on HSTMT (UNICODE version).

Parameters:

	stmt	statement handle
	opt	option to be set
	param	input buffer (option value)

Returns:: ODBC error code

Definition at line 9585 of file sqlite3odbc.c.

References drvsetstmtoption(), HSTMT_LOCK, and HSTMT_UNLOCK.

SQLRETURN SQL_API SQLSpecialColumnsW	(	SQLHSTMT	stmt,
		SQLUSMALLINT	id,
		SQLWCHAR *	cat,
		SQLSMALLINT	catLen,
		SQLWCHAR *	schema,
		SQLSMALLINT	schemaLen,
		SQLWCHAR *	table,
		SQLSMALLINT	tableLen,
		SQLUSMALLINT	scope,
		SQLUSMALLINT	nullable
	)

Retrieve information about indexed columns (UNICODE version).

Parameters:

	stmt	statement handle
	id	type of information, e.g. best row id
	cat	catalog name/pattern or NULL
	catLen	length of catalog name/pattern or SQL_NTS
	schema	schema name/pattern or NULL
	schemaLen	length of schema name/pattern or SQL_NTS
	table	table name/pattern or NULL
	tableLen	length of table name/pattern or SQL_NTS
	scope
	nullable

Returns:: ODBC error code

Definition at line 7215 of file sqlite3odbc.c.

References drvspecialcolumns(), HSTMT_LOCK, HSTMT_UNLOCK, nomem(), uc_free(), and uc_to_utf_c().

SQLRETURN SQL_API SQLStatisticsW	(	SQLHSTMT	stmt,
		SQLWCHAR *	cat,
		SQLSMALLINT	catLen,
		SQLWCHAR *	schema,
		SQLSMALLINT	schemaLen,
		SQLWCHAR *	table,
		SQLSMALLINT	tableLen,
		SQLUSMALLINT	itype,
		SQLUSMALLINT	resv
	)

Return statistic information on table indices (UNICODE version).

Parameters:

	stmt	statement handle
	cat	catalog name/pattern or NULL
	catLen	length of catalog name/pattern or SQL_NTS
	schema	schema name/pattern or NULL
	schemaLen	length of schema name/pattern or SQL_NTS
	table	table name/pattern or NULL
	tableLen	length of table name/pattern or SQL_NTS
	itype	type of index information
	resv	reserved

Returns:: ODBC error code

Definition at line 16204 of file sqlite3odbc.c.

References drvstatistics(), HSTMT_LOCK, HSTMT_UNLOCK, nomem(), uc_free(), and uc_to_utf_c().

SQLRETURN SQL_API SQLTablePrivilegesW	(	SQLHSTMT	stmt,
		SQLWCHAR *	catalog,
		SQLSMALLINT	catalogLen,
		SQLWCHAR *	schema,
		SQLSMALLINT	schemaLen,
		SQLWCHAR *	table,
		SQLSMALLINT	tableLen
	)

Retrieve privileges on tables and/or views (UNICODE version).

Parameters:

	stmt	statement handle
	catalog	catalog name/pattern or NULL
	catalogLen	length of catalog name/pattern or SQL_NTS
	schema	schema name/pattern or NULL
	schemaLen	length of schema name/pattern or SQL_NTS
	table	table name/pattern or NULL
	tableLen	length of table name/pattern or SQL_NTS

Returns:: ODBC error code

Definition at line 6281 of file sqlite3odbc.c.

References drvtableprivileges(), HSTMT_LOCK, HSTMT_UNLOCK, nomem(), uc_free(), and uc_to_utf_c().

SQLRETURN SQL_API SQLTablesW	(	SQLHSTMT	stmt,
		SQLWCHAR *	cat,
		SQLSMALLINT	catLen,
		SQLWCHAR *	schema,
		SQLSMALLINT	schemaLen,
		SQLWCHAR *	table,
		SQLSMALLINT	tableLen,
		SQLWCHAR *	type,
		SQLSMALLINT	typeLen
	)

Retrieve information on tables and/or views.

Parameters:

	stmt	statement handle
	cat	catalog name/pattern or NULL
	catLen	length of catalog name/pattern or SQL_NTS
	schema	schema name/pattern or NULL
	schemaLen	length of schema name/pattern or SQL_NTS
	table	table name/pattern or NULL
	tableLen	length of table name/pattern or SQL_NTS
	type	types of tables string or NULL
	typeLen	length of types of tables string or SQL_NTS

Returns:: ODBC error code

Definition at line 14791 of file sqlite3odbc.c.

References drvtables(), HSTMT_LOCK, HSTMT_UNLOCK, nomem(), uc_free(), and uc_to_utf_c().

SQLRETURN SQL_API SQLTransact	(	SQLHENV	env,
		SQLHDBC	dbc,
		SQLUSMALLINT	type
	)

Commit or rollback transaction.

Parameters:

	env	environment handle or NULL
	dbc	database connection handle or NULL
	type	SQL_COMMIT or SQL_ROLLBACK

Returns:: ODBC error code

Definition at line 8074 of file sqlite3odbc.c.

References drvendtran().

static SQLRETURN starttran ( STMT * s ) [static]

Start transaction when autocommit off.

Parameters:

s

statement pointer

Returns:: ODBC error code

Definition at line 7901 of file sqlite3odbc.c.

References dbc::autocommit, busy_handler(), stmt::dbc, dbtracerc(), dbc::intrans, stmt::ov3, setstat(), dbc::sqlite, and dbc::trans_disable.

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

static int str2date	(	int	jdconv,
		char *	str,
		DATE_STRUCT *	ds
	)			`[static]`

Convert string to ODBC DATE_STRUCT.

Parameters:

	jdconv	when true, allow julian day format
	str	string to be converted
	ds	output DATE_STRUCT

Returns:: 0 on success, -1 on error

Strings of the format 'YYYYMMDD' or 'YYYY-MM-DD' or 'YYYY/MM/DD' or 'MM/DD/YYYY' are converted to a DATE_STRUCT.

If the string looks like a floating point number, SQLite3's julian day format is assumed.

Definition at line 3119 of file sqlite3odbc.c.

References convJD2YMD(), getmdays(), ISDIGIT, and ln_strtod().

Referenced by getrowdata().

static int str2time	(	int	jdconv,
		char *	str,
		TIME_STRUCT *	ts
	)			`[static]`

Convert string to ODBC TIME_STRUCT.

Parameters:

	jdconv	when true, allow julian day format
	str	string to be converted
	ts	output TIME_STRUCT

Returns:: 0 on success, -1 on error

Strings of the format 'HHMMSS' or 'HH:MM:SS' are converted to a TIME_STRUCT.

If the string looks like a floating point number, SQLite3's julian day format is assumed.

Definition at line 3234 of file sqlite3odbc.c.

References convJD2HMS(), ISDIGIT, and ln_strtod().

Referenced by getrowdata().

static int str2timestamp	(	int	jdconv,
		char *	str,
		TIMESTAMP_STRUCT *	tss
	)			`[static]`

Convert string to ODBC TIMESTAMP_STRUCT.

Parameters:

	jdconv	when true, allow julian day format
	str	string to be converted
	tss	output TIMESTAMP_STRUCT

Returns:: 0 on success, -1 on error

Strings of the format 'YYYYMMDDhhmmssff' or 'YYYY-MM-DD hh:mm:ss ff' or 'YYYY/MM/DD hh:mm:ss ff' or 'hh:mm:ss ff YYYY-MM-DD' are converted to a TIMESTAMP_STRUCT. The ISO8601 formats YYYY-MM-DDThh:mm:ss[.f]Z YYYY-MM-DDThh:mm:ss[.f]shh:mm are also supported. In case a time zone field is present, the resulting TIMESTAMP_STRUCT is expressed in UTC.

If the string looks like a floating point number, SQLite3's julian day format is assumed.

Definition at line 3355 of file sqlite3odbc.c.

References convJD2HMS(), convJD2YMD(), getmdays(), ISDIGIT, and ln_strtod().

Referenced by getrowdata().

static char* strdup_ ( const char * str ) [static]

Duplicate string using xmalloc().

Parameters:

str

string to be duplicated

Returns:: pointer to new string or NULL

Definition at line 616 of file sqlite3odbc.c.

References xmalloc.

static int TOLOWER ( int c ) [static]

Definition at line 550 of file sqlite3odbc.c.

Referenced by drvtables(), mapsqltype(), and namematch().

static int typeinfosort	(	const void *	a,
		const void *	b
	)			`[static]`

Helper function to sort type information.

Callback for qsort().

Parameters:

	a	first item to compare
	b	second item to compare

Returns:: ==0, <0, >0 according to data type number

Definition at line 15553 of file sqlite3odbc.c.

Referenced by drvgettypeinfo().

static void uc_free ( void * str ) [static]

Free converted UTF8 or UNICODE string.

Parameters:

str

string to be free'd

Definition at line 1081 of file sqlite3odbc.c.

References xfree.

Referenced by blob_export(), blob_import(), dbopen(), drvconnect(), drvputdata(), getrowdata(), setposbind(), SQLColumnsW(), SQLConnectW(), SQLDescribeColW(), SQLForeignKeysW(), SQLGetConnectAttrW(), SQLGetCursorNameW(), SQLGetDiagFieldW(), SQLGetDiagRecW(), SQLGetInfoW(), SQLPrimaryKeysW(), SQLSetCursorNameW(), SQLSpecialColumnsW(), SQLStatisticsW(), SQLTablePrivilegesW(), and SQLTablesW().

static SQLWCHAR* uc_from_utf	(	unsigned char *	str,
		int	len
	)			`[static]`

Make UNICODE string from UTF8 string.

Parameters:

	str	UTF8 string to be converted
	len	length of UTF8 string

Returns:: alloc'ed UNICODE string to be free'd by uc_free()

Definition at line 954 of file sqlite3odbc.c.

References uc_from_utf_buf(), and xmalloc.

Referenced by getrowdata(), SQLDescribeColW(), SQLGetConnectAttrW(), SQLGetCursorNameW(), SQLGetDiagFieldW(), SQLGetDiagRecW(), and SQLGetInfoW().

static void uc_from_utf_buf	(	unsigned char *	str,
		int	len,
		SQLWCHAR *	uc,
		int	ucLen
	)			`[static]`

Make UNICODE string from UTF8 string into buffer.

Parameters:

	str	UTF8 string to be converted
	len	length in characters of str or -1
	uc	destination area to receive UNICODE string
	ucLen	byte length of destination area

Definition at line 848 of file sqlite3odbc.c.

Referenced by SQLGetDiagRecW(), and uc_from_utf().

static int uc_strlen ( SQLWCHAR * str ) [static]

Return length of UNICODE string.

Parameters:

str

UNICODE string

Returns:: length of string in characters

Definition at line 800 of file sqlite3odbc.c.

Referenced by getrowdata(), setupparam(), SQLDescribeColW(), SQLGetConnectAttrW(), SQLGetCursorNameW(), SQLGetDiagFieldW(), SQLGetDiagRecW(), SQLGetInfoW(), SQLNativeSqlW(), and uc_to_utf().

static SQLWCHAR* uc_strncpy	(	SQLWCHAR *	dest,
		SQLWCHAR *	src,
		int	len
	)			`[static]`

Copy UNICODE string like strncpy().

Parameters:

	dest	destination area
	src	source area
	len	length of source area in characters

Returns:: pointer to destination area

Definition at line 822 of file sqlite3odbc.c.

Referenced by getrowdata(), SQLDescribeColW(), SQLGetConnectAttrW(), SQLGetCursorNameW(), SQLGetDiagFieldW(), SQLGetDiagRecW(), SQLGetInfoW(), and SQLNativeSqlW().

static char* uc_to_utf	(	SQLWCHAR *	str,
		int	len
	)			`[static]`

Make UTF8 string from UNICODE string.

Parameters:

	str	UNICODE string to be converted
	len	length of UNICODE string in bytes

Returns:: alloc'ed UTF8 string to be free'd by uc_free()

Definition at line 980 of file sqlite3odbc.c.

References uc_strlen(), and xmalloc.

Referenced by drvputdata(), setposbind(), setupparam(), and uc_to_utf_c().

static char* uc_to_utf_c	(	SQLWCHAR *	str,
		int	len
	)			`[static]`

Make UTF8 string from UNICODE string.

Parameters:

	str	UNICODE string to be converted
	len	length of UNICODE string in characters

Returns:: alloc'ed UTF8 string to be free'd by uc_free()

Definition at line 1063 of file sqlite3odbc.c.

References uc_to_utf().

Referenced by SQLColumnsW(), SQLConnectW(), SQLForeignKeysW(), SQLPrimaryKeysW(), SQLSetCursorNameW(), SQLSpecialColumnsW(), SQLStatisticsW(), SQLTablePrivilegesW(), and SQLTablesW().

static void unbindcols ( STMT * s ) [static]

Reset bound columns to unbound state.

Parameters:

s

statement pointer

Definition at line 13713 of file sqlite3odbc.c.

References stmt::bindcols, BINDCOL::index, BINDCOL::lenp, BINDCOL::max, stmt::nbindcols, BINDCOL::offs, BINDCOL::type, and BINDCOL::valp.

Referenced by drvfreestmt(), and mkbindcols().

static int unescpat ( char * str ) [static]

Unescape search pattern for e.g.

table name in catalog functions. Replacements in string are done in-place.

Parameters:

str

string

Returns:: number of pattern characters in string or 0

Definition at line 1942 of file sqlite3odbc.c.

Referenced by drvcolumns(), drvprimarykeys(), drvspecialcolumns(), drvstatistics(), drvtableprivileges(), and drvtables().

static char* unquote ( char * str ) [static]

Strip quotes from quoted string in-place.

Parameters:

str

string

Definition at line 1915 of file sqlite3odbc.c.

Referenced by csv_vtab_connect(), drvcolumns(), drvforeignkeys(), and zip_vtab_connect().

Variable Documentation

COL colPrivSpec2[] [static]

Initial value:

 {
    { "SYSTEM", "COLPRIV", "TABLE_QUALIFIER", SCOL_VARCHAR, 50 },
    { "SYSTEM", "COLPRIV", "TABLE_OWNER", SCOL_VARCHAR, 50 },
    { "SYSTEM", "COLPRIV", "TABLE_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "COLPRIV", "COLUMN_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "COLPRIV", "GRANTOR", SCOL_VARCHAR, 50 },
    { "SYSTEM", "COLPRIV", "GRANTEE", SCOL_VARCHAR, 50 },
    { "SYSTEM", "COLPRIV", "PRIVILEGE", SCOL_VARCHAR, 50 }
}

Columns for result set of SQLColumnPrivileges().

Definition at line 6328 of file sqlite3odbc.c.

COL colPrivSpec3[] [static]

Initial value:

 {
    { "SYSTEM", "COLPRIV", "TABLE_CAT", SCOL_VARCHAR, 50 },
    { "SYSTEM", "COLPRIV", "TABLE_SCHEM", SCOL_VARCHAR, 50 },
    { "SYSTEM", "COLPRIV", "TABLE_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "COLPRIV", "COLUMN_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "COLPRIV", "GRANTOR", SCOL_VARCHAR, 50 },
    { "SYSTEM", "COLPRIV", "GRANTEE", SCOL_VARCHAR, 50 },
    { "SYSTEM", "COLPRIV", "PRIVILEGE", SCOL_VARCHAR, 50 }
}

Definition at line 6338 of file sqlite3odbc.c.

COL colSpec2[] [static]

Initial value:

 {
    { "SYSTEM", "COLUMN", "TABLE_QUALIFIER", SCOL_VARCHAR, 50 },
    { "SYSTEM", "COLUMN", "TABLE_OWNER", SCOL_VARCHAR, 50 },
    { "SYSTEM", "COLUMN", "TABLE_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "COLUMN", "COLUMN_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "COLUMN", "DATA_TYPE", SQL_SMALLINT, 50 },
    { "SYSTEM", "COLUMN", "TYPE_NAME", SCOL_VARCHAR, 50 },
    { "SYSTEM", "COLUMN", "PRECISION", SQL_INTEGER, 50 },
    { "SYSTEM", "COLUMN", "LENGTH", SQL_INTEGER, 50 },
    { "SYSTEM", "COLUMN", "SCALE", SQL_SMALLINT, 50 },
    { "SYSTEM", "COLUMN", "RADIX", SQL_SMALLINT, 50 },
    { "SYSTEM", "COLUMN", "NULLABLE", SQL_SMALLINT, 50 },
    { "SYSTEM", "COLUMN", "REMARKS", SCOL_VARCHAR, 50 },
    { "SYSTEM", "COLUMN", "COLUMN_DEF", SCOL_VARCHAR, 50 },
    { "SYSTEM", "COLUMN", "SQL_DATA_TYPE", SQL_SMALLINT, 50 },
    { "SYSTEM", "COLUMN", "SQL_DATETIME_SUB", SQL_SMALLINT, 50 },
    { "SYSTEM", "COLUMN", "CHAR_OCTET_LENGTH", SQL_SMALLINT, 50 },
    { "SYSTEM", "COLUMN", "ORDINAL_POSITION", SQL_SMALLINT, 50 },
    { "SYSTEM", "COLUMN", "IS_NULLABLE", SCOL_VARCHAR, 50 }
}

Columns for result set of SQLColumns().

Definition at line 14845 of file sqlite3odbc.c.

COL colSpec3[] [static]

Initial value:

 {
    { "SYSTEM", "COLUMN", "TABLE_CAT", SCOL_VARCHAR, 50 },
    { "SYSTEM", "COLUMN", "TABLE_SCHEM", SCOL_VARCHAR, 50 },
    { "SYSTEM", "COLUMN", "TABLE_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "COLUMN", "COLUMN_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "COLUMN", "DATA_TYPE", SQL_SMALLINT, 50 },
    { "SYSTEM", "COLUMN", "TYPE_NAME", SCOL_VARCHAR, 50 },
    { "SYSTEM", "COLUMN", "COLUMN_SIZE", SQL_INTEGER, 50 },
    { "SYSTEM", "COLUMN", "BUFFER_LENGTH", SQL_INTEGER, 50 },
    { "SYSTEM", "COLUMN", "DECIMAL_DIGITS", SQL_SMALLINT, 50 },
    { "SYSTEM", "COLUMN", "NUM_PREC_RADIX", SQL_SMALLINT, 50 },
    { "SYSTEM", "COLUMN", "NULLABLE", SQL_SMALLINT, 50 },
    { "SYSTEM", "COLUMN", "REMARKS", SCOL_VARCHAR, 50 },
    { "SYSTEM", "COLUMN", "COLUMN_DEF", SCOL_VARCHAR, 50 },
    { "SYSTEM", "COLUMN", "SQL_DATA_TYPE", SQL_SMALLINT, 50 },
    { "SYSTEM", "COLUMN", "SQL_DATETIME_SUB", SQL_SMALLINT, 50 },
    { "SYSTEM", "COLUMN", "CHAR_OCTET_LENGTH", SQL_SMALLINT, 50 },
    { "SYSTEM", "COLUMN", "ORDINAL_POSITION", SQL_SMALLINT, 50 },
    { "SYSTEM", "COLUMN", "IS_NULLABLE", SCOL_VARCHAR, 50 }
}

Definition at line 14866 of file sqlite3odbc.c.

const char digit_chars[] = "0123456789" [static]

Definition at line 566 of file sqlite3odbc.c.

COL fkeySpec2[] [static]

Initial value:

 {
    { "SYSTEM", "FOREIGNKEY", "PKTABLE_QUALIFIER", SCOL_VARCHAR, 50 },
    { "SYSTEM", "FOREIGNKEY", "PKTABLE_OWNER", SCOL_VARCHAR, 50 },
    { "SYSTEM", "FOREIGNKEY", "PKTABLE_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "FOREIGNKEY", "PKCOLUMN_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "FOREIGNKEY", "FKTABLE_QUALIFIER", SCOL_VARCHAR, 50 },
    { "SYSTEM", "FOREIGNKEY", "FKTABLE_OWNER", SCOL_VARCHAR, 50 },
    { "SYSTEM", "FOREIGNKEY", "FKTABLE_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "FOREIGNKEY", "FKCOLUMN_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "FOREIGNKEY", "KEY_SEQ", SQL_SMALLINT, 5 },
    { "SYSTEM", "FOREIGNKEY", "UPDATE_RULE", SQL_SMALLINT, 5 },
    { "SYSTEM", "FOREIGNKEY", "DELETE_RULE", SQL_SMALLINT, 5 },
    { "SYSTEM", "FOREIGNKEY", "FK_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "FOREIGNKEY", "PK_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "FOREIGNKEY", "DEFERRABILITY", SQL_SMALLINT, 5 }
}

Columns for result set of SQLForeignKeys().

Definition at line 7262 of file sqlite3odbc.c.

COL fkeySpec3[] [static]

Initial value:

 {
    { "SYSTEM", "FOREIGNKEY", "PKTABLE_CAT", SCOL_VARCHAR, 50 },
    { "SYSTEM", "FOREIGNKEY", "PKTABLE_SCHEM", SCOL_VARCHAR, 50 },
    { "SYSTEM", "FOREIGNKEY", "PKTABLE_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "FOREIGNKEY", "PKCOLUMN_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "FOREIGNKEY", "FKTABLE_CAT", SCOL_VARCHAR, 50 },
    { "SYSTEM", "FOREIGNKEY", "FKTABLE_SCHEM", SCOL_VARCHAR, 50 },
    { "SYSTEM", "FOREIGNKEY", "FKTABLE_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "FOREIGNKEY", "FKCOLUMN_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "FOREIGNKEY", "KEY_SEQ", SQL_SMALLINT, 5 },
    { "SYSTEM", "FOREIGNKEY", "UPDATE_RULE", SQL_SMALLINT, 5 },
    { "SYSTEM", "FOREIGNKEY", "DELETE_RULE", SQL_SMALLINT, 5 },
    { "SYSTEM", "FOREIGNKEY", "FK_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "FOREIGNKEY", "PK_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "FOREIGNKEY", "DEFERRABILITY", SQL_SMALLINT, 5 }
}

Definition at line 7279 of file sqlite3odbc.c.

const char lower_chars[] = "abcdefghijklmnopqrstuvwxyz" [static]

Definition at line 547 of file sqlite3odbc.c.

COL pkeySpec2[] [static]

Initial value:

 {
    { "SYSTEM", "PRIMARYKEY", "TABLE_QUALIFIER", SCOL_VARCHAR, 50 },
    { "SYSTEM", "PRIMARYKEY", "TABLE_OWNER", SCOL_VARCHAR, 50 },
    { "SYSTEM", "PRIMARYKEY", "TABLE_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "PRIMARYKEY", "COLUMN_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "PRIMARYKEY", "KEY_SEQ", SQL_SMALLINT, 50 },
    { "SYSTEM", "PRIMARYKEY", "PK_NAME", SCOL_VARCHAR, 50 }
}

Columns for result set of SQLPrimaryKeys().

Definition at line 6418 of file sqlite3odbc.c.

COL pkeySpec3[] [static]

Initial value:

 {
    { "SYSTEM", "PRIMARYKEY", "TABLE_CAT", SCOL_VARCHAR, 50 },
    { "SYSTEM", "PRIMARYKEY", "TABLE_SCHEM", SCOL_VARCHAR, 50 },
    { "SYSTEM", "PRIMARYKEY", "TABLE_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "PRIMARYKEY", "COLUMN_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "PRIMARYKEY", "KEY_SEQ", SQL_SMALLINT, 50 },
    { "SYSTEM", "PRIMARYKEY", "PK_NAME", SCOL_VARCHAR, 50 }
}

Definition at line 6427 of file sqlite3odbc.c.

COL procColSpec2[] [static]

Initial value:

 {
    { "SYSTEM", "PROCCOL", "PROCEDURE_QUALIFIER", SCOL_VARCHAR, 50 },
    { "SYSTEM", "PROCCOL", "PROCEDURE_OWNER", SCOL_VARCHAR, 50 },
    { "SYSTEM", "PROCCOL", "PROCEDURE_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "PROCCOL", "COLUMN_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "PROCCOL", "COLUMN_TYPE", SQL_SMALLINT, 5 },
    { "SYSTEM", "PROCCOL", "DATA_TYPE", SQL_SMALLINT, 5 },
    { "SYSTEM", "PROCCOL", "TYPE_NAME", SCOL_VARCHAR, 50 },
    { "SYSTEM", "PROCCOL", "PRECISION", SQL_INTEGER, 10 },
    { "SYSTEM", "PROCCOL", "LENGTH", SQL_INTEGER, 10 },
    { "SYSTEM", "PROCCOL", "SCALE", SQL_SMALLINT, 5 },
    { "SYSTEM", "PROCCOL", "RADIX", SQL_SMALLINT, 5 },
    { "SYSTEM", "PROCCOL", "NULLABLE", SQL_SMALLINT, 5 },
    { "SYSTEM", "PROCCOL", "REMARKS", SCOL_VARCHAR, 50 },
    { "SYSTEM", "PROCCOL", "COLUMN_DEF", SCOL_VARCHAR, 50 },
    { "SYSTEM", "PROCCOL", "SQL_DATA_TYPE", SQL_SMALLINT, 5 },
    { "SYSTEM", "PROCCOL", "SQL_DATETIME_SUB", SQL_SMALLINT, 5 },
    { "SYSTEM", "PROCCOL", "CHAR_OCTET_LENGTH", SQL_SMALLINT, 5 },
    { "SYSTEM", "PROCCOL", "ORDINAL_POSITION", SQL_SMALLINT, 5 },
    { "SYSTEM", "PROCCOL", "IS_NULLABLE", SCOL_VARCHAR, 50 }
}

Columns for result set of SQLProcedureColumns().

Definition at line 8268 of file sqlite3odbc.c.

COL procColSpec3[] [static]

Initial value:

 {
    { "SYSTEM", "PROCCOL", "PROCEDURE_CAT", SCOL_VARCHAR, 50 },
    { "SYSTEM", "PROCCOL", "PROCEDURE_SCHEM", SCOL_VARCHAR, 50 },
    { "SYSTEM", "PROCCOL", "PROCEDURE_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "PROCCOL", "COLUMN_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "PROCCOL", "COLUMN_TYPE", SQL_SMALLINT, 5 },
    { "SYSTEM", "PROCCOL", "DATA_TYPE", SQL_SMALLINT, 5 },
    { "SYSTEM", "PROCCOL", "TYPE_NAME", SCOL_VARCHAR, 50 },
    { "SYSTEM", "PROCCOL", "COLUMN_SIZE", SQL_INTEGER, 10 },
    { "SYSTEM", "PROCCOL", "BUFFER_LENGTH", SQL_INTEGER, 10 },
    { "SYSTEM", "PROCCOL", "DECIMAL_DIGITS", SQL_SMALLINT, 5 },
    { "SYSTEM", "PROCCOL", "NUM_PREC_RADIX", SQL_SMALLINT, 5 },
    { "SYSTEM", "PROCCOL", "NULLABLE", SQL_SMALLINT, 5 },
    { "SYSTEM", "PROCCOL", "REMARKS", SCOL_VARCHAR, 50 },
    { "SYSTEM", "PROCCOL", "COLUMN_DEF", SCOL_VARCHAR, 50 },
    { "SYSTEM", "PROCCOL", "SQL_DATA_TYPE", SQL_SMALLINT, 5 },
    { "SYSTEM", "PROCCOL", "SQL_DATETIME_SUB", SQL_SMALLINT, 5 },
    { "SYSTEM", "PROCCOL", "CHAR_OCTET_LENGTH", SQL_SMALLINT, 5 },
    { "SYSTEM", "PROCCOL", "ORDINAL_POSITION", SQL_SMALLINT, 5 },
    { "SYSTEM", "PROCCOL", "IS_NULLABLE", SCOL_VARCHAR, 50 }
}

Definition at line 8290 of file sqlite3odbc.c.

COL procSpec2[] [static]

Initial value:

 {
    { "SYSTEM", "PROCEDURE", "PROCEDURE_QUALIFIER", SCOL_VARCHAR, 50 },
    { "SYSTEM", "PROCEDURE", "PROCEDURE_OWNER", SCOL_VARCHAR, 50 },
    { "SYSTEM", "PROCEDURE", "PROCEDURE_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "PROCEDURE", "NUM_INPUT_PARAMS", SQL_SMALLINT, 5 },
    { "SYSTEM", "PROCEDURE", "NUM_OUTPUT_PARAMS", SQL_SMALLINT, 5 },
    { "SYSTEM", "PROCEDURE", "NUM_RESULT_SETS", SQL_SMALLINT, 5 },
    { "SYSTEM", "PROCEDURE", "REMARKS", SCOL_VARCHAR, 255 },
    { "SYSTEM", "PROCEDURE", "PROCEDURE_TYPE", SQL_SMALLINT, 5 }
}

Columns for result set of SQLProcedures().

Definition at line 8184 of file sqlite3odbc.c.

COL procSpec3[] [static]

Initial value:

 {
    { "SYSTEM", "PROCEDURE", "PROCEDURE_CAT", SCOL_VARCHAR, 50 },
    { "SYSTEM", "PROCEDURE", "PROCEDURE_SCHEM", SCOL_VARCHAR, 50 },
    { "SYSTEM", "PROCEDURE", "PROCEDURE_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "PROCEDURE", "NUM_INPUT_PARAMS", SQL_SMALLINT, 5 },
    { "SYSTEM", "PROCEDURE", "NUM_OUTPUT_PARAMS", SQL_SMALLINT, 5 },
    { "SYSTEM", "PROCEDURE", "NUM_RESULT_SETS", SQL_SMALLINT, 5 },
    { "SYSTEM", "PROCEDURE", "REMARKS", SCOL_VARCHAR, 255 },
    { "SYSTEM", "PROCEDURE", "PROCEDURE_TYPE", SQL_SMALLINT, 5 }
}

Definition at line 8195 of file sqlite3odbc.c.

COL scolSpec2[] [static]

Initial value:

 {
    { "SYSTEM", "COLUMN", "SCOPE", SQL_SMALLINT, 1 },
    { "SYSTEM", "COLUMN", "COLUMN_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "COLUMN", "DATA_TYPE", SQL_SMALLINT, 50 },
    { "SYSTEM", "COLUMN", "TYPE_NAME", SCOL_VARCHAR, 50 },
    { "SYSTEM", "COLUMN", "PRECISION", SQL_INTEGER, 50 },
    { "SYSTEM", "COLUMN", "LENGTH", SQL_INTEGER, 50 },
    { "SYSTEM", "COLUMN", "DECIMAL_DIGITS", SQL_INTEGER, 50 },
    { "SYSTEM", "COLUMN", "PSEUDO_COLUMN", SQL_SMALLINT, 1 },
    { "SYSTEM", "COLUMN", "NULLABLE", SQL_SMALLINT, 1 }
}

Columns for result set of SQLSpecialColumns().

Definition at line 6822 of file sqlite3odbc.c.

COL scolSpec3[] [static]

Initial value:

 {
    { "SYSTEM", "COLUMN", "SCOPE", SQL_SMALLINT, 1 },
    { "SYSTEM", "COLUMN", "COLUMN_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "COLUMN", "DATA_TYPE", SQL_SMALLINT, 50 },
    { "SYSTEM", "COLUMN", "TYPE_NAME", SCOL_VARCHAR, 50 },
    { "SYSTEM", "COLUMN", "COLUMN_SIZE", SQL_INTEGER, 50 },
    { "SYSTEM", "COLUMN", "BUFFER_LENGTH", SQL_INTEGER, 50 },
    { "SYSTEM", "COLUMN", "DECIMAL_DIGITS", SQL_INTEGER, 50 },
    { "SYSTEM", "COLUMN", "PSEUDO_COLUMN", SQL_SMALLINT, 1 },
    { "SYSTEM", "COLUMN", "NULLABLE", SQL_SMALLINT, 1 }
}

Definition at line 6834 of file sqlite3odbc.c.

const char space_chars[] = " \f\n\r\t\v" [static]

Definition at line 575 of file sqlite3odbc.c.

COL statSpec2[] [static]

Initial value:

 {
    { "SYSTEM", "STATISTICS", "TABLE_QUALIFIER", SCOL_VARCHAR, 50 },
    { "SYSTEM", "STATISTICS", "TABLE_OWNER", SCOL_VARCHAR, 50 },
    { "SYSTEM", "STATISTICS", "TABLE_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "STATISTICS", "NON_UNIQUE", SQL_SMALLINT, 50 },
    { "SYSTEM", "STATISTICS", "INDEX_QUALIFIER", SCOL_VARCHAR, 255 },
    { "SYSTEM", "STATISTICS", "INDEX_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "STATISTICS", "TYPE", SQL_SMALLINT, 50 },
    { "SYSTEM", "STATISTICS", "SEQ_IN_INDEX", SQL_SMALLINT, 50 },
    { "SYSTEM", "STATISTICS", "COLUMN_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "STATISTICS", "COLLATION", SCOL_CHAR, 1 },
    { "SYSTEM", "STATISTICS", "CARDINALITY", SQL_INTEGER, 50 },
    { "SYSTEM", "STATISTICS", "PAGES", SQL_INTEGER, 50 },
    { "SYSTEM", "STATISTICS", "FILTER_CONDITION", SCOL_VARCHAR, 255 }
}

Columns for result set of SQLStatistics().

Definition at line 15806 of file sqlite3odbc.c.

COL statSpec3[] [static]

Initial value:

 {
    { "SYSTEM", "STATISTICS", "TABLE_CAT", SCOL_VARCHAR, 50 },
    { "SYSTEM", "STATISTICS", "TABLE_SCHEM", SCOL_VARCHAR, 50 },
    { "SYSTEM", "STATISTICS", "TABLE_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "STATISTICS", "NON_UNIQUE", SQL_SMALLINT, 50 },
    { "SYSTEM", "STATISTICS", "INDEX_QUALIFIER", SCOL_VARCHAR, 255 },
    { "SYSTEM", "STATISTICS", "INDEX_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "STATISTICS", "TYPE", SQL_SMALLINT, 50 },
    { "SYSTEM", "STATISTICS", "ORDINAL_POSITION", SQL_SMALLINT, 50 },
    { "SYSTEM", "STATISTICS", "COLUMN_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "STATISTICS", "ASC_OR_DESC", SCOL_CHAR, 1 },
    { "SYSTEM", "STATISTICS", "CARDINALITY", SQL_INTEGER, 50 },
    { "SYSTEM", "STATISTICS", "PAGES", SQL_INTEGER, 50 },
    { "SYSTEM", "STATISTICS", "FILTER_CONDITION", SCOL_VARCHAR, 255 }
}

Definition at line 15822 of file sqlite3odbc.c.

COL tablePrivSpec2[] [static]

Initial value:

 {
    { "SYSTEM", "TABLEPRIV", "TABLE_QUALIFIER", SCOL_VARCHAR, 50 },
    { "SYSTEM", "TABLEPRIV", "TABLE_OWNER", SCOL_VARCHAR, 50 },
    { "SYSTEM", "TABLEPRIV", "TABLE_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "TABLEPRIV", "GRANTOR", SCOL_VARCHAR, 50 },
    { "SYSTEM", "TABLEPRIV", "GRANTEE", SCOL_VARCHAR, 50 },
    { "SYSTEM", "TABLEPRIV", "PRIVILEGE", SCOL_VARCHAR, 50 },
    { "SYSTEM", "TABLEPRIV", "IS_GRANTABLE", SCOL_VARCHAR, 50 }
}

Columns for result set of SQLTablePrivileges().

Definition at line 5954 of file sqlite3odbc.c.

COL tablePrivSpec3[] [static]

Initial value:

 {
    { "SYSTEM", "TABLEPRIV", "TABLE_CAT", SCOL_VARCHAR, 50 },
    { "SYSTEM", "TABLEPRIV", "TABLE_SCHEM", SCOL_VARCHAR, 50 },
    { "SYSTEM", "TABLEPRIV", "TABLE_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "TABLEPRIV", "GRANTOR", SCOL_VARCHAR, 50 },
    { "SYSTEM", "TABLEPRIV", "GRANTEE", SCOL_VARCHAR, 50 },
    { "SYSTEM", "TABLEPRIV", "PRIVILEGE", SCOL_VARCHAR, 50 },
    { "SYSTEM", "TABLEPRIV", "IS_GRANTABLE", SCOL_VARCHAR, 50 }
}

Definition at line 5964 of file sqlite3odbc.c.

COL tableSpec2[] [static]

Initial value:

 {
    { "SYSTEM", "COLUMN", "TABLE_QUALIFIER", SCOL_VARCHAR, 50 },
    { "SYSTEM", "COLUMN", "TABLE_OWNER", SCOL_VARCHAR, 50 },
    { "SYSTEM", "COLUMN", "TABLE_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "COLUMN", "TABLE_TYPE", SCOL_VARCHAR, 50 },
    { "SYSTEM", "COLUMN", "REMARKS", SCOL_VARCHAR, 50 }
}

Columns for result set of SQLTables().

Definition at line 14492 of file sqlite3odbc.c.

COL tableSpec3[] [static]

Initial value:

 {
    { "SYSTEM", "COLUMN", "TABLE_CAT", SCOL_VARCHAR, 50 },
    { "SYSTEM", "COLUMN", "TABLE_SCHEM", SCOL_VARCHAR, 50 },
    { "SYSTEM", "COLUMN", "TABLE_NAME", SCOL_VARCHAR, 255 },
    { "SYSTEM", "COLUMN", "TABLE_TYPE", SCOL_VARCHAR, 50 },
    { "SYSTEM", "COLUMN", "REMARKS", SCOL_VARCHAR, 50 }
}

Definition at line 14500 of file sqlite3odbc.c.

COL typeSpec2[] [static]

Initial value:

 {
    { "SYSTEM", "TYPE", "TYPE_NAME", SCOL_VARCHAR, 50 },
    { "SYSTEM", "TYPE", "DATA_TYPE", SQL_SMALLINT, 2 },
    { "SYSTEM", "TYPE", "PRECISION", SQL_INTEGER, 9 },
    { "SYSTEM", "TYPE", "LITERAL_PREFIX", SCOL_VARCHAR, 50 },
    { "SYSTEM", "TYPE", "LITERAL_SUFFIX", SCOL_VARCHAR, 50 },
    { "SYSTEM", "TYPE", "CREATE_PARAMS", SCOL_VARCHAR, 50 },
    { "SYSTEM", "TYPE", "NULLABLE", SQL_SMALLINT, 2 },
    { "SYSTEM", "TYPE", "CASE_SENSITIVE", SQL_SMALLINT, 2 },
    { "SYSTEM", "TYPE", "SEARCHABLE", SQL_SMALLINT, 2 },
    { "SYSTEM", "TYPE", "UNSIGNED_ATTRIBUTE", SQL_SMALLINT, 2 },
    { "SYSTEM", "TYPE", "MONEY", SQL_SMALLINT, 2 },
    { "SYSTEM", "TYPE", "AUTO_INCREMENT", SQL_SMALLINT, 2 },
    { "SYSTEM", "TYPE", "LOCAL_TYPE_NAME", SCOL_VARCHAR, 50 },
    { "SYSTEM", "TYPE", "MINIMUM_SCALE", SQL_SMALLINT, 2 },
    { "SYSTEM", "TYPE", "MAXIMUM_SCALE", SQL_SMALLINT, 2 }
}

Columns for result set of SQLGetTypeInfo().

Definition at line 15364 of file sqlite3odbc.c.

COL typeSpec3[] [static]

Initial value:

 {
    { "SYSTEM", "TYPE", "TYPE_NAME", SCOL_VARCHAR, 50 },
    { "SYSTEM", "TYPE", "DATA_TYPE", SQL_SMALLINT, 2 },
    { "SYSTEM", "TYPE", "COLUMN_SIZE", SQL_INTEGER, 9 },
    { "SYSTEM", "TYPE", "LITERAL_PREFIX", SCOL_VARCHAR, 50 },
    { "SYSTEM", "TYPE", "LITERAL_SUFFIX", SCOL_VARCHAR, 50 },
    { "SYSTEM", "TYPE", "CREATE_PARAMS", SCOL_VARCHAR, 50 },
    { "SYSTEM", "TYPE", "NULLABLE", SQL_SMALLINT, 2 },
    { "SYSTEM", "TYPE", "CASE_SENSITIVE", SQL_SMALLINT, 2 },
    { "SYSTEM", "TYPE", "SEARCHABLE", SQL_SMALLINT, 2 },
    { "SYSTEM", "TYPE", "UNSIGNED_ATTRIBUTE", SQL_SMALLINT, 2 },
    { "SYSTEM", "TYPE", "FIXED_PREC_SCALE", SQL_SMALLINT, 2 },
    { "SYSTEM", "TYPE", "AUTO_UNIQUE_VALUE", SQL_SMALLINT, 2 },
    { "SYSTEM", "TYPE", "LOCAL_TYPE_NAME", SCOL_VARCHAR, 50 },
    { "SYSTEM", "TYPE", "MINIMUM_SCALE", SQL_SMALLINT, 2 },
    { "SYSTEM", "TYPE", "MAXIMUM_SCALE", SQL_SMALLINT, 2 },
    { "SYSTEM", "TYPE", "SQL_DATA_TYPE", SQL_SMALLINT, 2 },
    { "SYSTEM", "TYPE", "SQL_DATETIME_SUB", SQL_SMALLINT, 2 },
    { "SYSTEM", "TYPE", "NUM_PREC_RADIX", SQL_INTEGER, 4 },
    { "SYSTEM", "TYPE", "INTERVAL_PRECISION", SQL_SMALLINT, 2 }
}

Definition at line 15382 of file sqlite3odbc.c.

const char upper_chars[] = "ABCDEFGHIJKLMNOPQRSTUVWXYZ" [static]

Definition at line 546 of file sqlite3odbc.c.

const char* xdigits = "0123456789ABCDEFabcdef" [static]

Definition at line 279 of file sqlite3odbc.c.

Referenced by drvgettable_row(), getrowdata(), quote_csv_func(), quote_func(), quote_xml_func(), quote_xml_str(), and s3stmt_step().