| 1 | ' api_sql.sbp
|
|---|
| 2 |
|
|---|
| 3 | #ifndef _INC_SQL
|
|---|
| 4 | #define _INC_SQL
|
|---|
| 5 |
|
|---|
| 6 |
|
|---|
| 7 | /* API declaration data types */
|
|---|
| 8 | TypeDef SQLCHAR = Byte
|
|---|
| 9 | TypeDef SQLSCHAR = Char
|
|---|
| 10 | TypeDef SQLDATE = Byte
|
|---|
| 11 | TypeDef SQLDECIMAL = Byte
|
|---|
| 12 | TypeDef SQLDOUBLE = Double
|
|---|
| 13 | TypeDef SQLFLOAT = Double
|
|---|
| 14 | TypeDef SQLINTEGER = Long
|
|---|
| 15 | TypeDef SQLUINTEGER = DWord
|
|---|
| 16 | #ifdef _WIN64
|
|---|
| 17 | TypeDef SQLLEN = Int64
|
|---|
| 18 | TypeDef SQLULEN = QWord
|
|---|
| 19 | TypeDef SQLSETPOSIROW = QWord
|
|---|
| 20 | #else
|
|---|
| 21 | TypeDef SQLLEN = SQLINTEGER
|
|---|
| 22 | TypeDef SQLULEN = SQLUINTEGER
|
|---|
| 23 | TypeDef SQLSETPOSIROW = SQLUSMALLINT
|
|---|
| 24 | #endif
|
|---|
| 25 |
|
|---|
| 26 | 'For Backward compatibility
|
|---|
| 27 | TypeDef SQLROWCOUNT = SQLULEN
|
|---|
| 28 | TypeDef SQLROWSETSIZE = SQLULEN
|
|---|
| 29 | TypeDef SQLTRANSID = SQLULEN
|
|---|
| 30 | TypeDef SQLROWOFFSET = SQLLEN
|
|---|
| 31 |
|
|---|
| 32 | TypeDef SQLNUMERIC = Byte
|
|---|
| 33 | TypeDef SQLPOINTER = VoidPtr
|
|---|
| 34 | TypeDef SQLREAL = Single
|
|---|
| 35 | TypeDef SQLSMALLINT = Integer
|
|---|
| 36 | TypeDef SQLUSMALLINT = Word
|
|---|
| 37 | TypeDef SQLTIME = Byte
|
|---|
| 38 | TypeDef SQLTIMESTAMP = Byte
|
|---|
| 39 | TypeDef SQLVARCHAR = Byte
|
|---|
| 40 |
|
|---|
| 41 | /* function return type */
|
|---|
| 42 | TypeDef SQLRETURN = SQLSMALLINT
|
|---|
| 43 |
|
|---|
| 44 | /* generic data structures */
|
|---|
| 45 | TypeDef SQLHANDLE = VoidPtr
|
|---|
| 46 | TypeDef SQLHENV = SQLHANDLE
|
|---|
| 47 | TypeDef SQLHDBC = SQLHANDLE
|
|---|
| 48 | TypeDef SQLHSTMT = SQLHANDLE
|
|---|
| 49 | TypeDef SQLHDESC = SQLHANDLE
|
|---|
| 50 |
|
|---|
| 51 |
|
|---|
| 52 |
|
|---|
| 53 | /* transfer types for DATE, TIME, TIMESTAMP */
|
|---|
| 54 | Type DATE_STRUCT
|
|---|
| 55 | year As SQLSMALLINT
|
|---|
| 56 | month As SQLUSMALLINT
|
|---|
| 57 | day As SQLUSMALLINT
|
|---|
| 58 | End Type
|
|---|
| 59 | TypeDef SQL_DATE_STRUCT = DATE_STRUCT
|
|---|
| 60 |
|
|---|
| 61 |
|
|---|
| 62 | Type TIME_STRUCT
|
|---|
| 63 | hour As SQLUSMALLINT
|
|---|
| 64 | minute As SQLUSMALLINT
|
|---|
| 65 | second As SQLUSMALLINT
|
|---|
| 66 | End Type
|
|---|
| 67 | TypeDef SQL_TIME_STRUCT = TIME_STRUCT
|
|---|
| 68 |
|
|---|
| 69 |
|
|---|
| 70 | Type TIMESTAMP_STRUCT
|
|---|
| 71 | year As SQLSMALLINT
|
|---|
| 72 | month As SQLUSMALLINT
|
|---|
| 73 | day As SQLUSMALLINT
|
|---|
| 74 | hour As SQLUSMALLINT
|
|---|
| 75 | minute As SQLUSMALLINT
|
|---|
| 76 | second As SQLUSMALLINT
|
|---|
| 77 | fraction As SQLUSMALLINT
|
|---|
| 78 | End Type
|
|---|
| 79 | TypeDef SQL_TIMESTAMP_STRUCT = TIMESTAMP_STRUCT
|
|---|
| 80 |
|
|---|
| 81 |
|
|---|
| 82 | Const Enum SQLINTERVAL
|
|---|
| 83 | SQL_IS_YEAR = 1
|
|---|
| 84 | SQL_IS_MONTH = 2
|
|---|
| 85 | SQL_IS_DAY = 3
|
|---|
| 86 | SQL_IS_HOUR = 4
|
|---|
| 87 | SQL_IS_MINUTE = 5
|
|---|
| 88 | SQL_IS_SECOND = 6
|
|---|
| 89 | SQL_IS_YEAR_TO_MONTH = 7
|
|---|
| 90 | SQL_IS_DAY_TO_HOUR = 8
|
|---|
| 91 | SQL_IS_DAY_TO_MINUTE = 9
|
|---|
| 92 | SQL_IS_DAY_TO_SECOND = 10
|
|---|
| 93 | SQL_IS_HOUR_TO_MINUTE = 11
|
|---|
| 94 | SQL_IS_HOUR_TO_SECOND = 12
|
|---|
| 95 | SQL_IS_MINUTE_TO_SECOND = 13
|
|---|
| 96 | End Enum
|
|---|
| 97 |
|
|---|
| 98 |
|
|---|
| 99 | Type SQL_YEAR_MONTH_STRUCT
|
|---|
| 100 | year As SQLUINTEGER
|
|---|
| 101 | month As SQLUINTEGER
|
|---|
| 102 | End Type
|
|---|
| 103 |
|
|---|
| 104 | Type SQL_DAY_SECOND_STRUCT
|
|---|
| 105 | day As SQLUINTEGER
|
|---|
| 106 | hour As SQLUINTEGER
|
|---|
| 107 | minute As SQLUINTEGER
|
|---|
| 108 | second As SQLUINTEGER
|
|---|
| 109 | fraction As SQLUINTEGER
|
|---|
| 110 | End Type
|
|---|
| 111 |
|
|---|
| 112 | Type SQL_INTERVAL_STRUCT
|
|---|
| 113 | interval_type As SQLINTERVAL
|
|---|
| 114 | interval_sign As SQLSMALLINT
|
|---|
| 115 |
|
|---|
| 116 | 'Union intval
|
|---|
| 117 | year_month As SQL_YEAR_MONTH_STRUCT
|
|---|
| 118 | 'day_second As SQL_DAY_SECOND_STRUCT
|
|---|
| 119 | 'End Union
|
|---|
| 120 | End Type
|
|---|
| 121 |
|
|---|
| 122 |
|
|---|
| 123 | Const SQL_MAX_NUMERIC_LEN = 16
|
|---|
| 124 | Type SQL_NUMERIC_STRUCT
|
|---|
| 125 | precision As SQLCHAR
|
|---|
| 126 | scale As SQLSCHAR
|
|---|
| 127 | sign As SQLCHAR
|
|---|
| 128 | val[ELM(SQL_MAX_NUMERIC_LEN)] As SQLCHAR
|
|---|
| 129 | End Type
|
|---|
| 130 |
|
|---|
| 131 |
|
|---|
| 132 | TypeDef SQLGUID = GUID
|
|---|
| 133 |
|
|---|
| 134 | TypeDef BOOKMARK = SQLULEN
|
|---|
| 135 |
|
|---|
| 136 | typedef SQLWCHAR = Word
|
|---|
| 137 | TypeDef SQLTCHAR = SQLCHAR
|
|---|
| 138 |
|
|---|
| 139 |
|
|---|
| 140 |
|
|---|
| 141 |
|
|---|
| 142 | /* special length/indicator values */
|
|---|
| 143 | Const SQL_NULL_DATA = (-1)
|
|---|
| 144 | Const SQL_DATA_AT_EXEC = (-2)
|
|---|
| 145 |
|
|---|
| 146 |
|
|---|
| 147 | /* return values from functions */
|
|---|
| 148 | Const SQL_SUCCESS = 0
|
|---|
| 149 | Const SQL_SUCCESS_WITH_INFO = 1
|
|---|
| 150 | Const SQL_NO_DATA = 100
|
|---|
| 151 | Const SQL_ERROR = (-1)
|
|---|
| 152 | Const SQL_INVALID_HANDLE = (-2)
|
|---|
| 153 |
|
|---|
| 154 | Const SQL_STILL_EXECUTING = 2
|
|---|
| 155 | Const SQL_NEED_DATA = 99
|
|---|
| 156 |
|
|---|
| 157 | /* test for SQL_SUCCESS or SQL_SUCCESS_WITH_INFO */
|
|---|
| 158 | Const SQL_SUCCEEDED(rc) = (((rc) and (not 1))=0)
|
|---|
| 159 |
|
|---|
| 160 | /* flags for null-terminated string */
|
|---|
| 161 | Const SQL_NTS = (-3)
|
|---|
| 162 | Const SQL_NTSL = (-3)
|
|---|
| 163 |
|
|---|
| 164 | /* maximum message length */
|
|---|
| 165 | Const SQL_MAX_MESSAGE_LENGTH = 512
|
|---|
| 166 |
|
|---|
| 167 | /* date/time length constants */
|
|---|
| 168 | Const SQL_DATE_LEN = 10
|
|---|
| 169 | Const SQL_TIME_LEN = 8 /* add P+1 if precision is nonzero */
|
|---|
| 170 | Const SQL_TIMESTAMP_LEN = 19 /* add P+1 if precision is nonzero */
|
|---|
| 171 |
|
|---|
| 172 | /* handle type identifiers */
|
|---|
| 173 | Const SQL_HANDLE_ENV = 1
|
|---|
| 174 | Const SQL_HANDLE_DBC = 2
|
|---|
| 175 | Const SQL_HANDLE_STMT = 3
|
|---|
| 176 | Const SQL_HANDLE_DESC = 4
|
|---|
| 177 |
|
|---|
| 178 | /* environment attribute */
|
|---|
| 179 | Const SQL_ATTR_OUTPUT_NTS = 10001
|
|---|
| 180 |
|
|---|
| 181 | /* connection attributes */
|
|---|
| 182 | Const SQL_ATTR_AUTO_IPD = 10001
|
|---|
| 183 | Const SQL_ATTR_METADATA_ID = 10014
|
|---|
| 184 |
|
|---|
| 185 | /* statement attributes */
|
|---|
| 186 | Const SQL_ATTR_APP_ROW_DESC = 10010
|
|---|
| 187 | Const SQL_ATTR_APP_PARAM_DESC = 10011
|
|---|
| 188 | Const SQL_ATTR_IMP_ROW_DESC = 10012
|
|---|
| 189 | Const SQL_ATTR_IMP_PARAM_DESC = 10013
|
|---|
| 190 | Const SQL_ATTR_CURSOR_SCROLLABLE = (-1)
|
|---|
| 191 | Const SQL_ATTR_CURSOR_SENSITIVITY = (-2)
|
|---|
| 192 |
|
|---|
| 193 | /* SQL_ATTR_CURSOR_SCROLLABLE values */
|
|---|
| 194 | Const SQL_NONSCROLLABLE = 0
|
|---|
| 195 | Const SQL_SCROLLABLE = 1
|
|---|
| 196 |
|
|---|
| 197 | /* identifiers of fields in the SQL descriptor */
|
|---|
| 198 | Const SQL_DESC_COUNT = 1001
|
|---|
| 199 | Const SQL_DESC_TYPE = 1002
|
|---|
| 200 | Const SQL_DESC_LENGTH = 1003
|
|---|
| 201 | Const SQL_DESC_OCTET_LENGTH_PTR = 1004
|
|---|
| 202 | Const SQL_DESC_PRECISION = 1005
|
|---|
| 203 | Const SQL_DESC_SCALE = 1006
|
|---|
| 204 | Const SQL_DESC_DATETIME_INTERVAL_CODE = 1007
|
|---|
| 205 | Const SQL_DESC_NULLABLE = 1008
|
|---|
| 206 | Const SQL_DESC_INDICATOR_PTR = 1009
|
|---|
| 207 | Const SQL_DESC_DATA_PTR = 1010
|
|---|
| 208 | Const SQL_DESC_NAME = 1011
|
|---|
| 209 | Const SQL_DESC_UNNAMED = 1012
|
|---|
| 210 | Const SQL_DESC_OCTET_LENGTH = 1013
|
|---|
| 211 | Const SQL_DESC_ALLOC_TYPE = 1099
|
|---|
| 212 |
|
|---|
| 213 | /* identifiers of fields in the diagnostics area */
|
|---|
| 214 | Const SQL_DIAG_RETURNCODE = 1
|
|---|
| 215 | Const SQL_DIAG_NUMBER = 2
|
|---|
| 216 | Const SQL_DIAG_ROW_COUNT = 3
|
|---|
| 217 | Const SQL_DIAG_SQLSTATE = 4
|
|---|
| 218 | Const SQL_DIAG_NATIVE = 5
|
|---|
| 219 | Const SQL_DIAG_MESSAGE_TEXT = 6
|
|---|
| 220 | Const SQL_DIAG_DYNAMIC_FUNCTION = 7
|
|---|
| 221 | Const SQL_DIAG_CLASS_ORIGIN = 8
|
|---|
| 222 | Const SQL_DIAG_SUBCLASS_ORIGIN = 9
|
|---|
| 223 | Const SQL_DIAG_CONNECTION_NAME = 10
|
|---|
| 224 | Const SQL_DIAG_SERVER_NAME = 11
|
|---|
| 225 | Const SQL_DIAG_DYNAMIC_FUNCTION_CODE = 12
|
|---|
| 226 |
|
|---|
| 227 | /* dynamic function codes */
|
|---|
| 228 | Const SQL_DIAG_ALTER_DOMAIN = 3
|
|---|
| 229 | Const SQL_DIAG_ALTER_TABLE = 4
|
|---|
| 230 | Const SQL_DIAG_CALL = 7
|
|---|
| 231 | Const SQL_DIAG_CREATE_ASSERTION = 6
|
|---|
| 232 | Const SQL_DIAG_CREATE_CHARACTER_SET = 8
|
|---|
| 233 | Const SQL_DIAG_CREATE_COLLATION = 10
|
|---|
| 234 | Const SQL_DIAG_CREATE_DOMAIN = 23
|
|---|
| 235 | Const SQL_DIAG_CREATE_INDEX = (-1)
|
|---|
| 236 | Const SQL_DIAG_CREATE_SCHEMA = 64
|
|---|
| 237 | Const SQL_DIAG_CREATE_TABLE = 77
|
|---|
| 238 | Const SQL_DIAG_CREATE_TRANSLATION = 79
|
|---|
| 239 | Const SQL_DIAG_CREATE_VIEW = 84
|
|---|
| 240 | Const SQL_DIAG_DELETE_WHERE = 19
|
|---|
| 241 | Const SQL_DIAG_DROP_ASSERTION = 24
|
|---|
| 242 | Const SQL_DIAG_DROP_CHARACTER_SET = 25
|
|---|
| 243 | Const SQL_DIAG_DROP_COLLATION = 26
|
|---|
| 244 | Const SQL_DIAG_DROP_DOMAIN = 27
|
|---|
| 245 | Const SQL_DIAG_DROP_INDEX = (-2)
|
|---|
| 246 | Const SQL_DIAG_DROP_SCHEMA = 31
|
|---|
| 247 | Const SQL_DIAG_DROP_TABLE = 32
|
|---|
| 248 | Const SQL_DIAG_DROP_TRANSLATION = 33
|
|---|
| 249 | Const SQL_DIAG_DROP_VIEW = 36
|
|---|
| 250 | Const SQL_DIAG_DYNAMIC_DELETE_CURSOR = 38
|
|---|
| 251 | Const SQL_DIAG_DYNAMIC_UPDATE_CURSOR = 81
|
|---|
| 252 | Const SQL_DIAG_GRANT = 48
|
|---|
| 253 | Const SQL_DIAG_INSERT = 50
|
|---|
| 254 | Const SQL_DIAG_REVOKE = 59
|
|---|
| 255 | Const SQL_DIAG_SELECT_CURSOR = 85
|
|---|
| 256 | Const SQL_DIAG_UNKNOWN_STATEMENT = 0
|
|---|
| 257 | Const SQL_DIAG_UPDATE_WHERE = 82
|
|---|
| 258 |
|
|---|
| 259 | /* SQL data type codes */
|
|---|
| 260 | Const SQL_UNKNOWN_TYPE = 0
|
|---|
| 261 | Const SQL_CHAR = 1
|
|---|
| 262 | Const SQL_NUMERIC = 2
|
|---|
| 263 | Const SQL_DECIMAL = 3
|
|---|
| 264 | Const SQL_INTEGER = 4
|
|---|
| 265 | Const SQL_SMALLINT = 5
|
|---|
| 266 | Const SQL_FLOAT = 6
|
|---|
| 267 | Const SQL_REAL = 7
|
|---|
| 268 | Const SQL_DOUBLE = 8
|
|---|
| 269 | Const SQL_DATETIME = 9
|
|---|
| 270 | Const SQL_VARCHAR = 12
|
|---|
| 271 |
|
|---|
| 272 | /* One-parameter shortcuts for date/time data types */
|
|---|
| 273 | Const SQL_TYPE_DATE = 91
|
|---|
| 274 | Const SQL_TYPE_TIME = 92
|
|---|
| 275 | Const SQL_TYPE_TIMESTAMP = 93
|
|---|
| 276 |
|
|---|
| 277 | /* Statement attribute values for cursor sensitivity */
|
|---|
| 278 | Const SQL_UNSPECIFIED = 0
|
|---|
| 279 | Const SQL_INSENSITIVE = 1
|
|---|
| 280 | Const SQL_SENSITIVE = 2
|
|---|
| 281 |
|
|---|
| 282 | /* GetTypeInfo() request for all data types */
|
|---|
| 283 | Const SQL_ALL_TYPES = 0
|
|---|
| 284 |
|
|---|
| 285 | /* Default conversion code for SQLBindCol(), SQLBindParam() and SQLGetData() */
|
|---|
| 286 | Const SQL_DEFAULT = 99
|
|---|
| 287 |
|
|---|
| 288 | /* SQLSQLLEN GetData() code indicating that the application row descriptor
|
|---|
| 289 | * specifies the data type
|
|---|
| 290 | */
|
|---|
| 291 | Const SQL_ARD_TYPE = (-99)
|
|---|
| 292 |
|
|---|
| 293 | /* SQL date/time type subcodes */
|
|---|
| 294 | Const SQL_CODE_DATE = 1
|
|---|
| 295 | Const SQL_CODE_TIME = 2
|
|---|
| 296 | Const SQL_CODE_TIMESTAMP = 3
|
|---|
| 297 |
|
|---|
| 298 | /* CLI option values */
|
|---|
| 299 | Const SQL_FALSE = 0
|
|---|
| 300 | Const SQL_TRUE = 1
|
|---|
| 301 |
|
|---|
| 302 | /* values of NULLABLE field in descriptor */
|
|---|
| 303 | Const SQL_NO_NULLS = 0
|
|---|
| 304 | Const SQL_NULLABLE = 1
|
|---|
| 305 |
|
|---|
| 306 | /* Value returned by SQLGetTypeInfo() to denote that it is
|
|---|
| 307 | * not known whether or not a data type supports null values.
|
|---|
| 308 | */
|
|---|
| 309 | Const SQL_NULLABLE_UNKNOWN = 2
|
|---|
| 310 |
|
|---|
| 311 | /* Values returned by SQLGetTypeInfo() to show WHERE clause
|
|---|
| 312 | * supported
|
|---|
| 313 | */
|
|---|
| 314 | Const SQL_PRED_NONE = 0
|
|---|
| 315 | Const SQL_PRED_CHAR = 1
|
|---|
| 316 | Const SQL_PRED_BASIC = 2
|
|---|
| 317 |
|
|---|
| 318 | /* values of UNNAMED field in descriptor */
|
|---|
| 319 | Const SQL_NAMED = 0
|
|---|
| 320 | Const SQL_UNNAMED = 1
|
|---|
| 321 |
|
|---|
| 322 | /* values of ALLOC_TYPE field in descriptor */
|
|---|
| 323 | Const SQL_DESC_ALLOC_AUTO = 1
|
|---|
| 324 | Const SQL_DESC_ALLOC_USER = 2
|
|---|
| 325 |
|
|---|
| 326 | /* FreeStmt() options */
|
|---|
| 327 | Const SQL_CLOSE = 0
|
|---|
| 328 | Const SQL_DROP = 1
|
|---|
| 329 | Const SQL_UNBIND = 2
|
|---|
| 330 | Const SQL_RESET_PARAMS = 3
|
|---|
| 331 |
|
|---|
| 332 | /* Codes used for FetchOrientation in SQLFetchScroll(),
|
|---|
| 333 | and in SQLDataSources()
|
|---|
| 334 | */
|
|---|
| 335 | Const SQL_FETCH_NEXT = 1
|
|---|
| 336 | Const SQL_FETCH_FIRST = 2
|
|---|
| 337 |
|
|---|
| 338 | /* Other codes used for FetchOrientation in SQLFetchScroll() */
|
|---|
| 339 | Const SQL_FETCH_LAST = 3
|
|---|
| 340 | Const SQL_FETCH_PRIOR = 4
|
|---|
| 341 | Const SQL_FETCH_ABSOLUTE = 5
|
|---|
| 342 | Const SQL_FETCH_RELATIVE = 6
|
|---|
| 343 |
|
|---|
| 344 | /* SQLEndTran() options */
|
|---|
| 345 | Const SQL_COMMIT = 0
|
|---|
| 346 | Const SQL_ROLLBACK = 1
|
|---|
| 347 |
|
|---|
| 348 | /* null handles returned by SQLAllocHandle() */
|
|---|
| 349 | Const SQL_NULL_HENV = 0
|
|---|
| 350 | Const SQL_NULL_HDBC = 0
|
|---|
| 351 | Const SQL_NULL_HSTMT = 0
|
|---|
| 352 | Const SQL_NULL_HDESC = 0
|
|---|
| 353 |
|
|---|
| 354 | /* null handle used in place of parent handle when allocating HENV */
|
|---|
| 355 | Const SQL_NULL_HANDLE = 0
|
|---|
| 356 |
|
|---|
| 357 | /* Values that may appear in the result set of SQLSpecialColumns() */
|
|---|
| 358 | Const SQL_SCOPE_CURROW = 0
|
|---|
| 359 | Const SQL_SCOPE_TRANSACTION = 1
|
|---|
| 360 | Const SQL_SCOPE_SESSION = 2
|
|---|
| 361 |
|
|---|
| 362 | Const SQL_PC_UNKNOWN = 0
|
|---|
| 363 | Const SQL_PC_NON_PSEUDO = 1
|
|---|
| 364 | Const SQL_PC_PSEUDO = 2
|
|---|
| 365 |
|
|---|
| 366 | /* Reserved value for the IdentifierType argument of SQLSpecialColumns() */
|
|---|
| 367 | Const SQL_ROW_IDENTIFIER = 1
|
|---|
| 368 |
|
|---|
| 369 | /* Reserved values for UNIQUE argument of SQLStatistics() */
|
|---|
| 370 | Const SQL_INDEX_UNIQUE = 0
|
|---|
| 371 | Const SQL_INDEX_ALL = 1
|
|---|
| 372 |
|
|---|
| 373 | /* Values that may appear in the result set of SQLStatistics() */
|
|---|
| 374 | Const SQL_INDEX_CLUSTERED = 1
|
|---|
| 375 | Const SQL_INDEX_HASHED = 2
|
|---|
| 376 | Const SQL_INDEX_OTHER = 3
|
|---|
| 377 |
|
|---|
| 378 | /* SQLGetFunctions() values to identify ODBC APIs */
|
|---|
| 379 | Const SQL_API_SQLALLOCCONNECT = 1
|
|---|
| 380 | Const SQL_API_SQLALLOCENV = 2
|
|---|
| 381 | Const SQL_API_SQLALLOCHANDLE = 1001
|
|---|
| 382 | Const SQL_API_SQLALLOCSTMT = 3
|
|---|
| 383 | Const SQL_API_SQLBINDCOL = 4
|
|---|
| 384 | Const SQL_API_SQLBINDPARAM = 1002
|
|---|
| 385 | Const SQL_API_SQLCANCEL = 5
|
|---|
| 386 | Const SQL_API_SQLCLOSECURSOR = 1003
|
|---|
| 387 | Const SQL_API_SQLCOLATTRIBUTE = 6
|
|---|
| 388 | Const SQL_API_SQLCOLUMNS = 40
|
|---|
| 389 | Const SQL_API_SQLCONNECT = 7
|
|---|
| 390 | Const SQL_API_SQLCOPYDESC = 1004
|
|---|
| 391 | Const SQL_API_SQLDATASOURCES = 57
|
|---|
| 392 | Const SQL_API_SQLDESCRIBECOL = 8
|
|---|
| 393 | Const SQL_API_SQLDISCONNECT = 9
|
|---|
| 394 | Const SQL_API_SQLENDTRAN = 1005
|
|---|
| 395 | Const SQL_API_SQLERROR = 10
|
|---|
| 396 | Const SQL_API_SQLEXECDIRECT = 11
|
|---|
| 397 | Const SQL_API_SQLEXECUTE = 12
|
|---|
| 398 | Const SQL_API_SQLFETCH = 13
|
|---|
| 399 | Const SQL_API_SQLFETCHSCROLL = 1021
|
|---|
| 400 | Const SQL_API_SQLFREECONNECT = 14
|
|---|
| 401 | Const SQL_API_SQLFREEENV = 15
|
|---|
| 402 | Const SQL_API_SQLFREEHANDLE = 1006
|
|---|
| 403 | Const SQL_API_SQLFREESTMT = 16
|
|---|
| 404 | Const SQL_API_SQLGETCONNECTATTR = 1007
|
|---|
| 405 | Const SQL_API_SQLGETCONNECTOPTION = 42
|
|---|
| 406 | Const SQL_API_SQLGETCURSORNAME = 17
|
|---|
| 407 | Const SQL_API_SQLGETDATA = 43
|
|---|
| 408 | Const SQL_API_SQLGETDESCFIELD = 1008
|
|---|
| 409 | Const SQL_API_SQLGETDESCREC = 1009
|
|---|
| 410 | Const SQL_API_SQLGETDIAGFIELD = 1010
|
|---|
| 411 | Const SQL_API_SQLGETDIAGREC = 1011
|
|---|
| 412 | Const SQL_API_SQLGETENVATTR = 1012
|
|---|
| 413 | Const SQL_API_SQLGETFUNCTIONS = 44
|
|---|
| 414 | Const SQL_API_SQLGETINFO = 45
|
|---|
| 415 | Const SQL_API_SQLGETSTMTATTR = 1014
|
|---|
| 416 | Const SQL_API_SQLGETSTMTOPTION = 46
|
|---|
| 417 | Const SQL_API_SQLGETTYPEINFO = 47
|
|---|
| 418 | Const SQL_API_SQLNUMRESULTCOLS = 18
|
|---|
| 419 | Const SQL_API_SQLPARAMDATA = 48
|
|---|
| 420 | Const SQL_API_SQLPREPARE = 19
|
|---|
| 421 | Const SQL_API_SQLPUTDATA = 49
|
|---|
| 422 | Const SQL_API_SQLROWCOUNT = 20
|
|---|
| 423 | Const SQL_API_SQLSETCONNECTATTR = 1016
|
|---|
| 424 | Const SQL_API_SQLSETCONNECTOPTION = 50
|
|---|
| 425 | Const SQL_API_SQLSETCURSORNAME = 21
|
|---|
| 426 | Const SQL_API_SQLSETDESCFIELD = 1017
|
|---|
| 427 | Const SQL_API_SQLSETDESCREC = 1018
|
|---|
| 428 | Const SQL_API_SQLSETENVATTR = 1019
|
|---|
| 429 | Const SQL_API_SQLSETPARAM = 22
|
|---|
| 430 | Const SQL_API_SQLSETSTMTATTR = 1020
|
|---|
| 431 | Const SQL_API_SQLSETSTMTOPTION = 51
|
|---|
| 432 | Const SQL_API_SQLSPECIALCOLUMNS = 52
|
|---|
| 433 | Const SQL_API_SQLSTATISTICS = 53
|
|---|
| 434 | Const SQL_API_SQLTABLES = 54
|
|---|
| 435 | Const SQL_API_SQLTRANSACT = 23
|
|---|
| 436 |
|
|---|
| 437 | /* Information requested by SQLGetInfo() */
|
|---|
| 438 | Const SQL_MAX_DRIVER_CONNECTIONS = 0
|
|---|
| 439 | Const SQL_MAXIMUM_DRIVER_CONNECTIONS = SQL_MAX_DRIVER_CONNECTIONS
|
|---|
| 440 | Const SQL_MAX_CONCURRENT_ACTIVITIES = 1
|
|---|
| 441 | Const SQL_MAXIMUM_CONCURRENT_ACTIVITIES = SQL_MAX_CONCURRENT_ACTIVITIES
|
|---|
| 442 | Const SQL_DATA_SOURCE_NAME = 2
|
|---|
| 443 | Const SQL_FETCH_DIRECTION = 8
|
|---|
| 444 | Const SQL_SERVER_NAME = 13
|
|---|
| 445 | Const SQL_SEARCH_PATTERN_ESCAPE = 14
|
|---|
| 446 | Const SQL_DBMS_NAME = 17
|
|---|
| 447 | Const SQL_DBMS_VER = 18
|
|---|
| 448 | Const SQL_ACCESSIBLE_TABLES = 19
|
|---|
| 449 | Const SQL_ACCESSIBLE_PROCEDURES = 20
|
|---|
| 450 | Const SQL_CURSOR_COMMIT_BEHAVIOR = 23
|
|---|
| 451 | Const SQL_DATA_SOURCE_READ_ONLY = 25
|
|---|
| 452 | Const SQL_DEFAULT_TXN_ISOLATION = 26
|
|---|
| 453 | Const SQL_IDENTIFIER_CASE = 28
|
|---|
| 454 | Const SQL_IDENTIFIER_QUOTE_CHAR = 29
|
|---|
| 455 | Const SQL_MAX_COLUMN_NAME_LEN = 30
|
|---|
| 456 | Const SQL_MAXIMUM_COLUMN_NAME_LENGTH = SQL_MAX_COLUMN_NAME_LEN
|
|---|
| 457 | Const SQL_MAX_CURSOR_NAME_LEN = 31
|
|---|
| 458 | Const SQL_MAXIMUM_CURSOR_NAME_LENGTH = SQL_MAX_CURSOR_NAME_LEN
|
|---|
| 459 | Const SQL_MAX_SCHEMA_NAME_LEN = 32
|
|---|
| 460 | Const SQL_MAXIMUM_SCHEMA_NAME_LENGTH = SQL_MAX_SCHEMA_NAME_LEN
|
|---|
| 461 | Const SQL_MAX_CATALOG_NAME_LEN = 34
|
|---|
| 462 | Const SQL_MAXIMUM_CATALOG_NAME_LENGTH = SQL_MAX_CATALOG_NAME_LEN
|
|---|
| 463 | Const SQL_MAX_TABLE_NAME_LEN = 35
|
|---|
| 464 | Const SQL_SCROLL_CONCURRENCY = 43
|
|---|
| 465 | Const SQL_TXN_CAPABLE = 46
|
|---|
| 466 | Const SQL_TRANSACTION_CAPABLE = SQL_TXN_CAPABLE
|
|---|
| 467 | Const SQL_USER_NAME = 47
|
|---|
| 468 | Const SQL_TXN_ISOLATION_OPTION = 72
|
|---|
| 469 | Const SQL_TRANSACTION_ISOLATION_OPTION = SQL_TXN_ISOLATION_OPTION
|
|---|
| 470 | Const SQL_INTEGRITY = 73
|
|---|
| 471 | Const SQL_GETDATA_EXTENSIONS = 81
|
|---|
| 472 | Const SQL_NULL_COLLATION = 85
|
|---|
| 473 | Const SQL_ALTER_TABLE = 86
|
|---|
| 474 | Const SQL_ORDER_BY_COLUMNS_IN_SELECT = 90
|
|---|
| 475 | Const SQL_SPECIAL_CHARACTERS = 94
|
|---|
| 476 | Const SQL_MAX_COLUMNS_IN_GROUP_BY = 97
|
|---|
| 477 | Const SQL_MAXIMUM_COLUMNS_IN_GROUP_BY = SQL_MAX_COLUMNS_IN_GROUP_BY
|
|---|
| 478 | Const SQL_MAX_COLUMNS_IN_INDEX = 98
|
|---|
| 479 | Const SQL_MAXIMUM_COLUMNS_IN_INDEX = SQL_MAX_COLUMNS_IN_INDEX
|
|---|
| 480 | Const SQL_MAX_COLUMNS_IN_ORDER_BY = 99
|
|---|
| 481 | Const SQL_MAXIMUM_COLUMNS_IN_ORDER_BY = SQL_MAX_COLUMNS_IN_ORDER_BY
|
|---|
| 482 | Const SQL_MAX_COLUMNS_IN_SELECT = 100
|
|---|
| 483 | Const SQL_MAXIMUM_COLUMNS_IN_SELECT = SQL_MAX_COLUMNS_IN_SELECT
|
|---|
| 484 | Const SQL_MAX_COLUMNS_IN_TABLE = 101
|
|---|
| 485 | Const SQL_MAX_INDEX_SIZE = 102
|
|---|
| 486 | Const SQL_MAXIMUM_INDEX_SIZE = SQL_MAX_INDEX_SIZE
|
|---|
| 487 | Const SQL_MAX_ROW_SIZE = 104
|
|---|
| 488 | Const SQL_MAXIMUM_ROW_SIZE = SQL_MAX_ROW_SIZE
|
|---|
| 489 | Const SQL_MAX_STATEMENT_LEN = 105
|
|---|
| 490 | Const SQL_MAXIMUM_STATEMENT_LENGTH = SQL_MAX_STATEMENT_LEN
|
|---|
| 491 | Const SQL_MAX_TABLES_IN_SELECT = 106
|
|---|
| 492 | Const SQL_MAXIMUM_TABLES_IN_SELECT = SQL_MAX_TABLES_IN_SELECT
|
|---|
| 493 | Const SQL_MAX_USER_NAME_LEN = 107
|
|---|
| 494 | Const SQL_MAXIMUM_USER_NAME_LENGTH = SQL_MAX_USER_NAME_LEN
|
|---|
| 495 | Const SQL_OJ_CAPABILITIES = 115
|
|---|
| 496 | Const SQL_OUTER_JOIN_CAPABILITIES = SQL_OJ_CAPABILITIES
|
|---|
| 497 |
|
|---|
| 498 | Const SQL_XOPEN_CLI_YEAR = 10000
|
|---|
| 499 | Const SQL_CURSOR_SENSITIVITY = 10001
|
|---|
| 500 | Const SQL_DESCRIBE_PARAMETER = 10002
|
|---|
| 501 | Const SQL_CATALOG_NAME = 10003
|
|---|
| 502 | Const SQL_COLLATION_SEQ = 10004
|
|---|
| 503 | Const SQL_MAX_IDENTIFIER_LEN = 10005
|
|---|
| 504 | Const SQL_MAXIMUM_IDENTIFIER_LENGTH = SQL_MAX_IDENTIFIER_LEN
|
|---|
| 505 |
|
|---|
| 506 | /* SQL_ALTER_TABLE bitmasks */
|
|---|
| 507 | Const SQL_AT_ADD_COLUMN = &H00000001
|
|---|
| 508 | Const SQL_AT_DROP_COLUMN = &H00000002
|
|---|
| 509 | Const SQL_AT_ADD_CONSTRAINT = &H00000008
|
|---|
| 510 |
|
|---|
| 511 | /* SQL_ASYNC_MODE values */
|
|---|
| 512 | Const SQL_AM_NONE = 0
|
|---|
| 513 | Const SQL_AM_CONNECTION = 1
|
|---|
| 514 | Const SQL_AM_STATEMENT = 2
|
|---|
| 515 |
|
|---|
| 516 | /* SQL_CURSOR_COMMIT_BEHAVIOR values */
|
|---|
| 517 | Const SQL_CB_DELETE = 0
|
|---|
| 518 | Const SQL_CB_CLOSE = 1
|
|---|
| 519 | Const SQL_CB_PRESERVE = 2
|
|---|
| 520 |
|
|---|
| 521 | /* SQL_FETCH_DIRECTION bitmasks */
|
|---|
| 522 | Const SQL_FD_FETCH_NEXT = &H00000001
|
|---|
| 523 | Const SQL_FD_FETCH_FIRST = &H00000002
|
|---|
| 524 | Const SQL_FD_FETCH_LAST = &H00000004
|
|---|
| 525 | Const SQL_FD_FETCH_PRIOR = &H00000008
|
|---|
| 526 | Const SQL_FD_FETCH_ABSOLUTE = &H00000010
|
|---|
| 527 | Const SQL_FD_FETCH_RELATIVE = &H00000020
|
|---|
| 528 |
|
|---|
| 529 | /* SQL_GETDATA_EXTENSIONS bitmasks */
|
|---|
| 530 | Const SQL_GD_ANY_COLUMN = &H00000001
|
|---|
| 531 | Const SQL_GD_ANY_ORDER = &H00000002
|
|---|
| 532 |
|
|---|
| 533 | /* SQL_IDENTIFIER_CASE values */
|
|---|
| 534 | Const SQL_IC_UPPER = 1
|
|---|
| 535 | Const SQL_IC_LOWER = 2
|
|---|
| 536 | Const SQL_IC_SENSITIVE = 3
|
|---|
| 537 | Const SQL_IC_MIXED = 4
|
|---|
| 538 |
|
|---|
| 539 | /* SQL_OJ_CAPABILITIES bitmasks */
|
|---|
| 540 | /* NB: this means 'outer join', not what you may be thinking */
|
|---|
| 541 |
|
|---|
| 542 |
|
|---|
| 543 | Const SQL_OJ_LEFT = &H00000001
|
|---|
| 544 | Const SQL_OJ_RIGHT = &H00000002
|
|---|
| 545 | Const SQL_OJ_FULL = &H00000004
|
|---|
| 546 | Const SQL_OJ_NESTED = &H00000008
|
|---|
| 547 | Const SQL_OJ_NOT_ORDERED = &H00000010
|
|---|
| 548 | Const SQL_OJ_INNER = &H00000020
|
|---|
| 549 | Const SQL_OJ_ALL_COMPARISON_OPS = &H00000040
|
|---|
| 550 |
|
|---|
| 551 | /* SQL_SCROLL_CONCURRENCY bitmasks */
|
|---|
| 552 | Const SQL_SCCO_READ_ONLY = &H00000001
|
|---|
| 553 | Const SQL_SCCO_LOCK = &H00000002
|
|---|
| 554 | Const SQL_SCCO_OPT_ROWVER = &H00000004
|
|---|
| 555 | Const SQL_SCCO_OPT_VALUES = &H00000008
|
|---|
| 556 |
|
|---|
| 557 | /* SQL_TXN_CAPABLE values */
|
|---|
| 558 | Const SQL_TC_NONE = 0
|
|---|
| 559 | Const SQL_TC_DML = 1
|
|---|
| 560 | Const SQL_TC_ALL = 2
|
|---|
| 561 | Const SQL_TC_DDL_COMMIT = 3
|
|---|
| 562 | Const SQL_TC_DDL_IGNORE = 4
|
|---|
| 563 |
|
|---|
| 564 | /* SQL_TXN_ISOLATION_OPTION bitmasks */
|
|---|
| 565 | Const SQL_TXN_READ_UNCOMMITTED = &H00000001
|
|---|
| 566 | Const SQL_TRANSACTION_READ_UNCOMMITTED = SQL_TXN_READ_UNCOMMITTED
|
|---|
| 567 | Const SQL_TXN_READ_COMMITTED = &H00000002
|
|---|
| 568 | Const SQL_TRANSACTION_READ_COMMITTED = SQL_TXN_READ_COMMITTED
|
|---|
| 569 | Const SQL_TXN_REPEATABLE_READ = &H00000004
|
|---|
| 570 | Const SQL_TRANSACTION_REPEATABLE_READ = SQL_TXN_REPEATABLE_READ
|
|---|
| 571 | Const SQL_TXN_SERIALIZABLE = &H00000008
|
|---|
| 572 | Const SQL_TRANSACTION_SERIALIZABLE = SQL_TXN_SERIALIZABLE
|
|---|
| 573 |
|
|---|
| 574 | /* SQL_NULL_COLLATION values */
|
|---|
| 575 | Const SQL_NC_HIGH = 0
|
|---|
| 576 | Const SQL_NC_LOW = 1
|
|---|
| 577 |
|
|---|
| 578 |
|
|---|
| 579 | Declare Function SQLAllocConnect Lib "odbc32.dll" (
|
|---|
| 580 | EnvironmentHandle As SQLHENV,
|
|---|
| 581 | ByRef ConnectionHandle As SQLHDBC) As SQLRETURN
|
|---|
| 582 |
|
|---|
| 583 | Declare Function SQLAllocEnv Lib "odbc32.dll" (ByRef EnvironmentHandle As SQLHENV) As SQLRETURN
|
|---|
| 584 |
|
|---|
| 585 | Declare Function SQLAllocHandle Lib "odbc32.dll" (HandleType As SQLSMALLINT,
|
|---|
| 586 | InputHandle As SQLHANDLE, ByRef OutputHandle As SQLHANDLE) As SQLRETURN
|
|---|
| 587 |
|
|---|
| 588 | Declare Function SQLAllocStmt Lib "odbc32.dll" (ConnectionHandle As SQLHDBC,
|
|---|
| 589 | ByRef StatementHandle As SQLHSTMT) As SQLRETURN
|
|---|
| 590 |
|
|---|
| 591 | Declare Function SQLBindCol Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
|
|---|
| 592 | ColumnNumber As SQLUSMALLINT, TargetType As SQLSMALLINT,
|
|---|
| 593 | ByRef TargetValue As Any, BufferLength As SQLLEN,
|
|---|
| 594 | ByRef StrLen_or_Ind As SQLLEN) As SQLRETURN
|
|---|
| 595 |
|
|---|
| 596 | Declare Function SQLBindParam Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
|
|---|
| 597 | ParameterNumber As SQLUSMALLINT, ValueType As SQLSMALLINT,
|
|---|
| 598 | ParameterType As SQLSMALLINT, LengthPrecision As SQLULEN,
|
|---|
| 599 | ParameterScale As SQLSMALLINT, ParameterValue As SQLPOINTER,
|
|---|
| 600 | ByRef StrLen_or_Ind As SQLLEN) As SQLRETURN
|
|---|
| 601 |
|
|---|
| 602 | Declare Function SQLCancel Lib "odbc32.dll" (StatementHandle As SQLHSTMT) As SQLRETURN
|
|---|
| 603 |
|
|---|
| 604 | Declare Function SQLCloseCursor Lib "odbc32.dll" (StatementHandle As SQLHSTMT) As SQLRETURN
|
|---|
| 605 |
|
|---|
| 606 | #ifdef _WIN64
|
|---|
| 607 | Declare Function SQLColAttribute Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
|
|---|
| 608 | ColumnNumber As SQLUSMALLINT, FieldIdentifier As SQLUSMALLINT,
|
|---|
| 609 | CharacterAttribute As SQLPOINTER, BufferLength As SQLSMALLINT,
|
|---|
| 610 | ByRef StringLength As SQLSMALLINT, ByRef NumericAttribute As SQLLEN) As SQLRETURN
|
|---|
| 611 | #else
|
|---|
| 612 | Declare Function SQLColAttribute Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
|
|---|
| 613 | ColumnNumber As SQLUSMALLINT, FieldIdentifier As SQLUSMALLINT,
|
|---|
| 614 | CharacterAttribute As SQLPOINTER, BufferLength As SQLSMALLINT,
|
|---|
| 615 | ByRef StringLength As SQLSMALLINT, NumericAttribute As SQLPOINTER) As SQLRETURN
|
|---|
| 616 | #endif
|
|---|
| 617 |
|
|---|
| 618 |
|
|---|
| 619 | Declare Function SQLColumns Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
|
|---|
| 620 | CatalogName As *SQLCHAR, NameLength1 As SQLSMALLINT,
|
|---|
| 621 | SchemaName As *SQLCHAR, NameLength2 As SQLSMALLINT,
|
|---|
| 622 | TableName As *SQLCHAR, NameLength3 As SQLSMALLINT,
|
|---|
| 623 | ColumnName As *SQLCHAR, NameLength4 As SQLSMALLINT) As SQLRETURN
|
|---|
| 624 |
|
|---|
| 625 |
|
|---|
| 626 | Declare Function SQLConnect Lib "odbc32.dll" (ConnectionHandle As SQLHDBC,
|
|---|
| 627 | ServerName As *SQLCHAR, NameLength1 As SQLSMALLINT,
|
|---|
| 628 | UserName As *SQLCHAR, NameLength2 As SQLSMALLINT,
|
|---|
| 629 | Authentication As *SQLCHAR, NameLength3 As SQLSMALLINT) As SQLRETURN
|
|---|
| 630 |
|
|---|
| 631 | Declare Function SQLCopyDesc Lib "odbc32.dll" (SourceDescHandle As SQLHDESC,
|
|---|
| 632 | TargetDescHandle As SQLHDESC) As SQLRETURN
|
|---|
| 633 |
|
|---|
| 634 | Declare Function SQLDataSources Lib "odbc32.dll" (EnvironmentHandle As SQLHENV,
|
|---|
| 635 | Direction As SQLUSMALLINT, ServerName As *SQLCHAR,
|
|---|
| 636 | BufferLength1 As SQLSMALLINT, ByRef NameLength1 As SQLSMALLINT,
|
|---|
| 637 | Description As *SQLCHAR, BufferLength2 As SQLSMALLINT,
|
|---|
| 638 | ByRef NameLength2 As SQLSMALLINT) As SQLRETURN
|
|---|
| 639 |
|
|---|
| 640 | Declare Function SQLDescribeCol Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
|
|---|
| 641 | ColumnNumber As SQLSMALLINT, ColumnName As *SQLCHAR,
|
|---|
| 642 | BufferLength As SQLSMALLINT, ByRef NameLength As SQLSMALLINT,
|
|---|
| 643 | ByRef DataType As SQLSMALLINT, ByRef ColumnSize As SQLINTEGER,
|
|---|
| 644 | ByRef DecimalDigits As SQLSMALLINT, ByRef Nullable As SQLSMALLINT) As SQLRETURN
|
|---|
| 645 |
|
|---|
| 646 | Declare Function SQLDisconnect Lib "odbc32.dll" (ConnectionHandle As SQLHDBC) As SQLRETURN
|
|---|
| 647 |
|
|---|
| 648 | Declare Function SQLEndTran Lib "odbc32.dll" (HandleType As SQLSMALLINT, Handle As SQLHANDLE,
|
|---|
| 649 | CompletionType As SQLSMALLINT) As SQLRETURN
|
|---|
| 650 |
|
|---|
| 651 | Declare Function SQLError Lib "odbc32.dll" (EnvironmentHandle As SQLHENV,
|
|---|
| 652 | ConnectionHandle As SQLHDBC, StatementHandle As SQLHSTMT,
|
|---|
| 653 | Sqlstate As *SQLCHAR, ByRef NativeError As SQLINTEGER,
|
|---|
| 654 | MessageText As *SQLCHAR, BufferLength As SQLSMALLINT,
|
|---|
| 655 | ByRef TextLength As SQLSMALLINT) As SQLRETURN
|
|---|
| 656 |
|
|---|
| 657 | Declare Function SQLExecDirect Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
|
|---|
| 658 | StatementText As *SQLCHAR, TextLength As SQLINTEGER) As SQLRETURN
|
|---|
| 659 |
|
|---|
| 660 | Declare Function SQLExecute Lib "odbc32.dll" (StatementHandle As SQLHSTMT) As SQLRETURN
|
|---|
| 661 |
|
|---|
| 662 | Declare Function SQLFetch Lib "odbc32.dll" (StatementHandle As SQLHSTMT) As SQLRETURN
|
|---|
| 663 |
|
|---|
| 664 | Declare Function SQLFetchScroll Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
|
|---|
| 665 | FetchOrientation As SQLSMALLINT, FetchOffset As SQLLEN) As SQLRETURN
|
|---|
| 666 |
|
|---|
| 667 | Declare Function SQLFreeConnect Lib "odbc32.dll" (ConnectionHandle As SQLHDBC) As SQLRETURN
|
|---|
| 668 |
|
|---|
| 669 | Declare Function SQLFreeEnv Lib "odbc32.dll" (EnvironmentHandle As SQLHENV) As SQLRETURN
|
|---|
| 670 |
|
|---|
| 671 | Declare Function SQLFreeHandle Lib "odbc32.dll" (HandleType As SQLSMALLINT, Handle As SQLHANDLE) As SQLRETURN
|
|---|
| 672 |
|
|---|
| 673 | Declare Function SQLFreeStmt Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
|
|---|
| 674 | Option As SQLUSMALLINT) As SQLRETURN
|
|---|
| 675 |
|
|---|
| 676 | Declare Function SQLGetConnectAttr Lib "odbc32.dll" (ConnectionHandle As SQLHDBC,
|
|---|
| 677 | Attribute As SQLINTEGER, Value As SQLPOINTER,
|
|---|
| 678 | BufferLength As SQLINTEGER, ByRef StringLength As SQLINTEGER) As SQLRETURN
|
|---|
| 679 |
|
|---|
| 680 | Declare Function SQLGetConnectOption Lib "odbc32.dll" (ConnectionHandle As SQLHDBC,
|
|---|
| 681 | Option As SQLUSMALLINT, Value As SQLPOINTER) As SQLRETURN
|
|---|
| 682 |
|
|---|
| 683 | Declare Function SQLGetCursorName Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
|
|---|
| 684 | CursorName As *SQLCHAR, BufferLength As SQLSMALLINT,
|
|---|
| 685 | ByRef NameLength As SQLSMALLINT) As SQLRETURN
|
|---|
| 686 |
|
|---|
| 687 | Declare Function SQLGetData Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
|
|---|
| 688 | ColumnNumber As SQLUSMALLINT, TargetType As SQLSMALLINT,
|
|---|
| 689 | TargetValue As SQLPOINTER, BufferLength As SQLLEN,
|
|---|
| 690 | ByRef StrLen_or_Ind As SQLLEN) As SQLRETURN
|
|---|
| 691 |
|
|---|
| 692 | Declare Function SQLGetDescField Lib "odbc32.dll" (DescriptorHandle As SQLHDESC,
|
|---|
| 693 | RecNumber As SQLSMALLINT, FieldIdentifier As SQLSMALLINT,
|
|---|
| 694 | Value As SQLPOINTER, BufferLength As SQLINTEGER,
|
|---|
| 695 | ByRef StringLength As SQLINTEGER) As SQLRETURN
|
|---|
| 696 |
|
|---|
| 697 | Declare Function SQLGetDescRec Lib "odbc32.dll" (DescriptorHandle As SQLHDESC,
|
|---|
| 698 | RecNumber As SQLSMALLINT, Name As *SQLCHAR,
|
|---|
| 699 | BufferLength As SQLSMALLINT, ByRef StringLength As SQLSMALLINT,
|
|---|
| 700 | ByRef iType As SQLSMALLINT, ByRef SubType As SQLSMALLINT,
|
|---|
| 701 | ByRef Length As SQLLEN, ByRef Precision As SQLSMALLINT,
|
|---|
| 702 | ByRef Scale As SQLSMALLINT, ByRef Nullable As SQLSMALLINT) As SQLRETURN
|
|---|
| 703 |
|
|---|
| 704 | Declare Function SQLGetDiagField Lib "odbc32.dll" (HandleType As SQLSMALLINT, Handle As SQLHANDLE,
|
|---|
| 705 | RecNumber As SQLSMALLINT, DiagIdentifier As SQLSMALLINT,
|
|---|
| 706 | DiagInfo As SQLPOINTER, BufferLength As SQLSMALLINT,
|
|---|
| 707 | ByRef StringLength As SQLSMALLINT) As SQLRETURN
|
|---|
| 708 |
|
|---|
| 709 | Declare Function SQLGetDiagRec Lib "odbc32.dll" (HandleType As SQLSMALLINT, Handle As SQLHANDLE,
|
|---|
| 710 | RecNumber As SQLSMALLINT, Sqlstate As *SQLCHAR,
|
|---|
| 711 | ByRef NativeError As SQLINTEGER, MessageText As *SQLCHAR,
|
|---|
| 712 | BufferLength As SQLSMALLINT, ByRef TextLength As SQLSMALLINT) As SQLRETURN
|
|---|
| 713 |
|
|---|
| 714 | Declare Function SQLGetEnvAttr Lib "odbc32.dll" (EnvironmentHandle As SQLHENV,
|
|---|
| 715 | Attribute As SQLINTEGER, Value As SQLPOINTER,
|
|---|
| 716 | BufferLength As SQLINTEGER, ByRef StringLength As SQLINTEGER) As SQLRETURN
|
|---|
| 717 |
|
|---|
| 718 | Declare Function SQLGetFunctions Lib "odbc32.dll" (ConnectionHandle As SQLHDBC,
|
|---|
| 719 | FunctionId As SQLUSMALLINT, ByRef Supported As SQLUSMALLINT) As SQLRETURN
|
|---|
| 720 |
|
|---|
| 721 | Declare Function SQLGetInfo Lib "odbc32.dll" (ConnectionHandle As SQLHDBC,
|
|---|
| 722 | InfoType As SQLUSMALLINT, InfoValue As SQLPOINTER,
|
|---|
| 723 | BufferLength As SQLSMALLINT, ByRef StringLength As SQLSMALLINT) As SQLRETURN
|
|---|
| 724 |
|
|---|
| 725 | Declare Function SQLGetStmtAttr Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
|
|---|
| 726 | Attribute As SQLINTEGER, Value As SQLPOINTER,
|
|---|
| 727 | BufferLength As SQLINTEGER, ByRef StringLength As SQLINTEGER) As SQLRETURN
|
|---|
| 728 |
|
|---|
| 729 | Declare Function SQLGetStmtOption Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
|
|---|
| 730 | Option As SQLUSMALLINT, Value As SQLPOINTER) As SQLRETURN
|
|---|
| 731 |
|
|---|
| 732 | Declare Function SQLGetTypeInfo Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
|
|---|
| 733 | DataType As SQLSMALLINT) As SQLRETURN
|
|---|
| 734 |
|
|---|
| 735 | Declare Function SQLNumResultCols Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
|
|---|
| 736 | ByRef ColumnCount As SQLSMALLINT) As SQLRETURN
|
|---|
| 737 |
|
|---|
| 738 | Declare Function SQLParamData Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
|
|---|
| 739 | ByRef Value As SQLPOINTER) As SQLRETURN
|
|---|
| 740 |
|
|---|
| 741 | Declare Function SQLPrepare Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
|
|---|
| 742 | StatementText As *SQLCHAR, TextLength As SQLINTEGER) As SQLRETURN
|
|---|
| 743 |
|
|---|
| 744 | Declare Function SQLPutData Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
|
|---|
| 745 | Data As SQLPOINTER, StrLen_or_Ind As SQLLEN) As SQLRETURN
|
|---|
| 746 |
|
|---|
| 747 | Declare Function SQLRowCount Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
|
|---|
| 748 | ByRef RowCount As SQLLEN) As SQLRETURN
|
|---|
| 749 |
|
|---|
| 750 | Declare Function SQLSetConnectAttr Lib "odbc32.dll" (ConnectionHandle As SQLHDBC,
|
|---|
| 751 | Attribute As SQLINTEGER, Value As SQLPOINTER,
|
|---|
| 752 | StringLength As SQLINTEGER) As SQLRETURN
|
|---|
| 753 |
|
|---|
| 754 | Declare Function SQLSetConnectOption Lib "odbc32.dll" (ConnectionHandle As SQLHDBC,
|
|---|
| 755 | Option As SQLUSMALLINT, Value As SQLULEN) As SQLRETURN
|
|---|
| 756 |
|
|---|
| 757 | Declare Function SQLSetCursorName Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
|
|---|
| 758 | CursorName As *SQLCHAR, NameLength As SQLSMALLINT) As SQLRETURN
|
|---|
| 759 |
|
|---|
| 760 | Declare Function SQLSetDescField Lib "odbc32.dll" (DescriptorHandle As SQLHDESC,
|
|---|
| 761 | RecNumber As SQLSMALLINT, FieldIdentifier As SQLSMALLINT,
|
|---|
| 762 | Value As SQLPOINTER, BufferLength As SQLINTEGER) As SQLRETURN
|
|---|
| 763 |
|
|---|
| 764 | Declare Function SQLSetDescRec Lib "odbc32.dll" (DescriptorHandle As SQLHDESC,
|
|---|
| 765 | RecNumber As SQLSMALLINT, iType As SQLSMALLINT,
|
|---|
| 766 | SubType As SQLSMALLINT, Length As SQLLEN,
|
|---|
| 767 | Precision As SQLSMALLINT, Scale As SQLSMALLINT,
|
|---|
| 768 | Data As SQLPOINTER, ByRef StringLength As SQLLEN,
|
|---|
| 769 | ByRef Indicator As SQLLEN) As SQLRETURN
|
|---|
| 770 |
|
|---|
| 771 | Declare Function SQLSetEnvAttr Lib "odbc32.dll" (EnvironmentHandle As SQLHENV,
|
|---|
| 772 | Attribute As SQLINTEGER, Value As SQLPOINTER,
|
|---|
| 773 | StringLength As SQLINTEGER) As SQLRETURN
|
|---|
| 774 |
|
|---|
| 775 | Declare Function SQLSetParam Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
|
|---|
| 776 | ParameterNumber As SQLUSMALLINT, ValueType As SQLSMALLINT,
|
|---|
| 777 | ParameterType As SQLSMALLINT, LengthPrecision As SQLULEN,
|
|---|
| 778 | ParameterScale As SQLSMALLINT, ParameterValue As SQLPOINTER,
|
|---|
| 779 | ByRef StrLen_or_Ind As SQLLEN) As SQLRETURN
|
|---|
| 780 |
|
|---|
| 781 | Declare Function SQLSetStmtAttr Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
|
|---|
| 782 | Attribute As SQLINTEGER, Value As SQLPOINTER,
|
|---|
| 783 | StringLength As SQLINTEGER) As SQLRETURN
|
|---|
| 784 |
|
|---|
| 785 | Declare Function SQLSetStmtOption Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
|
|---|
| 786 | Option As SQLUSMALLINT, Value As SQLULEN) As SQLRETURN
|
|---|
| 787 |
|
|---|
| 788 | Declare Function SQLSpecialColumns Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
|
|---|
| 789 | IdentifierType As SQLUSMALLINT, CatalogName As *SQLCHAR,
|
|---|
| 790 | NameLength1 As SQLSMALLINT, SchemaName As *SQLCHAR,
|
|---|
| 791 | NameLength2 As SQLSMALLINT, TableName As *SQLCHAR,
|
|---|
| 792 | NameLength3 As SQLSMALLINT, Scope As SQLUSMALLINT,
|
|---|
| 793 | Nullable As SQLUSMALLINT) As SQLRETURN
|
|---|
| 794 |
|
|---|
| 795 | Declare Function SQLStatistics Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
|
|---|
| 796 | CatalogName As *SQLCHAR, NameLength1 As SQLSMALLINT,
|
|---|
| 797 | SchemaName As *SQLCHAR, NameLength2 As SQLSMALLINT,
|
|---|
| 798 | TableName As *SQLCHAR, NameLength3 As SQLSMALLINT,
|
|---|
| 799 | Unique As SQLUSMALLINT, Reserved As SQLUSMALLINT) As SQLRETURN
|
|---|
| 800 |
|
|---|
| 801 | Declare Function SQLTables Lib "odbc32.dll" (StatementHandle As SQLHSTMT,
|
|---|
| 802 | CatalogName As *SQLCHAR, NameLength1 As SQLSMALLINT,
|
|---|
| 803 | SchemaName As *SQLCHAR, NameLength2 As SQLSMALLINT,
|
|---|
| 804 | TableName As *SQLCHAR, NameLength3 As SQLSMALLINT,
|
|---|
| 805 | TableType As *SQLCHAR, NameLength4 As SQLSMALLINT) As SQLRETURN
|
|---|
| 806 |
|
|---|
| 807 | Declare Function SQLTransact Lib "odbc32.dll" (EnvironmentHandle As SQLHENV,
|
|---|
| 808 | ConnectionHandle As SQLHDBC, CompletionType As SQLUSMALLINT) As SQLRETURN
|
|---|
| 809 |
|
|---|
| 810 |
|
|---|
| 811 | #endif '_INC_SQL
|
|---|
