source: trunk/ab5.0/ablib/src/api_sql.sbp@ 560

' api_sql.sbp

/* API declaration data types */
TypeDef SQLCHAR        = Byte
TypeDef SQLSCHAR       = Char
TypeDef SQLDATE        = Byte
TypeDef SQLDECIMAL     = Byte
TypeDef SQLDOUBLE      = Double
TypeDef SQLFLOAT       = Double
TypeDef SQLINTEGER     = Long
TypeDef SQLUINTEGER    = DWord
TypeDef SQLSMALLINT    = Integer
TypeDef SQLUSMALLINT   = Word
#ifdef _WIN64
TypeDef SQLLEN         = Int64
TypeDef SQLULEN        = QWord
TypeDef SQLSETPOSIROW  = QWord
#else 
TypeDef SQLLEN         = SQLINTEGER
TypeDef SQLULEN        = SQLUINTEGER
TypeDef SQLSETPOSIROW  = SQLUSMALLINT
#endif

'For Backward compatibility
TypeDef SQLROWCOUNT    = SQLULEN
TypeDef SQLROWSETSIZE  = SQLULEN
TypeDef SQLTRANSID     = SQLULEN
TypeDef SQLROWOFFSET   = SQLLEN

TypeDef SQLNUMERIC = Byte
TypeDef SQLPOINTER = VoidPtr
TypeDef SQLREAL = Single
TypeDef SQLSMALLINT = Integer
TypeDef SQLUSMALLINT = Word
TypeDef SQLTIME = Byte
TypeDef SQLTIMESTAMP = Byte
TypeDef SQLVARCHAR = Byte

/* function return type */
TypeDef SQLRETURN = SQLSMALLINT

/* generic data structures */
TypeDef SQLHANDLE = VoidPtr
TypeDef SQLHENV = SQLHANDLE
TypeDef SQLHDBC = SQLHANDLE
TypeDef SQLHSTMT = SQLHANDLE
TypeDef SQLHDESC = SQLHANDLE



/* transfer types for DATE, TIME, TIMESTAMP */
Type DATE_STRUCT
    year As SQLSMALLINT
    month As SQLUSMALLINT
    day As SQLUSMALLINT
End Type
TypeDef SQL_DATE_STRUCT = DATE_STRUCT


Type TIME_STRUCT
    hour As SQLUSMALLINT
    minute As SQLUSMALLINT
    second As SQLUSMALLINT
End Type
TypeDef SQL_TIME_STRUCT = TIME_STRUCT


Type TIMESTAMP_STRUCT
    year As SQLSMALLINT
    month As SQLUSMALLINT
    day As SQLUSMALLINT
    hour As SQLUSMALLINT
    minute As SQLUSMALLINT
    second As SQLUSMALLINT
    fraction As SQLUSMALLINT
End Type
TypeDef SQL_TIMESTAMP_STRUCT = TIMESTAMP_STRUCT


Const Enum SQLINTERVAL
    SQL_IS_YEAR                     = 1
    SQL_IS_MONTH                    = 2
    SQL_IS_DAY                      = 3
    SQL_IS_HOUR                     = 4
    SQL_IS_MINUTE                   = 5
    SQL_IS_SECOND                   = 6
    SQL_IS_YEAR_TO_MONTH            = 7
    SQL_IS_DAY_TO_HOUR              = 8
    SQL_IS_DAY_TO_MINUTE            = 9
    SQL_IS_DAY_TO_SECOND            = 10
    SQL_IS_HOUR_TO_MINUTE           = 11
    SQL_IS_HOUR_TO_SECOND           = 12
    SQL_IS_MINUTE_TO_SECOND         = 13
End Enum


Type SQL_YEAR_MONTH_STRUCT
    year As SQLUINTEGER
    month As SQLUINTEGER
End Type

Type SQL_DAY_SECOND_STRUCT
    day As SQLUINTEGER
    hour As SQLUINTEGER
    minute As SQLUINTEGER
    second As SQLUINTEGER
    fraction As SQLUINTEGER
End Type

Type SQL_INTERVAL_STRUCT
    interval_type As SQLINTERVAL
    interval_sign As SQLSMALLINT

    'Union intval
        year_month As SQL_YEAR_MONTH_STRUCT
        'day_second As SQL_DAY_SECOND_STRUCT
    'End Union
End Type


Const SQL_MAX_NUMERIC_LEN = 16
Type SQL_NUMERIC_STRUCT
    precision As SQLCHAR
    scale As SQLSCHAR
    sign As SQLCHAR
    val[ELM(SQL_MAX_NUMERIC_LEN)] As SQLCHAR
End Type


TypeDef SQLGUID = GUID

TypeDef BOOKMARK = SQLULEN

typedef SQLWCHAR = Word
TypeDef SQLTCHAR = SQLCHAR




/* special length/indicator values */
Const SQL_NULL_DATA             = (-1)
Const SQL_DATA_AT_EXEC          = (-2)


/* return values from functions */
Const SQL_SUCCESS                = 0
Const SQL_SUCCESS_WITH_INFO      = 1
Const SQL_NO_DATA              = 100
Const SQL_ERROR                 = (-1)
Const SQL_INVALID_HANDLE        = (-2)

Const SQL_STILL_EXECUTING        = 2
Const SQL_NEED_DATA             = 99

