Types

TSqlChar* = char
TSqlSmallInt* = int16
TSqlUSmallInt* = int16
TSqlHandle* = pointer
TSqlHEnv* = TSqlHandle
TSqlHDBC* = TSqlHandle
TSqlHStmt* = TSqlHandle
TSqlHDesc* = TSqlHandle
TSqlInteger* = int
TSqlUInteger* = int
TSqlPointer* = pointer
TSqlReal* = cfloat
TSqlDouble* = cdouble
TSqlFloat* = cdouble
TSqlHWND* = pointer
PSQLCHAR* = cstring
PSQLINTEGER* = ptr TSqlInteger
PSQLUINTEGER* = ptr TSqlUInteger
PSQLSMALLINT* = ptr TSqlSmallInt
PSQLUSMALLINT* = ptr TSqlUSmallInt
PSQLREAL* = ptr TSqlReal
PSQLDOUBLE* = ptr TSqlDouble
PSQLFLOAT* = ptr TSqlFloat
PSQLHANDLE* = ptr TSqlHandle
SQL_DATE_STRUCT* {.final, pure.} = object Year*: TSqlSmallInt Month*: TSqlUSmallInt Day*: TSqlUSmallInt
PSQL_DATE_STRUCT* = ptr SQL_DATE_STRUCT
SQL_TIME_STRUCT* {.final, pure.} = object Hour*: TSqlUSmallInt Minute*: TSqlUSmallInt Second*: TSqlUSmallInt
PSQL_TIME_STRUCT* = ptr SQL_TIME_STRUCT
SQL_TIMESTAMP_STRUCT* {.final, pure.} = object Year*: TSqlUSmallInt Month*: TSqlUSmallInt Day*: TSqlUSmallInt Hour*: TSqlUSmallInt Minute*: TSqlUSmallInt Second*: TSqlUSmallInt Fraction*: TSqlUInteger
PSQL_TIMESTAMP_STRUCT* = ptr SQL_TIMESTAMP_STRUCT

Consts