/* test for SQL_SUCCESS or SQL_SUCCESS_WITH_INFO */
Const SQL_SUCCEEDED(rc) = (((rc) and (not 1))=0)

/* flags for null-terminated string */
Const SQL_NTS                   = (-3)
Const SQL_NTSL                  = (-3)

/* maximum message length */
Const SQL_MAX_MESSAGE_LENGTH   = 512

/* date/time length constants */
Const SQL_DATE_LEN           = 10
Const SQL_TIME_LEN           =  8  /* add P+1 if precision is nonzero */
Const SQL_TIMESTAMP_LEN      = 19  /* add P+1 if precision is nonzero */

/* handle type identifiers */
Const SQL_HANDLE_ENV             = 1
Const SQL_HANDLE_DBC             = 2
Const SQL_HANDLE_STMT            = 3
Const SQL_HANDLE_DESC            = 4

/* environment attribute */
Const SQL_ATTR_OUTPUT_NTS    = 10001

/* connection attributes */
Const SQL_ATTR_AUTO_IPD      = 10001
Const SQL_ATTR_METADATA_ID   = 10014

/* statement attributes */
Const SQL_ATTR_APP_ROW_DESC       = 10010
Const SQL_ATTR_APP_PARAM_DESC     = 10011
Const SQL_ATTR_IMP_ROW_DESC       = 10012
Const SQL_ATTR_IMP_PARAM_DESC     = 10013
Const SQL_ATTR_CURSOR_SCROLLABLE  = (-1)
Const SQL_ATTR_CURSOR_SENSITIVITY = (-2)

/* SQL_ATTR_CURSOR_SCROLLABLE values */
Const SQL_NONSCROLLABLE      = 0
Const SQL_SCROLLABLE             = 1

/* identifiers of fields in the SQL descriptor */
Const SQL_DESC_COUNT                  = 1001
Const SQL_DESC_TYPE                   = 1002
Const SQL_DESC_LENGTH                 = 1003
Const SQL_DESC_OCTET_LENGTH_PTR       = 1004
Const SQL_DESC_PRECISION              = 1005
Const SQL_DESC_SCALE                  = 1006
Const SQL_DESC_DATETIME_INTERVAL_CODE = 1007
Const SQL_DESC_NULLABLE               = 1008
Const SQL_DESC_INDICATOR_PTR          = 1009
Const SQL_DESC_DATA_PTR               = 1010
Const SQL_DESC_NAME                   = 1011
Const SQL_DESC_UNNAMED                = 1012
Const SQL_DESC_OCTET_LENGTH           = 1013
Const SQL_DESC_ALLOC_TYPE             = 1099

/* identifiers of fields in the diagnostics area */
Const SQL_DIAG_RETURNCODE        = 1
Const SQL_DIAG_NUMBER            = 2
Const SQL_DIAG_ROW_COUNT         = 3
Const SQL_DIAG_SQLSTATE          = 4
Const SQL_DIAG_NATIVE            = 5
Const SQL_DIAG_MESSAGE_TEXT      = 6
Const SQL_DIAG_DYNAMIC_FUNCTION  = 7
Const SQL_DIAG_CLASS_ORIGIN      = 8
Const SQL_DIAG_SUBCLASS_ORIGIN   = 9
Const SQL_DIAG_CONNECTION_NAME  = 10
Const SQL_DIAG_SERVER_NAME      = 11
Const SQL_DIAG_DYNAMIC_FUNCTION_CODE = 12

/* dynamic function codes */
Const SQL_DIAG_ALTER_DOMAIN      = 3
Const SQL_DIAG_ALTER_TABLE            = 4
Const SQL_DIAG_CALL              = 7
Const SQL_DIAG_CREATE_ASSERTION  = 6
Const SQL_DIAG_CREATE_CHARACTER_SET = 8
Const SQL_DIAG_CREATE_COLLATION  = 10
Const SQL_DIAG_CREATE_DOMAIN         = 23
Const SQL_DIAG_CREATE_INDEX          = (-1)
Const SQL_DIAG_CREATE_SCHEMA         = 64
Const SQL_DIAG_CREATE_TABLE          = 77
Const SQL_DIAG_CREATE_TRANSLATION    = 79
Const SQL_DIAG_CREATE_VIEW           = 84
Const SQL_DIAG_DELETE_WHERE          = 19
Const SQL_DIAG_DROP_ASSERTION        = 24
Const SQL_DIAG_DROP_CHARACTER_SET    = 25
Const SQL_DIAG_DROP_COLLATION        = 26
Const SQL_DIAG_DROP_DOMAIN       = 27
Const SQL_DIAG_DROP_INDEX            = (-2)
Const SQL_DIAG_DROP_SCHEMA       = 31
Const SQL_DIAG_DROP_TABLE            = 32
Const SQL_DIAG_DROP_TRANSLATION      = 33
Const SQL_DIAG_DROP_VIEW             = 36
Const SQL_DIAG_DYNAMIC_DELETE_CURSOR = 38
Const SQL_DIAG_DYNAMIC_UPDATE_CURSOR = 81
Const SQL_DIAG_GRANT                 = 48
Const SQL_DIAG_INSERT                = 50
Const SQL_DIAG_REVOKE                = 59
Const SQL_DIAG_SELECT_CURSOR         = 85
Const SQL_DIAG_UNKNOWN_STATEMENT      = 0
Const SQL_DIAG_UPDATE_WHERE          = 82

/* SQL data type codes */
Const SQL_UNKNOWN_TYPE = 0
Const SQL_CHAR            = 1
Const SQL_NUMERIC         = 2
Const SQL_DECIMAL         = 3
Const SQL_INTEGER         = 4
Const SQL_SMALLINT        = 5
Const SQL_FLOAT           = 6
Const SQL_REAL            = 7
Const SQL_DOUBLE          = 8
Const SQL_DATETIME        = 9
Const SQL_VARCHAR        = 12

/* One-parameter shortcuts for date/time data types */
Const SQL_TYPE_DATE      = 91
Const SQL_TYPE_TIME      = 92
Const SQL_TYPE_TIMESTAMP = 93

/* Statement attribute values for cursor sensitivity */
Const SQL_UNSPECIFIED     = 0
Const SQL_INSENSITIVE     = 1
Const SQL_SENSITIVE       = 2

/* GetTypeInfo() request for all data types */
Const SQL_ALL_TYPES       = 0

/* Default conversion code for SQLBindCol(), SQLBindParam() and SQLGetData() */
Const SQL_DEFAULT        = 99

/* SQLSQLLEN GetData() code indicating that the application row descriptor
 * specifies the data type
 */
Const SQL_ARD_TYPE      = (-99)

/* SQL date/time type subcodes */
Const SQL_CODE_DATE       = 1
Const SQL_CODE_TIME       = 2
Const SQL_CODE_TIMESTAMP  = 3

/* CLI option values */
Const SQL_FALSE           = 0
Const SQL_TRUE            = 1

/* values of NULLABLE field in descriptor */
Const SQL_NO_NULLS        = 0
Const SQL_NULLABLE        = 1

/* Value returned by SQLGetTypeInfo() to denote that it is
 * not known whether or not a data type supports null values.
 */
Const SQL_NULLABLE_UNKNOWN  = 2

/* Values returned by SQLGetTypeInfo() to show WHERE clause
 * supported
 */
Const SQL_PRED_NONE     = 0
Const SQL_PRED_CHAR     = 1
Const SQL_PRED_BASIC    = 2

/* values of UNNAMED field in descriptor */
Const SQL_NAMED           = 0
Const SQL_UNNAMED         = 1

/* values of ALLOC_TYPE field in descriptor */
Const SQL_DESC_ALLOC_AUTO = 1
Const SQL_DESC_ALLOC_USER = 2

/* FreeStmt() options */
Const SQL_CLOSE           = 0
Const SQL_DROP            = 1
Const SQL_UNBIND          = 2
Const SQL_RESET_PARAMS    = 3

/* Codes used for FetchOrientation in SQLFetchScroll(), 
   and in SQLDataSources() 
*/
Const SQL_FETCH_NEXT      = 1
Const SQL_FETCH_FIRST     = 2

/* Other codes used for FetchOrientation in SQLFetchScroll() */
Const SQL_FETCH_LAST      = 3
Const SQL_FETCH_PRIOR     = 4
Const SQL_FETCH_ABSOLUTE  = 5
Const SQL_FETCH_RELATIVE  = 6

/* SQLEndTran() options */
Const SQL_COMMIT          = 0
Const SQL_ROLLBACK        = 1

/* null handles returned by SQLAllocHandle() */
Const SQL_NULL_HENV       = 0
Const SQL_NULL_HDBC       = 0
Const SQL_NULL_HSTMT      = 0
Const SQL_NULL_HDESC      = 0

/* null handle used in place of parent handle when allocating HENV */
Const SQL_NULL_HANDLE     = 0

/* Values that may appear in the result set of SQLSpecialColumns() */
Const SQL_SCOPE_CURROW    = 0
Const SQL_SCOPE_TRANSACTION = 1
Const SQL_SCOPE_SESSION   = 2

Const SQL_PC_UNKNOWN      = 0
Const SQL_PC_NON_PSEUDO   = 1
Const SQL_PC_PSEUDO       = 2

/* Reserved value for the IdentifierType argument of SQLSpecialColumns() */
Const SQL_ROW_IDENTIFIER  = 1

/* Reserved values for UNIQUE argument of SQLStatistics() */
Const SQL_INDEX_UNIQUE    = 0
Const SQL_INDEX_ALL       = 1

/* Values that may appear in the result set of SQLStatistics() */
Const SQL_INDEX_CLUSTERED = 1
Const SQL_INDEX_HASHED    = 2
Const SQL_INDEX_OTHER     = 3