SQL_UNKNOWN_TYPE* = 0
SQL_LONGVARCHAR* = (- 1)
SQL_BINARY* = (- 2)
SQL_VARBINARY* = (- 3)
SQL_LONGVARBINARY* = (- 4)
SQL_BIGINT* = (- 5)
SQL_TINYINT* = (- 6)
SQL_BIT* = (- 7)
SQL_WCHAR* = (- 8)
SQL_WVARCHAR* = (- 9)
SQL_WLONGVARCHAR* = (- 10)
SQL_CHAR* = 1
SQL_NUMERIC* = 2
SQL_DECIMAL* = 3
SQL_INTEGER* = 4
SQL_SMALLINT* = 5
SQL_FLOAT* = 6
SQL_REAL* = 7
SQL_DOUBLE* = 8
SQL_DATETIME* = 9
SQL_VARCHAR* = 12
SQL_TYPE_DATE* = 91
SQL_TYPE_TIME* = 92
SQL_TYPE_TIMESTAMP* = 93
SQL_DATE* = 9
SQL_TIME* = 10
SQL_TIMESTAMP* = 11
SQL_INTERVAL* = 10
SQL_GUID* = - 11
SQL_CODE_YEAR* = 1
SQL_CODE_MONTH* = 2
SQL_CODE_DAY* = 3
SQL_CODE_HOUR* = 4
SQL_CODE_MINUTE* = 5
SQL_CODE_SECOND* = 6
SQL_CODE_YEAR_TO_MONTH* = 7
SQL_CODE_DAY_TO_HOUR* = 8
SQL_CODE_DAY_TO_MINUTE* = 9
SQL_CODE_DAY_TO_SECOND* = 10
SQL_CODE_HOUR_TO_MINUTE* = 11
SQL_CODE_HOUR_TO_SECOND* = 12
SQL_CODE_MINUTE_TO_SECOND* = 13
SQL_INTERVAL_YEAR* = 100 + SQL_CODE_YEAR
SQL_INTERVAL_MONTH* = 100 + SQL_CODE_MONTH
SQL_INTERVAL_DAY* = 100 + SQL_CODE_DAY
SQL_INTERVAL_HOUR* = 100 + SQL_CODE_HOUR
SQL_INTERVAL_MINUTE* = 100 + SQL_CODE_MINUTE
SQL_INTERVAL_SECOND* = 100 + SQL_CODE_SECOND
SQL_INTERVAL_YEAR_TO_MONTH* = 100 + SQL_CODE_YEAR_TO_MONTH
SQL_INTERVAL_DAY_TO_HOUR* = 100 + SQL_CODE_DAY_TO_HOUR
SQL_INTERVAL_DAY_TO_MINUTE* = 100 + SQL_CODE_DAY_TO_MINUTE
SQL_INTERVAL_DAY_TO_SECOND* = 100 + SQL_CODE_DAY_TO_SECOND
SQL_INTERVAL_HOUR_TO_MINUTE* = 100 + SQL_CODE_HOUR_TO_MINUTE
SQL_INTERVAL_HOUR_TO_SECOND* = 100 + SQL_CODE_HOUR_TO_SECOND
SQL_INTERVAL_MINUTE_TO_SECOND* = 100 + SQL_CODE_MINUTE_TO_SECOND
SQL_UNICODE* = - 95
SQL_UNICODE_VARCHAR* = - 96
SQL_UNICODE_LONGVARCHAR* = - 97
SQL_UNICODE_CHAR* = SQL_UNICODE
SQL_C_CHAR* = SQL_CHAR
SQL_C_LONG* = SQL_INTEGER
SQL_C_SHORT* = SQL_SMALLINT
SQL_C_FLOAT* = SQL_REAL
SQL_C_DOUBLE* = SQL_DOUBLE
SQL_C_NUMERIC* = SQL_NUMERIC
SQL_C_DEFAULT* = 99
SQL_SIGNED_OFFSET* = - 20
SQL_UNSIGNED_OFFSET* = - 22
SQL_C_DATE* = SQL_DATE
SQL_C_TIME* = SQL_TIME
SQL_C_TIMESTAMP* = SQL_TIMESTAMP
SQL_C_TYPE_DATE* = SQL_TYPE_DATE
SQL_C_TYPE_TIME* = SQL_TYPE_TIME
SQL_C_TYPE_TIMESTAMP* = SQL_TYPE_TIMESTAMP
SQL_C_INTERVAL_YEAR* = SQL_INTERVAL_YEAR
SQL_C_INTERVAL_MONTH* = SQL_INTERVAL_MONTH
SQL_C_INTERVAL_DAY* = SQL_INTERVAL_DAY
SQL_C_INTERVAL_HOUR* = SQL_INTERVAL_HOUR
SQL_C_INTERVAL_MINUTE* = SQL_INTERVAL_MINUTE
SQL_C_INTERVAL_SECOND* = SQL_INTERVAL_SECOND
SQL_C_INTERVAL_YEAR_TO_MONTH* = SQL_INTERVAL_YEAR_TO_MONTH
SQL_C_INTERVAL_DAY_TO_HOUR* = SQL_INTERVAL_DAY_TO_HOUR
SQL_C_INTERVAL_DAY_TO_MINUTE* = SQL_INTERVAL_DAY_TO_MINUTE
SQL_C_INTERVAL_DAY_TO_SECOND* = SQL_INTERVAL_DAY_TO_SECOND
SQL_C_INTERVAL_HOUR_TO_MINUTE* = SQL_INTERVAL_HOUR_TO_MINUTE
SQL_C_INTERVAL_HOUR_TO_SECOND* = SQL_INTERVAL_HOUR_TO_SECOND
SQL_C_INTERVAL_MINUTE_TO_SECOND* = SQL_INTERVAL_MINUTE_TO_SECOND
SQL_C_BINARY* = SQL_BINARY
SQL_C_BIT* = SQL_BIT
SQL_C_SBIGINT* = SQL_BIGINT + SQL_SIGNED_OFFSET
SQL_C_UBIGINT* = SQL_BIGINT + SQL_UNSIGNED_OFFSET
SQL_C_TINYINT* = SQL_TINYINT
SQL_C_SLONG* = SQL_C_LONG + SQL_SIGNED_OFFSET
SQL_C_SSHORT* = SQL_C_SHORT + SQL_SIGNED_OFFSET
SQL_C_STINYINT* = SQL_TINYINT + SQL_SIGNED_OFFSET
SQL_C_ULONG* = SQL_C_LONG + SQL_UNSIGNED_OFFSET
SQL_C_USHORT* = SQL_C_SHORT + SQL_UNSIGNED_OFFSET
SQL_C_UTINYINT* = SQL_TINYINT + SQL_UNSIGNED_OFFSET
SQL_C_BOOKMARK* = SQL_C_ULONG
SQL_C_GUID* = SQL_GUID
SQL_TYPE_NULL* = 0
SQL_TYPE_MIN* = SQL_BIT
SQL_TYPE_MAX* = SQL_VARCHAR
SQL_C_VARBOOKMARK* = SQL_C_BINARY
SQL_API_SQLDESCRIBEPARAM* = 58
SQL_NO_TOTAL* = - 4
SQL_NAME_LEN* = 128
SQL_OV_ODBC3* = 3
SQL_OV_ODBC2* = 2
SQL_ATTR_ODBC_VERSION* = 200
SQL_DRIVER_NOPROMPT* = 0
SQL_DRIVER_COMPLETE* = 1
SQL_DRIVER_PROMPT* = 2
SQL_DRIVER_COMPLETE_REQUIRED* = 3
SQL_IS_POINTER* = (- 4)
SQL_IS_UINTEGER* = (- 5)
SQL_IS_INTEGER* = (- 6)
SQL_IS_USMALLINT* = (- 7)
SQL_IS_SMALLINT* = (- 8)
SQL_FETCH_BOOKMARK* = 8
SQL_SCROLL_OPTIONS* = 44
SQL_UB_OFF* = 0
SQL_UB_ON* = 1
SQL_UB_DEFAULT* = SQL_UB_OFF
SQL_UB_FIXED* = SQL_UB_ON
SQL_UB_VARIABLE* = 2
SQL_SO_FORWARD_ONLY* = 0x00000001
SQL_SO_KEYSET_DRIVEN* = 0x00000002
SQL_SO_DYNAMIC* = 0x00000004
SQL_SO_MIXED* = 0x00000008
SQL_SO_STATIC* = 0x00000010
SQL_BOOKMARK_PERSISTENCE* = 82
SQL_STATIC_SENSITIVITY* = 83
SQL_BP_CLOSE* = 0x00000001
SQL_BP_DELETE* = 0x00000002
SQL_BP_DROP* = 0x00000004
SQL_BP_TRANSACTION* = 0x00000008
SQL_BP_UPDATE* = 0x00000010
SQL_BP_OTHER_HSTMT* = 0x00000020
SQL_BP_SCROLL* = 0x00000040
SQL_DYNAMIC_CURSOR_ATTRIBUTES1* = 144
SQL_DYNAMIC_CURSOR_ATTRIBUTES2* = 145
SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1* = 146
SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2* = 147
SQL_INDEX_KEYWORDS* = 148
SQL_INFO_SCHEMA_VIEWS* = 149
SQL_KEYSET_CURSOR_ATTRIBUTES1* = 150
SQL_KEYSET_CURSOR_ATTRIBUTES2* = 151
SQL_STATIC_CURSOR_ATTRIBUTES1* = 167
SQL_STATIC_CURSOR_ATTRIBUTES2* = 168
SQL_CA1_NEXT* = 1
SQL_CA1_ABSOLUTE* = 2
SQL_CA1_RELATIVE* = 4
SQL_CA1_BOOKMARK* = 8
SQL_CA1_LOCK_NO_CHANGE* = 0x00000040
SQL_CA1_LOCK_EXCLUSIVE* = 0x00000080
SQL_CA1_LOCK_UNLOCK* = 0x00000100
SQL_CA1_POS_POSITION* = 0x00000200
SQL_CA1_POS_UPDATE* = 0x00000400
SQL_CA1_POS_DELETE* = 0x00000800
SQL_CA1_POS_REFRESH* = 0x00001000
SQL_CA1_POSITIONED_UPDATE* = 0x00002000
SQL_CA1_POSITIONED_DELETE* = 0x00004000
SQL_CA1_SELECT_FOR_UPDATE* = 0x00008000
SQL_CA1_BULK_ADD* = 0x00010000
SQL_CA1_BULK_UPDATE_BY_BOOKMARK* = 0x00020000
SQL_CA1_BULK_DELETE_BY_BOOKMARK* = 0x00040000
SQL_CA1_BULK_FETCH_BY_BOOKMARK* = 0x00080000
SQL_CA2_READ_ONLY_CONCURRENCY* = 1
SQL_CA2_LOCK_CONCURRENCY* = 2
SQL_CA2_OPT_ROWVER_CONCURRENCY* = 4
SQL_CA2_OPT_VALUES_CONCURRENCY* = 8
SQL_CA2_SENSITIVITY_ADDITIONS* = 0x00000010
SQL_CA2_SENSITIVITY_DELETIONS* = 0x00000020
SQL_CA2_SENSITIVITY_UPDATES* = 0x00000040
SQL_CA2_MAX_ROWS_SELECT* = 0x00000080
SQL_CA2_MAX_ROWS_INSERT* = 0x00000100
SQL_CA2_MAX_ROWS_DELETE* = 0x00000200
SQL_CA2_MAX_ROWS_UPDATE* = 0x00000400
SQL_CA2_MAX_ROWS_CATALOG* = 0x00000800
SQL_CA2_MAX_ROWS_AFFECTS_ALL* = (SQL_CA2_MAX_ROWS_SELECT or SQL_CA2_MAX_ROWS_INSERT or SQL_CA2_MAX_ROWS_DELETE or SQL_CA2_MAX_ROWS_UPDATE or SQL_CA2_MAX_ROWS_CATALOG)
SQL_CA2_CRC_EXACT* = 0x00001000
SQL_CA2_CRC_APPROXIMATE* = 0x00002000
SQL_CA2_SIMULATE_NON_UNIQUE* = 0x00004000
SQL_CA2_SIMULATE_TRY_UNIQUE* = 0x00008000
SQL_CA2_SIMULATE_UNIQUE* = 0x00010000
SQL_ADD* = 4
SQL_SETPOS_MAX_OPTION_VALUE* = SQL_ADD
SQL_UPDATE_BY_BOOKMARK* = 5
SQL_DELETE_BY_BOOKMARK* = 6
SQL_FETCH_BY_BOOKMARK* = 7
SQL_POSITION* = 0
SQL_REFRESH* = 1
SQL_UPDATE* = 2
SQL_DELETE* = 3
SQL_LOCK_NO_CHANGE* = 0
SQL_LOCK_EXCLUSIVE* = 1
SQL_LOCK_UNLOCK* = 2
SQL_ROW_SUCCESS* = 0
SQL_ROW_DELETED* = 1
SQL_ROW_UPDATED* = 2
SQL_ROW_NOROW* = 3
SQL_ROW_ADDED* = 4
SQL_ROW_ERROR* = 5
SQL_ROW_SUCCESS_WITH_INFO* = 6
SQL_ROW_PROCEED* = 0
SQL_ROW_IGNORE* = 1
SQL_MAX_DSN_LENGTH* = 32
SQL_MAX_OPTION_STRING_LENGTH* = 256
SQL_ODBC_CURSORS* = 110
SQL_ATTR_ODBC_CURSORS* = SQL_ODBC_CURSORS
SQL_CUR_USE_IF_NEEDED* = 0
SQL_CUR_USE_ODBC* = 1
SQL_CUR_USE_DRIVER* = 2
SQL_CUR_DEFAULT* = SQL_CUR_USE_DRIVER
SQL_PARAM_TYPE_UNKNOWN* = 0
SQL_PARAM_INPUT* = 1
SQL_PARAM_INPUT_OUTPUT* = 2
SQL_RESULT_COL* = 3
SQL_PARAM_OUTPUT* = 4
SQL_RETURN_VALUE* = 5
SQL_NULL_DATA* = (- 1)
SQL_DATA_AT_EXEC* = (- 2)
SQL_SUCCESS* = 0
SQL_SUCCESS_WITH_INFO* = 1
SQL_NO_DATA* = 100
SQL_ERROR* = (- 1)
SQL_INVALID_HANDLE* = (- 2)
SQL_STILL_EXECUTING* = 2
SQL_NEED_DATA* = 99
SQL_NTS* = (- 3)
SQL_MAX_MESSAGE_LENGTH* = 512
SQL_DATE_LEN* = 10
SQL_TIME_LEN* = 8
SQL_TIMESTAMP_LEN* = 19
SQL_HANDLE_ENV* = 1
SQL_HANDLE_DBC* = 2
SQL_HANDLE_STMT* = 3
SQL_HANDLE_DESC* = 4
SQL_ATTR_OUTPUT_NTS* = 10001
SQL_ATTR_AUTO_IPD* = 10001
SQL_ATTR_METADATA_ID* = 10014
SQL_ATTR_APP_ROW_DESC* = 10010
SQL_ATTR_APP_PARAM_DESC* = 10011
SQL_ATTR_IMP_ROW_DESC* = 10012
SQL_ATTR_IMP_PARAM_DESC* = 10013
SQL_ATTR_CURSOR_SCROLLABLE* = (- 1)
SQL_ATTR_CURSOR_SENSITIVITY* = (- 2)
SQL_QUERY_TIMEOUT* = 0
SQL_MAX_ROWS* = 1
SQL_NOSCAN* = 2
SQL_MAX_LENGTH* = 3
SQL_ASYNC_ENABLE* = 4
SQL_BIND_TYPE* = 5
SQL_CURSOR_TYPE* = 6
SQL_CONCURRENCY* = 7
SQL_KEYSET_SIZE* = 8
SQL_ROWSET_SIZE* = 9
SQL_SIMULATE_CURSOR* = 10
SQL_RETRIEVE_DATA* = 11
SQL_USE_BOOKMARKS* = 12
SQL_GET_BOOKMARK* = 13
SQL_ROW_NUMBER* = 14
SQL_ATTR_CURSOR_TYPE* = SQL_CURSOR_TYPE
SQL_ATTR_CONCURRENCY* = SQL_CONCURRENCY
SQL_ATTR_FETCH_BOOKMARK_PTR* = 16
SQL_ATTR_ROW_STATUS_PTR* = 25
SQL_ATTR_ROWS_FETCHED_PTR* = 26
SQL_AUTOCOMMIT* = 102
SQL_ATTR_AUTOCOMMIT* = SQL_AUTOCOMMIT
SQL_ATTR_ROW_NUMBER* = SQL_ROW_NUMBER
SQL_TXN_ISOLATION* = 108
SQL_ATTR_TXN_ISOLATION* = SQL_TXN_ISOLATION
SQL_ATTR_MAX_ROWS* = SQL_MAX_ROWS
SQL_ATTR_USE_BOOKMARKS* = SQL_USE_BOOKMARKS
SQL_ACCESS_MODE* = 101
SQL_LOGIN_TIMEOUT* = 103
SQL_OPT_TRACE* = 104
SQL_OPT_TRACEFILE* = 105
SQL_TRANSLATE_DLL* = 106
SQL_TRANSLATE_OPTION* = 107
SQL_CURRENT_QUALIFIER* = 109
SQL_QUIET_MODE* = 111
SQL_PACKET_SIZE* = 112
SQL_ATTR_ACCESS_MODE* = SQL_ACCESS_MODE
SQL_ATTR_CONNECTION_DEAD* = 1209
SQL_ATTR_CONNECTION_TIMEOUT* = 113
SQL_ATTR_CURRENT_CATALOG* = SQL_CURRENT_QUALIFIER
SQL_ATTR_DISCONNECT_BEHAVIOR* = 114
SQL_ATTR_ENLIST_IN_DTC* = 1207
SQL_ATTR_ENLIST_IN_XA* = 1208
SQL_ATTR_LOGIN_TIMEOUT* = SQL_LOGIN_TIMEOUT
SQL_ATTR_PACKET_SIZE* = SQL_PACKET_SIZE
SQL_ATTR_QUIET_MODE* = SQL_QUIET_MODE
SQL_ATTR_TRACE* = SQL_OPT_TRACE
SQL_ATTR_TRACEFILE* = SQL_OPT_TRACEFILE
SQL_ATTR_TRANSLATE_LIB* = SQL_TRANSLATE_DLL
SQL_ATTR_TRANSLATE_OPTION* = SQL_TRANSLATE_OPTION
SQL_MODE_READ_WRITE* = 0
SQL_MODE_READ_ONLY* = 1
SQL_MODE_DEFAULT* = SQL_MODE_READ_WRITE
SQL_AUTOCOMMIT_OFF* = 0
SQL_AUTOCOMMIT_ON* = 1
SQL_AUTOCOMMIT_DEFAULT* = SQL_AUTOCOMMIT_ON
SQL_NONSCROLLABLE* = 0
SQL_SCROLLABLE* = 1
SQL_CURSOR_FORWARD_ONLY* = 0
SQL_CURSOR_KEYSET_DRIVEN* = 1
SQL_CURSOR_DYNAMIC* = 2
SQL_CURSOR_STATIC* = 3
SQL_CURSOR_TYPE_DEFAULT* = SQL_CURSOR_FORWARD_ONLY
SQL_CONCUR_READ_ONLY* = 1
SQL_CONCUR_LOCK* = 2
SQL_CONCUR_ROWVER* = 3
SQL_CONCUR_VALUES* = 4
SQL_CONCUR_DEFAULT* = SQL_CONCUR_READ_ONLY
SQL_DESC_COUNT* = 1001
SQL_DESC_TYPE* = 1002
SQL_DESC_LENGTH* = 1003
SQL_DESC_OCTET_LENGTH_PTR* = 1004
SQL_DESC_PRECISION* = 1005
SQL_DESC_SCALE* = 1006
SQL_DESC_DATETIME_INTERVAL_CODE* = 1007
SQL_DESC_NULLABLE* = 1008
SQL_DESC_INDICATOR_PTR* = 1009
SQL_DESC_DATA_PTR* = 1010
SQL_DESC_NAME* = 1011
SQL_DESC_UNNAMED* = 1012
SQL_DESC_OCTET_LENGTH* = 1013
SQL_DESC_ALLOC_TYPE* = 1099
SQL_DIAG_RETURNCODE* = 1
SQL_DIAG_NUMBER* = 2
SQL_DIAG_ROW_COUNT* = 3
SQL_DIAG_SQLSTATE* = 4
SQL_DIAG_NATIVE* = 5
SQL_DIAG_MESSAGE_TEXT* = 6
SQL_DIAG_DYNAMIC_FUNCTION* = 7
SQL_DIAG_CLASS_ORIGIN* = 8
SQL_DIAG_SUBCLASS_ORIGIN* = 9
SQL_DIAG_CONNECTION_NAME* = 10
SQL_DIAG_SERVER_NAME* = 11
SQL_DIAG_DYNAMIC_FUNCTION_CODE* = 12
SQL_DIAG_ALTER_TABLE* = 4
SQL_DIAG_CREATE_INDEX* = (- 1)
SQL_DIAG_CREATE_TABLE* = 77
SQL_DIAG_CREATE_VIEW* = 84
SQL_DIAG_DELETE_WHERE* = 19
SQL_DIAG_DROP_INDEX* = (- 2)
SQL_DIAG_DROP_TABLE* = 32
SQL_DIAG_DROP_VIEW* = 36
SQL_DIAG_DYNAMIC_DELETE_CURSOR* = 38
SQL_DIAG_DYNAMIC_UPDATE_CURSOR* = 81
SQL_DIAG_GRANT* = 48
SQL_DIAG_INSERT* = 50
SQL_DIAG_REVOKE* = 59
SQL_DIAG_SELECT_CURSOR* = 85
SQL_DIAG_UNKNOWN_STATEMENT* = 0
SQL_DIAG_UPDATE_WHERE* = 82
SQL_UNSPECIFIED* = 0
SQL_INSENSITIVE* = 1
SQL_SENSITIVE* = 2
SQL_ALL_TYPES* = 0
SQL_DEFAULT* = 99
SQL_ARD_TYPE* = (- 99)
SQL_CODE_DATE* = 1
SQL_CODE_TIME* = 2
SQL_CODE_TIMESTAMP* = 3
SQL_FALSE* = 0
SQL_TRUE* = 1
SQL_NO_NULLS* = 0
SQL_NULLABLE* = 1
SQL_NULLABLE_UNKNOWN* = 2
SQL_CLOSE* = 0
SQL_DROP* = 1
SQL_UNBIND* = 2
SQL_RESET_PARAMS* = 3
SQL_FETCH_NEXT* = 1
SQL_FETCH_FIRST* = 2
SQL_FETCH_FIRST_USER* = 31
SQL_FETCH_FIRST_SYSTEM* = 32
SQL_FETCH_LAST* = 3
SQL_FETCH_PRIOR* = 4
SQL_FETCH_ABSOLUTE* = 5
SQL_FETCH_RELATIVE* = 6
SQL_NULL_HENV* = TSqlHEnv(nil)
SQL_NULL_HDBC* = TSqlHDBC(nil)
SQL_NULL_HSTMT* = TSqlHStmt(nil)
SQL_NULL_HDESC* = TSqlHDesc(nil)
SQL_NULL_HANDLE* = TSqlHandle(nil)
SQL_SCOPE_CURROW* = 0
SQL_SCOPE_TRANSACTION* = 1
SQL_SCOPE_SESSION* = 2
SQL_BEST_ROWID* = 1
SQL_ROWVER* = 2
SQL_ROW_IDENTIFIER* = 1
SQL_INDEX_UNIQUE* = 0
SQL_INDEX_ALL* = 1
SQL_QUICK* = 0
SQL_ENSURE* = 1
SQL_TABLE_STAT* = 0
SQL_INDEX_CLUSTERED* = 1
SQL_INDEX_HASHED* = 2
SQL_INDEX_OTHER* = 3
SQL_SCROLL_CONCURRENCY* = 43
SQL_TXN_CAPABLE* = 46
SQL_TRANSACTION_CAPABLE* = SQL_TXN_CAPABLE
SQL_USER_NAME* = 47
SQL_TXN_ISOLATION_OPTION* = 72
SQL_TRANSACTION_ISOLATION_OPTION* = SQL_TXN_ISOLATION_OPTION
SQL_OJ_CAPABILITIES* = 115
SQL_OUTER_JOIN_CAPABILITIES* = SQL_OJ_CAPABILITIES
SQL_XOPEN_CLI_YEAR* = 10000
SQL_CURSOR_SENSITIVITY* = 10001
SQL_DESCRIBE_PARAMETER* = 10002
SQL_CATALOG_NAME* = 10003
SQL_COLLATION_SEQ* = 10004
SQL_MAX_IDENTIFIER_LEN* = 10005
SQL_MAXIMUM_IDENTIFIER_LENGTH* = SQL_MAX_IDENTIFIER_LEN
SQL_SCCO_READ_ONLY* = 1
SQL_SCCO_LOCK* = 2
SQL_SCCO_OPT_ROWVER* = 4
SQL_SCCO_OPT_VALUES* = 8
SQL_TC_NONE* = 0
SQL_TC_DML* = 1
SQL_TC_ALL* = 2
SQL_TC_DDL_COMMIT* = 3
SQL_TC_DDL_IGNORE* = 4
SQL_TXN_READ_UNCOMMITTED* = 1
SQL_TRANSACTION_READ_UNCOMMITTED* = SQL_TXN_READ_UNCOMMITTED
SQL_TXN_READ_COMMITTED* = 2
SQL_TRANSACTION_READ_COMMITTED* = SQL_TXN_READ_COMMITTED
SQL_TXN_REPEATABLE_READ* = 4
SQL_TRANSACTION_REPEATABLE_READ* = SQL_TXN_REPEATABLE_READ
SQL_TXN_SERIALIZABLE* = 8
SQL_TRANSACTION_SERIALIZABLE* = SQL_TXN_SERIALIZABLE
SQL_SS_ADDITIONS* = 1
SQL_SS_DELETIONS* = 2
SQL_SS_UPDATES* = 4
SQL_COLUMN_COUNT* = 0
SQL_COLUMN_NAME* = 1
SQL_COLUMN_TYPE* = 2
SQL_COLUMN_LENGTH* = 3
SQL_COLUMN_PRECISION* = 4
SQL_COLUMN_SCALE* = 5
SQL_COLUMN_DISPLAY_SIZE* = 6
SQL_COLUMN_NULLABLE* = 7
SQL_COLUMN_UNSIGNED* = 8
SQL_COLUMN_MONEY* = 9
SQL_COLUMN_UPDATABLE* = 10
SQL_COLUMN_AUTO_INCREMENT* = 11
SQL_COLUMN_CASE_SENSITIVE* = 12
SQL_COLUMN_SEARCHABLE* = 13
SQL_COLUMN_TYPE_NAME* = 14
SQL_COLUMN_TABLE_NAME* = 15
SQL_COLUMN_OWNER_NAME* = 16
SQL_COLUMN_QUALIFIER_NAME* = 17
SQL_COLUMN_LABEL* = 18
SQL_COLATT_OPT_MAX* = SQL_COLUMN_LABEL
SQL_COLUMN_DRIVER_START* = 1000
SQL_DESC_ARRAY_SIZE* = 20
SQL_DESC_ARRAY_STATUS_PTR* = 21
SQL_DESC_AUTO_UNIQUE_VALUE* = SQL_COLUMN_AUTO_INCREMENT
SQL_DESC_BASE_COLUMN_NAME* = 22
SQL_DESC_BASE_TABLE_NAME* = 23
SQL_DESC_BIND_OFFSET_PTR* = 24
SQL_DESC_BIND_TYPE* = 25
SQL_DESC_CASE_SENSITIVE* = SQL_COLUMN_CASE_SENSITIVE
SQL_DESC_CATALOG_NAME* = SQL_COLUMN_QUALIFIER_NAME
SQL_DESC_CONCISE_TYPE* = SQL_COLUMN_TYPE
SQL_DESC_DATETIME_INTERVAL_PRECISION* = 26
SQL_DESC_DISPLAY_SIZE* = SQL_COLUMN_DISPLAY_SIZE
SQL_DESC_FIXED_PREC_SCALE* = SQL_COLUMN_MONEY
SQL_DESC_LABEL* = SQL_COLUMN_LABEL
SQL_DESC_LITERAL_PREFIX* = 27
SQL_DESC_LITERAL_SUFFIX* = 28
SQL_DESC_LOCAL_TYPE_NAME* = 29
SQL_DESC_MAXIMUM_SCALE* = 30
SQL_DESC_MINIMUM_SCALE* = 31
SQL_DESC_NUM_PREC_RADIX* = 32
SQL_DESC_PARAMETER_TYPE* = 33
SQL_DESC_ROWS_PROCESSED_PTR* = 34
SQL_DESC_SCHEMA_NAME* = SQL_COLUMN_OWNER_NAME
SQL_DESC_SEARCHABLE* = SQL_COLUMN_SEARCHABLE
SQL_DESC_TYPE_NAME* = SQL_COLUMN_TYPE_NAME
SQL_DESC_TABLE_NAME* = SQL_COLUMN_TABLE_NAME
SQL_DESC_UNSIGNED* = SQL_COLUMN_UNSIGNED
SQL_DESC_UPDATABLE* = SQL_COLUMN_UPDATABLE
SQL_COMMIT* = 0
SQL_ROLLBACK* = 1
SQL_ATTR_ROW_ARRAY_SIZE* = 27
ODBC_ADD_DSN* = 1
ODBC_CONFIG_DSN* = 2
ODBC_REMOVE_DSN* = 3
ODBC_ADD_SYS_DSN* = 4
ODBC_CONFIG_SYS_DSN* = 5
ODBC_REMOVE_SYS_DSN* = 6