/* SQLGetFunctions() values to identify ODBC APIs */
Const SQL_API_SQLALLOCCONNECT         = 1
Const SQL_API_SQLALLOCENV             = 2
Const SQL_API_SQLALLOCHANDLE       = 1001
Const SQL_API_SQLALLOCSTMT            = 3
Const SQL_API_SQLBINDCOL              = 4
Const SQL_API_SQLBINDPARAM         = 1002
Const SQL_API_SQLCANCEL               = 5
Const SQL_API_SQLCLOSECURSOR       = 1003
Const SQL_API_SQLCOLATTRIBUTE         = 6
Const SQL_API_SQLCOLUMNS             = 40
Const SQL_API_SQLCONNECT              = 7
Const SQL_API_SQLCOPYDESC          = 1004
Const SQL_API_SQLDATASOURCES         = 57
Const SQL_API_SQLDESCRIBECOL          = 8
Const SQL_API_SQLDISCONNECT           = 9
Const SQL_API_SQLENDTRAN           = 1005
Const SQL_API_SQLERROR               = 10
Const SQL_API_SQLEXECDIRECT          = 11
Const SQL_API_SQLEXECUTE             = 12
Const SQL_API_SQLFETCH               = 13
Const SQL_API_SQLFETCHSCROLL       = 1021
Const SQL_API_SQLFREECONNECT         = 14
Const SQL_API_SQLFREEENV             = 15
Const SQL_API_SQLFREEHANDLE        = 1006
Const SQL_API_SQLFREESTMT            = 16
Const SQL_API_SQLGETCONNECTATTR    = 1007
Const SQL_API_SQLGETCONNECTOPTION    = 42
Const SQL_API_SQLGETCURSORNAME       = 17
Const SQL_API_SQLGETDATA             = 43
Const SQL_API_SQLGETDESCFIELD      = 1008
Const SQL_API_SQLGETDESCREC        = 1009
Const SQL_API_SQLGETDIAGFIELD      = 1010
Const SQL_API_SQLGETDIAGREC        = 1011
Const SQL_API_SQLGETENVATTR        = 1012
Const SQL_API_SQLGETFUNCTIONS        = 44
Const SQL_API_SQLGETINFO             = 45
Const SQL_API_SQLGETSTMTATTR       = 1014
Const SQL_API_SQLGETSTMTOPTION       = 46
Const SQL_API_SQLGETTYPEINFO         = 47
Const SQL_API_SQLNUMRESULTCOLS       = 18
Const SQL_API_SQLPARAMDATA           = 48
Const SQL_API_SQLPREPARE             = 19
Const SQL_API_SQLPUTDATA             = 49
Const SQL_API_SQLROWCOUNT            = 20
Const SQL_API_SQLSETCONNECTATTR    = 1016
Const SQL_API_SQLSETCONNECTOPTION    = 50
Const SQL_API_SQLSETCURSORNAME       = 21
Const SQL_API_SQLSETDESCFIELD      = 1017
Const SQL_API_SQLSETDESCREC        = 1018
Const SQL_API_SQLSETENVATTR        = 1019
Const SQL_API_SQLSETPARAM            = 22
Const SQL_API_SQLSETSTMTATTR       = 1020
Const SQL_API_SQLSETSTMTOPTION       = 51
Const SQL_API_SQLSPECIALCOLUMNS      = 52
Const SQL_API_SQLSTATISTICS          = 53
Const SQL_API_SQLTABLES              = 54
Const SQL_API_SQLTRANSACT            = 23

/* Information requested by SQLGetInfo() */
Const SQL_MAX_DRIVER_CONNECTIONS           = 0
Const SQL_MAXIMUM_DRIVER_CONNECTIONS     = SQL_MAX_DRIVER_CONNECTIONS
Const SQL_MAX_CONCURRENT_ACTIVITIES        = 1
Const SQL_MAXIMUM_CONCURRENT_ACTIVITIES = SQL_MAX_CONCURRENT_ACTIVITIES
Const SQL_DATA_SOURCE_NAME                 = 2
Const SQL_FETCH_DIRECTION                  = 8
Const SQL_SERVER_NAME                     = 13
Const SQL_SEARCH_PATTERN_ESCAPE           = 14
Const SQL_DBMS_NAME                       = 17
Const SQL_DBMS_VER                        = 18
Const SQL_ACCESSIBLE_TABLES               = 19
Const SQL_ACCESSIBLE_PROCEDURES         = 20
Const SQL_CURSOR_COMMIT_BEHAVIOR          = 23
Const SQL_DATA_SOURCE_READ_ONLY           = 25
Const SQL_DEFAULT_TXN_ISOLATION           = 26
Const SQL_IDENTIFIER_CASE                 = 28
Const SQL_IDENTIFIER_QUOTE_CHAR           = 29
Const SQL_MAX_COLUMN_NAME_LEN             = 30
Const SQL_MAXIMUM_COLUMN_NAME_LENGTH     = SQL_MAX_COLUMN_NAME_LEN
Const SQL_MAX_CURSOR_NAME_LEN             = 31
Const SQL_MAXIMUM_CURSOR_NAME_LENGTH     = SQL_MAX_CURSOR_NAME_LEN
Const SQL_MAX_SCHEMA_NAME_LEN             = 32
Const SQL_MAXIMUM_SCHEMA_NAME_LENGTH     = SQL_MAX_SCHEMA_NAME_LEN
Const SQL_MAX_CATALOG_NAME_LEN            = 34
Const SQL_MAXIMUM_CATALOG_NAME_LENGTH    = SQL_MAX_CATALOG_NAME_LEN
Const SQL_MAX_TABLE_NAME_LEN              = 35
Const SQL_SCROLL_CONCURRENCY              = 43
Const SQL_TXN_CAPABLE                     = 46
Const SQL_TRANSACTION_CAPABLE            = SQL_TXN_CAPABLE
Const SQL_USER_NAME                       = 47
Const SQL_TXN_ISOLATION_OPTION            = 72
Const SQL_TRANSACTION_ISOLATION_OPTION = SQL_TXN_ISOLATION_OPTION
Const SQL_INTEGRITY                       = 73
Const SQL_GETDATA_EXTENSIONS              = 81
Const SQL_NULL_COLLATION                  = 85
Const SQL_ALTER_TABLE                     = 86
Const SQL_ORDER_BY_COLUMNS_IN_SELECT      = 90
Const SQL_SPECIAL_CHARACTERS              = 94
Const SQL_MAX_COLUMNS_IN_GROUP_BY         = 97
Const SQL_MAXIMUM_COLUMNS_IN_GROUP_BY    = SQL_MAX_COLUMNS_IN_GROUP_BY
Const SQL_MAX_COLUMNS_IN_INDEX            = 98
Const SQL_MAXIMUM_COLUMNS_IN_INDEX   = SQL_MAX_COLUMNS_IN_INDEX
Const SQL_MAX_COLUMNS_IN_ORDER_BY         = 99
Const SQL_MAXIMUM_COLUMNS_IN_ORDER_BY    = SQL_MAX_COLUMNS_IN_ORDER_BY
Const SQL_MAX_COLUMNS_IN_SELECT          = 100
Const SQL_MAXIMUM_COLUMNS_IN_SELECT    = SQL_MAX_COLUMNS_IN_SELECT
Const SQL_MAX_COLUMNS_IN_TABLE           = 101
Const SQL_MAX_INDEX_SIZE                 = 102
Const SQL_MAXIMUM_INDEX_SIZE               = SQL_MAX_INDEX_SIZE
Const SQL_MAX_ROW_SIZE                   = 104
Const SQL_MAXIMUM_ROW_SIZE             = SQL_MAX_ROW_SIZE
Const SQL_MAX_STATEMENT_LEN              = 105
Const SQL_MAXIMUM_STATEMENT_LENGTH     = SQL_MAX_STATEMENT_LEN
Const SQL_MAX_TABLES_IN_SELECT           = 106
Const SQL_MAXIMUM_TABLES_IN_SELECT     = SQL_MAX_TABLES_IN_SELECT
Const SQL_MAX_USER_NAME_LEN              = 107
Const SQL_MAXIMUM_USER_NAME_LENGTH     = SQL_MAX_USER_NAME_LEN
Const SQL_OJ_CAPABILITIES                = 115
Const SQL_OUTER_JOIN_CAPABILITIES          = SQL_OJ_CAPABILITIES

Const SQL_XOPEN_CLI_YEAR               = 10000
Const SQL_CURSOR_SENSITIVITY           = 10001
Const SQL_DESCRIBE_PARAMETER           = 10002
Const SQL_CATALOG_NAME                 = 10003
Const SQL_COLLATION_SEQ                = 10004
Const SQL_MAX_IDENTIFIER_LEN           = 10005
Const SQL_MAXIMUM_IDENTIFIER_LENGTH  = SQL_MAX_IDENTIFIER_LEN

/* SQL_ALTER_TABLE bitmasks */
Const SQL_AT_ADD_COLUMN                    = &H00000001
Const SQL_AT_DROP_COLUMN                   = &H00000002
Const SQL_AT_ADD_CONSTRAINT                = &H00000008

/* SQL_ASYNC_MODE values */
Const SQL_AM_NONE                         = 0
Const SQL_AM_CONNECTION                   = 1
Const SQL_AM_STATEMENT                    = 2

/* SQL_CURSOR_COMMIT_BEHAVIOR values */
Const SQL_CB_DELETE                       = 0
Const SQL_CB_CLOSE                        = 1
Const SQL_CB_PRESERVE                     = 2

/* SQL_FETCH_DIRECTION bitmasks */
Const SQL_FD_FETCH_NEXT                   = &H00000001
Const SQL_FD_FETCH_FIRST                  = &H00000002
Const SQL_FD_FETCH_LAST                   = &H00000004
Const SQL_FD_FETCH_PRIOR                  = &H00000008
Const SQL_FD_FETCH_ABSOLUTE               = &H00000010
Const SQL_FD_FETCH_RELATIVE               = &H00000020

/* SQL_GETDATA_EXTENSIONS bitmasks */
Const SQL_GD_ANY_COLUMN                   = &H00000001
Const SQL_GD_ANY_ORDER                    = &H00000002

/* SQL_IDENTIFIER_CASE values */
Const SQL_IC_UPPER                        = 1
Const SQL_IC_LOWER                        = 2
Const SQL_IC_SENSITIVE                    = 3
Const SQL_IC_MIXED                        = 4

/* SQL_OJ_CAPABILITIES bitmasks */
/* NB: this means 'outer join', not what  you may be thinking */


Const SQL_OJ_LEFT                         = &H00000001
Const SQL_OJ_RIGHT                        = &H00000002
Const SQL_OJ_FULL                         = &H00000004
Const SQL_OJ_NESTED                       = &H00000008
Const SQL_OJ_NOT_ORDERED                  = &H00000010
Const SQL_OJ_INNER                        = &H00000020
Const SQL_OJ_ALL_COMPARISON_OPS           = &H00000040

/* SQL_SCROLL_CONCURRENCY bitmasks */
Const SQL_SCCO_READ_ONLY                  = &H00000001
Const SQL_SCCO_LOCK                       = &H00000002
Const SQL_SCCO_OPT_ROWVER                 = &H00000004
Const SQL_SCCO_OPT_VALUES                 = &H00000008