Procs

proc SQLAllocHandle*(HandleType: TSqlSmallInt; InputHandle: TSqlHandle; OutputHandlePtr: var TSqlHandle): TSqlSmallInt {. dynlib: odbclib, importc.}
proc SQLSetEnvAttr*(EnvironmentHandle: TSqlHEnv; Attribute: TSqlInteger; Value: TSqlPointer; StringLength: TSqlInteger): TSqlSmallInt {. dynlib: odbclib, importc.}
proc SQLGetEnvAttr*(EnvironmentHandle: TSqlHEnv; Attribute: TSqlInteger; Value: TSqlPointer; BufferLength: TSqlInteger; StringLength: PSQLINTEGER): TSqlSmallInt {.dynlib: odbclib, importc.}
proc SQLFreeHandle*(HandleType: TSqlSmallInt; Handle: TSqlHandle): TSqlSmallInt {. dynlib: odbclib, importc.}
proc SQLGetDiagRec*(HandleType: TSqlSmallInt; Handle: TSqlHandle; RecNumber: TSqlSmallInt; Sqlstate: PSQLCHAR; NativeError: var TSqlInteger; MessageText: PSQLCHAR; BufferLength: TSqlSmallInt; TextLength: var TSqlSmallInt): TSqlSmallInt {. dynlib: odbclib, importc.}
proc SQLGetDiagField*(HandleType: TSqlSmallInt; Handle: TSqlHandle; RecNumber: TSqlSmallInt; DiagIdentifier: TSqlSmallInt; DiagInfoPtr: TSqlPointer; BufferLength: TSqlSmallInt; StringLengthPtr: var TSqlSmallInt): TSqlSmallInt {. dynlib: odbclib, importc.}
proc SQLConnect*(ConnectionHandle: TSqlHDBC; ServerName: PSQLCHAR; NameLength1: TSqlSmallInt; UserName: PSQLCHAR; NameLength2: TSqlSmallInt; Authentication: PSQLCHAR; NameLength3: TSqlSmallInt): TSqlSmallInt {.dynlib: odbclib, importc.}
proc SQLDisconnect*(ConnectionHandle: TSqlHDBC): TSqlSmallInt {.dynlib: odbclib, importc.}
proc SQLDriverConnect*(hdbc: TSqlHDBC; hwnd: TSqlHWND; szCsin: cstring; szCLen: TSqlSmallInt; szCsout: cstring; cbCSMax: TSqlSmallInt; cbCsOut: var TSqlSmallInt; f: TSqlUSmallInt): TSqlSmallInt {.dynlib: odbclib, importc.}
proc SQLBrowseConnect*(hdbc: TSqlHDBC; szConnStrIn: PSQLCHAR; cbConnStrIn: TSqlSmallInt; szConnStrOut: PSQLCHAR; cbConnStrOutMax: TSqlSmallInt; cbConnStrOut: var TSqlSmallInt): TSqlSmallInt {. dynlib: odbclib, importc.}
proc SQLExecDirect*(StatementHandle: TSqlHStmt; StatementText: PSQLCHAR; TextLength: TSqlInteger): TSqlSmallInt {.dynlib: odbclib, importc.}
proc SQLPrepare*(StatementHandle: TSqlHStmt; StatementText: PSQLCHAR; TextLength: TSqlInteger): TSqlSmallInt {.dynlib: odbclib, importc.}
proc SQLCloseCursor*(StatementHandle: TSqlHStmt): TSqlSmallInt {. dynlib: odbclib, importc.}
proc SQLExecute*(StatementHandle: TSqlHStmt): TSqlSmallInt {.dynlib: odbclib, importc.}
proc SQLFetch*(StatementHandle: TSqlHStmt): TSqlSmallInt {.dynlib: odbclib, importc.}
proc SQLNumResultCols*(StatementHandle: TSqlHStmt; ColumnCount: var TSqlSmallInt): TSqlSmallInt {. dynlib: odbclib, importc.}
proc SQLDescribeCol*(StatementHandle: TSqlHStmt; ColumnNumber: TSqlUSmallInt; ColumnName: PSQLCHAR; BufferLength: TSqlSmallInt; NameLength: var TSqlSmallInt; DataType: var TSqlSmallInt; ColumnSize: var TSqlUInteger; DecimalDigits: var TSqlSmallInt; Nullable: var TSqlSmallInt): TSqlSmallInt {. dynlib: odbclib, importc.}
proc SQLFetchScroll*(StatementHandle: TSqlHStmt; FetchOrientation: TSqlSmallInt; FetchOffset: TSqlInteger): TSqlSmallInt {.dynlib: odbclib, importc.}
proc SQLExtendedFetch*(hstmt: TSqlHStmt; fFetchType: TSqlUSmallInt; irow: TSqlInteger; pcrow: PSQLUINTEGER; rgfRowStatus: PSQLUSMALLINT): TSqlSmallInt {. dynlib: odbclib, importc.}
proc SQLGetData*(StatementHandle: TSqlHStmt; ColumnNumber: TSqlUSmallInt; TargetType: TSqlSmallInt; TargetValue: TSqlPointer; BufferLength: TSqlInteger; StrLen_or_Ind: PSQLINTEGER): TSqlSmallInt {. dynlib: odbclib, importc.}
proc SQLSetStmtAttr*(StatementHandle: TSqlHStmt; Attribute: TSqlInteger; Value: TSqlPointer; StringLength: TSqlInteger): TSqlSmallInt {. dynlib: odbclib, importc.}
proc SQLGetStmtAttr*(StatementHandle: TSqlHStmt; Attribute: TSqlInteger; Value: TSqlPointer; BufferLength: TSqlInteger; StringLength: PSQLINTEGER): TSqlSmallInt {.dynlib: odbclib, importc.}
proc SQLGetInfo*(ConnectionHandle: TSqlHDBC; InfoType: TSqlUSmallInt; InfoValue: TSqlPointer; BufferLength: TSqlSmallInt; StringLength: PSQLSMALLINT): TSqlSmallInt {.dynlib: odbclib, importc.}
proc SQLBulkOperations*(StatementHandle: TSqlHStmt; Operation: TSqlSmallInt): TSqlSmallInt {. dynlib: odbclib, importc.}
proc SQLPutData*(StatementHandle: TSqlHStmt; Data: TSqlPointer; StrLen_or_Ind: TSqlInteger): TSqlSmallInt {.dynlib: odbclib, importc.}
proc SQLBindCol*(StatementHandle: TSqlHStmt; ColumnNumber: TSqlUSmallInt; TargetType: TSqlSmallInt; TargetValue: TSqlPointer; BufferLength: TSqlInteger; StrLen_or_Ind: PSQLINTEGER): TSqlSmallInt {. dynlib: odbclib, importc.}
proc SQLSetPos*(hstmt: TSqlHStmt; irow: TSqlUSmallInt; fOption: TSqlUSmallInt; fLock: TSqlUSmallInt): TSqlSmallInt {.dynlib: odbclib, importc.}
proc SQLDataSources*(EnvironmentHandle: TSqlHEnv; Direction: TSqlUSmallInt; ServerName: PSQLCHAR; BufferLength1: TSqlSmallInt; NameLength1: PSQLSMALLINT; Description: PSQLCHAR; BufferLength2: TSqlSmallInt; NameLength2: PSQLSMALLINT): TSqlSmallInt {. dynlib: odbclib, importc.}
proc SQLDrivers*(EnvironmentHandle: TSqlHEnv; Direction: TSqlUSmallInt; DriverDescription: PSQLCHAR; BufferLength1: TSqlSmallInt; DescriptionLength1: PSQLSMALLINT; DriverAttributes: PSQLCHAR; BufferLength2: TSqlSmallInt; AttributesLength2: PSQLSMALLINT): TSqlSmallInt {. dynlib: odbclib, importc.}
proc SQLSetConnectAttr*(ConnectionHandle: TSqlHDBC; Attribute: TSqlInteger; Value: TSqlPointer; StringLength: TSqlInteger): TSqlSmallInt {. dynlib: odbclib, importc.}
proc SQLGetCursorName*(StatementHandle: TSqlHStmt; CursorName: PSQLCHAR; BufferLength: TSqlSmallInt; NameLength: PSQLSMALLINT): TSqlSmallInt {. dynlib: odbclib, importc.}
proc SQLSetCursorName*(StatementHandle: TSqlHStmt; CursorName: PSQLCHAR; NameLength: TSqlSmallInt): TSqlSmallInt {. dynlib: odbclib, importc.}
proc SQLRowCount*(StatementHandle: TSqlHStmt; RowCount: var TSqlInteger): TSqlSmallInt {. dynlib: odbclib, importc.}
proc SQLBindParameter*(hstmt: TSqlHStmt; ipar: TSqlUSmallInt; fParamType: TSqlSmallInt; fCType: TSqlSmallInt; fSqlType: TSqlSmallInt; cbColDef: TSqlUInteger; ibScale: TSqlSmallInt; rgbValue: TSqlPointer; cbValueMax: TSqlInteger; pcbValue: PSQLINTEGER): TSqlSmallInt {. dynlib: odbclib, importc.}
proc SQLFreeStmt*(StatementHandle: TSqlHStmt; Option: TSqlUSmallInt): TSqlSmallInt {. dynlib: odbclib, importc.}
proc SQLColAttribute*(StatementHandle: TSqlHStmt; ColumnNumber: TSqlUSmallInt; FieldIdentifier: TSqlUSmallInt; CharacterAttribute: PSQLCHAR; BufferLength: TSqlSmallInt; StringLength: PSQLSMALLINT; NumericAttribute: TSqlPointer): TSqlSmallInt {. dynlib: odbclib, importc.}
proc SQLEndTran*(HandleType: TSqlSmallInt; Handle: TSqlHandle; CompletionType: TSqlSmallInt): TSqlSmallInt {.dynlib: odbclib, importc.}
proc SQLTables*(hstmt: TSqlHStmt; szTableQualifier: PSQLCHAR; cbTableQualifier: TSqlSmallInt; szTableOwner: PSQLCHAR; cbTableOwner: TSqlSmallInt; szTableName: PSQLCHAR; cbTableName: TSqlSmallInt; szTableType: PSQLCHAR; cbTableType: TSqlSmallInt): TSqlSmallInt {.dynlib: odbclib, importc.}
proc SQLColumns*(hstmt: TSqlHStmt; szTableQualifier: PSQLCHAR; cbTableQualifier: TSqlSmallInt; szTableOwner: PSQLCHAR; cbTableOwner: TSqlSmallInt; szTableName: PSQLCHAR; cbTableName: TSqlSmallInt; szColumnName: PSQLCHAR; cbColumnName: TSqlSmallInt): TSqlSmallInt {.dynlib: odbclib, importc.}
proc SQLSpecialColumns*(StatementHandle: TSqlHStmt; IdentifierType: TSqlUSmallInt; CatalogName: PSQLCHAR; NameLength1: TSqlSmallInt; SchemaName: PSQLCHAR; NameLength2: TSqlSmallInt; TableName: PSQLCHAR; NameLength3: TSqlSmallInt; Scope: TSqlUSmallInt; Nullable: TSqlUSmallInt): TSqlSmallInt {. dynlib: odbclib, importc.}
proc SQLProcedures*(hstmt: TSqlHStmt; szTableQualifier: PSQLCHAR; cbTableQualifier: TSqlSmallInt; szTableOwner: PSQLCHAR; cbTableOwner: TSqlSmallInt; szTableName: PSQLCHAR; cbTableName: TSqlSmallInt): TSqlSmallInt {.dynlib: odbclib, importc.}
proc SQLPrimaryKeys*(hstmt: TSqlHStmt; CatalogName: PSQLCHAR; NameLength1: TSqlSmallInt; SchemaName: PSQLCHAR; NameLength2: TSqlSmallInt; TableName: PSQLCHAR; NameLength3: TSqlSmallInt): TSqlSmallInt {.dynlib: odbclib, importc.}
proc SQLProcedureColumns*(hstmt: TSqlHStmt; CatalogName: PSQLCHAR; NameLength1: TSqlSmallInt; SchemaName: PSQLCHAR; NameLength2: TSqlSmallInt; ProcName: PSQLCHAR; NameLength3: TSqlSmallInt; ColumnName: PSQLCHAR; NameLength4: TSqlSmallInt): TSqlSmallInt {. dynlib: odbclib, importc.}
proc SQLStatistics*(hstmt: TSqlHStmt; CatalogName: PSQLCHAR; NameLength1: TSqlSmallInt; SchemaName: PSQLCHAR; NameLength2: TSqlSmallInt; TableName: PSQLCHAR; NameLength3: TSqlSmallInt; Unique: TSqlUSmallInt; Reserved: TSqlUSmallInt): TSqlSmallInt {.dynlib: odbclib, importc.}

Module odbcsql

Types

Consts

Procs