/* SQL_TXN_CAPABLE values */
Const SQL_TC_NONE                         = 0
Const SQL_TC_DML                          = 1
Const SQL_TC_ALL                          = 2
Const SQL_TC_DDL_COMMIT                   = 3
Const SQL_TC_DDL_IGNORE                   = 4

/* SQL_TXN_ISOLATION_OPTION bitmasks */
Const SQL_TXN_READ_UNCOMMITTED            = &H00000001
Const SQL_TRANSACTION_READ_UNCOMMITTED = SQL_TXN_READ_UNCOMMITTED
Const SQL_TXN_READ_COMMITTED              = &H00000002
Const SQL_TRANSACTION_READ_COMMITTED     = SQL_TXN_READ_COMMITTED
Const SQL_TXN_REPEATABLE_READ             = &H00000004
Const SQL_TRANSACTION_REPEATABLE_READ    = SQL_TXN_REPEATABLE_READ
Const SQL_TXN_SERIALIZABLE                = &H00000008
Const SQL_TRANSACTION_SERIALIZABLE   = SQL_TXN_SERIALIZABLE

/* SQL_NULL_COLLATION values */
Const SQL_NC_HIGH                         = 0
Const SQL_NC_LOW                          = 1


Declare Function SQLAllocConnect Lib "odbc32.dll" (
    EnvironmentHandle As SQLHENV,
    ByRef ConnectionHandle As SQLHDBC) As SQLRETURN

Declare Function SQLAllocEnv Lib "odbc32.dll" (ByRef EnvironmentHandle As SQLHENV) As SQLRETURN

Declare Function SQLAllocHandle Lib "odbc32.dll" (HandleType As SQLSMALLINT,
           InputHandle As SQLHANDLE, ByRef OutputHandle As SQLHANDLE) As SQLRETURN

Declare Function SQLAllocStmt Lib "odbc32.dll" (ConnectionHandle As SQLHDBC,
           ByRef StatementHandle As SQLHSTMT) As SQLRETURN

Declare Function SQLBindCol Lib "odbc32.dll" (StatementHandle As SQLHSTMT, 
           ColumnNumber As SQLUSMALLINT, TargetType As SQLSMALLINT, 
           ByRef TargetValue As Any, BufferLength As SQLLEN, 
           ByRef StrLen_or_Ind As SQLLEN) As SQLRETURN

Declare Function SQLBindParam Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
           ParameterNumber As SQLUSMALLINT, ValueType As SQLSMALLINT,
           ParameterType As SQLSMALLINT, LengthPrecision As SQLULEN,
           ParameterScale As SQLSMALLINT, ParameterValue As SQLPOINTER,
           ByRef StrLen_or_Ind As SQLLEN) As SQLRETURN

Declare Function SQLCancel Lib "odbc32.dll" (StatementHandle As SQLHSTMT) As SQLRETURN

Declare Function SQLCloseCursor Lib "odbc32.dll" (StatementHandle As SQLHSTMT) As SQLRETURN

#ifdef _WIN64
Declare Function SQLColAttribute Lib "odbc32.dll"  (StatementHandle As SQLHSTMT,
           ColumnNumber As SQLUSMALLINT, FieldIdentifier As SQLUSMALLINT,
           CharacterAttribute As SQLPOINTER, BufferLength As SQLSMALLINT,
           ByRef StringLength As SQLSMALLINT, ByRef NumericAttribute As SQLLEN) As SQLRETURN
#else
Declare Function SQLColAttribute Lib "odbc32.dll"  (StatementHandle As SQLHSTMT,
           ColumnNumber As SQLUSMALLINT, FieldIdentifier As SQLUSMALLINT,
           CharacterAttribute As SQLPOINTER, BufferLength As SQLSMALLINT,
           ByRef StringLength As SQLSMALLINT, NumericAttribute As SQLPOINTER) As SQLRETURN
#endif


Declare Function SQLColumns Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
           CatalogName As *SQLCHAR, NameLength1 As SQLSMALLINT,
           SchemaName As *SQLCHAR, NameLength2 As SQLSMALLINT,
           TableName As *SQLCHAR, NameLength3 As SQLSMALLINT,
           ColumnName As *SQLCHAR, NameLength4 As SQLSMALLINT) As SQLRETURN


Declare Function SQLConnect Lib "odbc32.dll" (ConnectionHandle As SQLHDBC,
           ServerName As *SQLCHAR, NameLength1 As SQLSMALLINT,
           UserName As *SQLCHAR, NameLength2 As SQLSMALLINT,
           Authentication As *SQLCHAR, NameLength3 As SQLSMALLINT) As SQLRETURN

Declare Function SQLCopyDesc Lib "odbc32.dll" (SourceDescHandle As SQLHDESC,
           TargetDescHandle As SQLHDESC) As SQLRETURN

Declare Function SQLDataSources Lib "odbc32.dll" (EnvironmentHandle As SQLHENV,
           Direction As SQLUSMALLINT, ServerName As *SQLCHAR,
           BufferLength1 As SQLSMALLINT, ByRef NameLength1 As SQLSMALLINT,
           Description As *SQLCHAR, BufferLength2 As SQLSMALLINT,
           ByRef NameLength2 As SQLSMALLINT) As SQLRETURN

Declare Function SQLDescribeCol Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
           ColumnNumber As SQLSMALLINT, ColumnName As *SQLCHAR,
           BufferLength As SQLSMALLINT, ByRef NameLength As SQLSMALLINT,
           ByRef DataType As SQLSMALLINT, ByRef ColumnSize As SQLINTEGER,
           ByRef DecimalDigits As SQLSMALLINT, ByRef Nullable As SQLSMALLINT) As SQLRETURN

Declare Function SQLDisconnect Lib "odbc32.dll" (ConnectionHandle As SQLHDBC) As SQLRETURN

Declare Function SQLEndTran Lib "odbc32.dll" (HandleType As SQLSMALLINT, Handle As SQLHANDLE,
           CompletionType As SQLSMALLINT) As SQLRETURN

Declare Function SQLError Lib "odbc32.dll" (EnvironmentHandle As SQLHENV,
           ConnectionHandle As SQLHDBC, StatementHandle As SQLHSTMT,
           Sqlstate As *SQLCHAR, ByRef NativeError As SQLINTEGER,
           MessageText As *SQLCHAR, BufferLength As SQLSMALLINT,
           ByRef TextLength As SQLSMALLINT) As SQLRETURN

Declare Function SQLExecDirect Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
           StatementText As *SQLCHAR, TextLength As SQLINTEGER) As SQLRETURN

Declare Function SQLExecute Lib "odbc32.dll" (StatementHandle As SQLHSTMT) As SQLRETURN

Declare Function SQLFetch Lib "odbc32.dll" (StatementHandle As SQLHSTMT) As SQLRETURN

Declare Function SQLFetchScroll Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
           FetchOrientation As SQLSMALLINT, FetchOffset As SQLLEN) As SQLRETURN

Declare Function SQLFreeConnect Lib "odbc32.dll" (ConnectionHandle As SQLHDBC) As SQLRETURN

Declare Function SQLFreeEnv Lib "odbc32.dll" (EnvironmentHandle As SQLHENV) As SQLRETURN

Declare Function SQLFreeHandle Lib "odbc32.dll" (HandleType As SQLSMALLINT, Handle As SQLHANDLE) As SQLRETURN

Declare Function SQLFreeStmt Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
           Option As SQLUSMALLINT) As SQLRETURN

Declare Function SQLGetConnectAttr Lib "odbc32.dll" (ConnectionHandle As SQLHDBC,
           Attribute As SQLINTEGER, Value As SQLPOINTER,
           BufferLength As SQLINTEGER, ByRef StringLength As SQLINTEGER) As SQLRETURN

Declare Function SQLGetConnectOption Lib "odbc32.dll" (ConnectionHandle As SQLHDBC,
           Option As SQLUSMALLINT, Value As SQLPOINTER) As SQLRETURN

Declare Function SQLGetCursorName Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
           CursorName As *SQLCHAR, BufferLength As SQLSMALLINT,
           ByRef NameLength As SQLSMALLINT) As SQLRETURN

Declare Function SQLGetData Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
           ColumnNumber As SQLUSMALLINT, TargetType As SQLSMALLINT,
           TargetValue As SQLPOINTER, BufferLength As SQLLEN,
           ByRef StrLen_or_Ind As SQLLEN) As SQLRETURN

Declare Function SQLGetDescField Lib "odbc32.dll" (DescriptorHandle As SQLHDESC,
           RecNumber As SQLSMALLINT, FieldIdentifier As SQLSMALLINT,
           Value As SQLPOINTER, BufferLength As SQLINTEGER,
           ByRef StringLength As SQLINTEGER) As SQLRETURN

Declare Function SQLGetDescRec Lib "odbc32.dll" (DescriptorHandle As SQLHDESC,
           RecNumber As SQLSMALLINT, Name As *SQLCHAR,
           BufferLength As SQLSMALLINT, ByRef StringLength As SQLSMALLINT,
           ByRef iType As SQLSMALLINT, ByRef SubType As SQLSMALLINT, 
           ByRef Length As SQLLEN, ByRef Precision As SQLSMALLINT, 
           ByRef Scale As SQLSMALLINT, ByRef Nullable As SQLSMALLINT) As SQLRETURN

Declare Function SQLGetDiagField Lib "odbc32.dll" (HandleType As SQLSMALLINT, Handle As SQLHANDLE,
           RecNumber As SQLSMALLINT, DiagIdentifier As SQLSMALLINT,
           DiagInfo As SQLPOINTER, BufferLength As SQLSMALLINT,
           ByRef StringLength As SQLSMALLINT) As SQLRETURN

Declare Function SQLGetDiagRec Lib "odbc32.dll" (HandleType As SQLSMALLINT, Handle As SQLHANDLE,
           RecNumber As SQLSMALLINT, Sqlstate As *SQLCHAR,
           ByRef NativeError As SQLINTEGER, MessageText As *SQLCHAR,
           BufferLength As SQLSMALLINT, ByRef TextLength As SQLSMALLINT) As SQLRETURN

Declare Function SQLGetEnvAttr Lib "odbc32.dll" (EnvironmentHandle As SQLHENV,
           Attribute As SQLINTEGER, Value As SQLPOINTER,
           BufferLength As SQLINTEGER, ByRef StringLength As SQLINTEGER) As SQLRETURN

Declare Function SQLGetFunctions Lib "odbc32.dll" (ConnectionHandle As SQLHDBC,
           FunctionId As SQLUSMALLINT, ByRef Supported As SQLUSMALLINT) As SQLRETURN

Declare Function SQLGetInfo Lib "odbc32.dll" (ConnectionHandle As SQLHDBC,
           InfoType As SQLUSMALLINT, InfoValue As SQLPOINTER,
           BufferLength As SQLSMALLINT, ByRef StringLength As SQLSMALLINT) As SQLRETURN

Declare Function SQLGetStmtAttr Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
           Attribute As SQLINTEGER, Value As SQLPOINTER,
           BufferLength As SQLINTEGER, ByRef StringLength As SQLINTEGER) As SQLRETURN

Declare Function SQLGetStmtOption Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
           Option As SQLUSMALLINT, Value As SQLPOINTER) As SQLRETURN

Declare Function SQLGetTypeInfo Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
           DataType As SQLSMALLINT) As SQLRETURN

Declare Function SQLNumResultCols Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
           ByRef ColumnCount As SQLSMALLINT) As SQLRETURN

Declare Function SQLParamData Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
           ByRef Value As SQLPOINTER) As SQLRETURN

Declare Function SQLPrepare Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
           StatementText As *SQLCHAR, TextLength As SQLINTEGER) As SQLRETURN

Declare Function SQLPutData Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
           Data As SQLPOINTER, StrLen_or_Ind As SQLLEN) As SQLRETURN

Declare Function SQLRowCount Lib "odbc32.dll" (StatementHandle As SQLHSTMT, 
       ByRef RowCount As SQLLEN) As SQLRETURN

Declare Function SQLSetConnectAttr Lib "odbc32.dll" (ConnectionHandle As SQLHDBC,
           Attribute As SQLINTEGER, Value As SQLPOINTER,
           StringLength As SQLINTEGER) As SQLRETURN

Declare Function SQLSetConnectOption Lib "odbc32.dll" (ConnectionHandle As SQLHDBC,
           Option As SQLUSMALLINT, Value As SQLULEN) As SQLRETURN

Declare Function SQLSetCursorName Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
           CursorName As *SQLCHAR, NameLength As SQLSMALLINT) As SQLRETURN

Declare Function SQLSetDescField Lib "odbc32.dll" (DescriptorHandle As SQLHDESC,
           RecNumber As SQLSMALLINT, FieldIdentifier As SQLSMALLINT,
           Value As SQLPOINTER, BufferLength As SQLINTEGER) As SQLRETURN

Declare Function SQLSetDescRec Lib "odbc32.dll" (DescriptorHandle As SQLHDESC,
           RecNumber As SQLSMALLINT, iType As SQLSMALLINT,
           SubType As SQLSMALLINT, Length As SQLLEN,
           Precision As SQLSMALLINT, Scale As SQLSMALLINT,
           Data As SQLPOINTER, ByRef StringLength As SQLLEN,
           ByRef Indicator As SQLLEN) As SQLRETURN

Declare Function SQLSetEnvAttr Lib "odbc32.dll" (EnvironmentHandle As SQLHENV,
           Attribute As SQLINTEGER, Value As SQLPOINTER,
           StringLength As SQLINTEGER) As SQLRETURN

Declare Function SQLSetParam Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
           ParameterNumber As SQLUSMALLINT, ValueType As SQLSMALLINT,
           ParameterType As SQLSMALLINT, LengthPrecision As SQLULEN,
           ParameterScale As SQLSMALLINT, ParameterValue As SQLPOINTER,
           ByRef StrLen_or_Ind As SQLLEN) As SQLRETURN

Declare Function SQLSetStmtAttr Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
           Attribute As SQLINTEGER, Value As SQLPOINTER,
           StringLength As SQLINTEGER) As SQLRETURN

Declare Function SQLSetStmtOption Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
           Option As SQLUSMALLINT, Value As SQLULEN) As SQLRETURN

Declare Function SQLSpecialColumns Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
           IdentifierType As SQLUSMALLINT, CatalogName As *SQLCHAR,
           NameLength1 As SQLSMALLINT, SchemaName As *SQLCHAR,
           NameLength2 As SQLSMALLINT, TableName As *SQLCHAR,
           NameLength3 As SQLSMALLINT, Scope As SQLUSMALLINT,
           Nullable As SQLUSMALLINT) As SQLRETURN

Declare Function SQLStatistics Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
           CatalogName As *SQLCHAR, NameLength1 As SQLSMALLINT,
           SchemaName As *SQLCHAR, NameLength2 As SQLSMALLINT,
           TableName As *SQLCHAR, NameLength3 As SQLSMALLINT,
           Unique As SQLUSMALLINT, Reserved As SQLUSMALLINT) As SQLRETURN

Declare Function SQLTables Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
           CatalogName As *SQLCHAR, NameLength1 As SQLSMALLINT,
           SchemaName As *SQLCHAR, NameLength2 As SQLSMALLINT,
           TableName As *SQLCHAR, NameLength3 As SQLSMALLINT,
           TableType As *SQLCHAR, NameLength4 As SQLSMALLINT) As SQLRETURN

Declare Function SQLTransact Lib "odbc32.dll" (EnvironmentHandle As SQLHENV,
           ConnectionHandle As SQLHDBC, CompletionType As SQLUSMALLINT) As SQLRETURN