Types

  1. PSQL_DATE_STRUCT = ptr SQL_DATE_STRUCT
  1. PSQL_TIME_STRUCT = ptr SQL_TIME_STRUCT
  1. PSQL_TIMESTAMP_STRUCT = ptr SQL_TIMESTAMP_STRUCT
  1. PSQLCHAR = cstring
  1. PSQLDOUBLE = ptr TSqlDouble
  1. PSQLFLOAT = ptr TSqlFloat
  1. PSQLHANDLE = ptr SqlHandle
  1. PSQLINTEGER = ptr TSqlInteger
  1. PSQLREAL = ptr TSqlReal
  1. PSQLSMALLINT = ptr TSqlSmallInt
  1. PSQLUINTEGER = ptr SqlUInteger
  1. PSQLUSMALLINT = ptr SqlUSmallInt
  1. SQL_DATE_STRUCT {.final, pure.} = object
  2. Year*: TSqlSmallInt
  3. Month*: SqlUSmallInt
  4. Day*: SqlUSmallInt
  1. SQL_TIME_STRUCT {.final, pure.} = object
  2. Hour*: SqlUSmallInt
  3. Minute*: SqlUSmallInt
  4. Second*: SqlUSmallInt
  1. SQL_TIMESTAMP_STRUCT {.final, pure.} = object
  2. Year*: SqlUSmallInt
  3. Month*: SqlUSmallInt
  4. Day*: SqlUSmallInt
  5. Hour*: SqlUSmallInt
  6. Minute*: SqlUSmallInt
  7. Second*: SqlUSmallInt
  8. Fraction*: SqlUInteger
  1. SqlHandle = pointer
  1. SqlHDBC = SqlHandle
  1. SqlHDesc = SqlHandle
  1. SqlHEnv = SqlHandle
  1. SqlHStmt = SqlHandle
  1. SqlHWND = pointer
  1. SqlPointer = pointer
  1. SqlUInteger = int32
  1. SqlUSmallInt = int16
  1. TSqlChar = char
  1. TSqlDouble = cdouble
  1. TSqlFloat = cdouble
  1. TSqlInteger = int32
  1. TSqlLen = int
  1. TSqlReal = cfloat
  1. TSqlSmallInt = int16
  1. TSqlULen = uint

Consts

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

Procs

  1. proc SQLAllocHandle(HandleType: TSqlSmallInt; InputHandle: SqlHandle;
  2. OutputHandlePtr: var SqlHandle): TSqlSmallInt {.
  3. dynlib: odbclib, importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLBindCol(StatementHandle: SqlHStmt; ColumnNumber: SqlUSmallInt;
  2. TargetType: TSqlSmallInt; TargetValue: SqlPointer;
  3. BufferLength: TSqlLen; StrLen_or_Ind: PSQLINTEGER): TSqlSmallInt {.
  4. dynlib: odbclib, importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLBindParameter(hstmt: SqlHStmt; ipar: SqlUSmallInt;
  2. fParamType: TSqlSmallInt; fCType: TSqlSmallInt;
  3. fSqlType: TSqlSmallInt; cbColDef: TSqlULen;
  4. ibScale: TSqlSmallInt; rgbValue: SqlPointer;
  5. cbValueMax: TSqlLen; pcbValue: var TSqlLen): TSqlSmallInt {.
  6. dynlib: odbclib, importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLBrowseConnect(hdbc: SqlHDBC; szConnStrIn: PSQLCHAR;
  2. cbConnStrIn: TSqlSmallInt; szConnStrOut: PSQLCHAR;
  3. cbConnStrOutMax: TSqlSmallInt;
  4. cbConnStrOut: var TSqlSmallInt): TSqlSmallInt {.
  5. dynlib: odbclib, importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLBulkOperations(StatementHandle: SqlHStmt; Operation: SqlUSmallInt): TSqlSmallInt {.
  2. dynlib: odbclib, importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLCloseCursor(StatementHandle: SqlHStmt): TSqlSmallInt {.dynlib: odbclib,
  2. importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLColAttribute(StatementHandle: SqlHStmt; ColumnNumber: SqlUSmallInt;
  2. FieldIdentifier: SqlUSmallInt;
  3. CharacterAttribute: PSQLCHAR; BufferLength: TSqlSmallInt;
  4. StringLength: PSQLSMALLINT; NumericAttribute: TSqlLen): TSqlSmallInt {.
  5. dynlib: odbclib, importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLColumns(hstmt: SqlHStmt; szTableQualifier: PSQLCHAR;
  2. cbTableQualifier: TSqlSmallInt; szTableOwner: PSQLCHAR;
  3. cbTableOwner: TSqlSmallInt; szTableName: PSQLCHAR;
  4. cbTableName: TSqlSmallInt; szColumnName: PSQLCHAR;
  5. cbColumnName: TSqlSmallInt): TSqlSmallInt {.dynlib: odbclib,
  6. importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLConnect(ConnectionHandle: SqlHDBC; ServerName: PSQLCHAR;
  2. NameLength1: TSqlSmallInt; UserName: PSQLCHAR;
  3. NameLength2: TSqlSmallInt; Authentication: PSQLCHAR;
  4. NameLength3: TSqlSmallInt): TSqlSmallInt {.dynlib: odbclib,
  5. importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLDataSources(EnvironmentHandle: SqlHEnv; Direction: SqlUSmallInt;
  2. ServerName: PSQLCHAR; BufferLength1: TSqlSmallInt;
  3. NameLength1: PSQLSMALLINT; Description: PSQLCHAR;
  4. BufferLength2: TSqlSmallInt; NameLength2: PSQLSMALLINT): TSqlSmallInt {.
  5. dynlib: odbclib, importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLDescribeCol(StatementHandle: SqlHStmt; ColumnNumber: SqlUSmallInt;
  2. ColumnName: PSQLCHAR; BufferLength: TSqlSmallInt;
  3. NameLength: var TSqlSmallInt; DataType: var TSqlSmallInt;
  4. ColumnSize: var TSqlULen; DecimalDigits: var TSqlSmallInt;
  5. Nullable: var TSqlSmallInt): TSqlSmallInt {.dynlib: odbclib,
  6. importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLDisconnect(ConnectionHandle: SqlHDBC): TSqlSmallInt {.dynlib: odbclib,
  2. importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLDriverConnect(hdbc: SqlHDBC; hwnd: SqlHWND; szCsin: cstring;
  2. szCLen: TSqlSmallInt; szCsout: cstring;
  3. cbCSMax: TSqlSmallInt; cbCsOut: var TSqlSmallInt;
  4. f: SqlUSmallInt): TSqlSmallInt {.dynlib: odbclib, importc,
  5. ...raises: [], tags: [], forbids: [].}
  1. proc SQLDrivers(EnvironmentHandle: SqlHEnv; Direction: SqlUSmallInt;
  2. DriverDescription: PSQLCHAR; BufferLength1: TSqlSmallInt;
  3. DescriptionLength1: PSQLSMALLINT; DriverAttributes: PSQLCHAR;
  4. BufferLength2: TSqlSmallInt; AttributesLength2: PSQLSMALLINT): TSqlSmallInt {.
  5. dynlib: odbclib, importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLEndTran(HandleType: TSqlSmallInt; Handle: SqlHandle;
  2. CompletionType: TSqlSmallInt): TSqlSmallInt {.dynlib: odbclib,
  3. importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLErr(henv: SqlHEnv; hdbc: SqlHDBC; hstmt: SqlHStmt;
  2. szSqlState, pfNativeError, szErrorMsg: PSQLCHAR;
  3. cbErrorMsgMax: TSqlSmallInt; pcbErrorMsg: PSQLSMALLINT): TSqlSmallInt {.
  4. dynlib: odbclib, importc: "SQLError", ...raises: [], tags: [], forbids: [].}
  1. proc SQLExecDirect(StatementHandle: SqlHStmt; StatementText: PSQLCHAR;
  2. TextLength: TSqlInteger): TSqlSmallInt {.dynlib: odbclib,
  3. importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLExecDirectW(StatementHandle: SqlHStmt; StatementText: WideCString;
  2. TextLength: TSqlInteger): TSqlSmallInt {.dynlib: odbclib,
  3. importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLExecute(StatementHandle: SqlHStmt): TSqlSmallInt {.dynlib: odbclib,
  2. importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLExtendedFetch(hstmt: SqlHStmt; fFetchType: SqlUSmallInt; irow: TSqlLen;
  2. pcrow: var TSqlULen; rgfRowStatus: PSQLUSMALLINT): TSqlSmallInt {.
  3. dynlib: odbclib, importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLFetch(StatementHandle: SqlHStmt): TSqlSmallInt {.dynlib: odbclib,
  2. importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLFetchScroll(StatementHandle: SqlHStmt; FetchOrientation: TSqlSmallInt;
  2. FetchOffset: TSqlLen): TSqlSmallInt {.dynlib: odbclib,
  3. importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLFreeHandle(HandleType: TSqlSmallInt; Handle: SqlHandle): TSqlSmallInt {.
  2. dynlib: odbclib, importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLFreeStmt(StatementHandle: SqlHStmt; Option: SqlUSmallInt): TSqlSmallInt {.
  2. dynlib: odbclib, importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLGetCursorName(StatementHandle: SqlHStmt; CursorName: PSQLCHAR;
  2. BufferLength: TSqlSmallInt; NameLength: PSQLSMALLINT): TSqlSmallInt {.
  3. dynlib: odbclib, importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLGetData(StatementHandle: SqlHStmt; ColumnNumber: SqlUSmallInt;
  2. TargetType: TSqlSmallInt; TargetValue: SqlPointer;
  3. BufferLength: TSqlLen; StrLen_or_Ind: ptr TSqlLen): TSqlSmallInt {.
  4. dynlib: odbclib, importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLGetDiagField(HandleType: TSqlSmallInt; Handle: SqlHandle;
  2. RecNumber: TSqlSmallInt; DiagIdentifier: TSqlSmallInt;
  3. DiagInfoPtr: SqlPointer; BufferLength: TSqlSmallInt;
  4. StringLengthPtr: var TSqlSmallInt): TSqlSmallInt {.
  5. dynlib: odbclib, importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLGetDiagRec(HandleType: TSqlSmallInt; Handle: SqlHandle;
  2. RecNumber: TSqlSmallInt; Sqlstate: PSQLCHAR;
  3. NativeError: var TSqlInteger; MessageText: PSQLCHAR;
  4. BufferLength: TSqlSmallInt; TextLength: var TSqlSmallInt): TSqlSmallInt {.
  5. dynlib: odbclib, importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLGetEnvAttr(EnvironmentHandle: SqlHEnv; Attribute: TSqlInteger;
  2. Value: SqlPointer; BufferLength: TSqlInteger;
  3. StringLength: PSQLINTEGER): TSqlSmallInt {.dynlib: odbclib,
  4. importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLGetInfo(ConnectionHandle: SqlHDBC; InfoType: SqlUSmallInt;
  2. InfoValue: SqlPointer; BufferLength: TSqlSmallInt;
  3. StringLength: PSQLSMALLINT): TSqlSmallInt {.dynlib: odbclib,
  4. importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLGetStmtAttr(StatementHandle: SqlHStmt; Attribute: TSqlInteger;
  2. Value: SqlPointer; BufferLength: TSqlInteger;
  3. StringLength: PSQLINTEGER): TSqlSmallInt {.dynlib: odbclib,
  4. importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLNumResultCols(StatementHandle: SqlHStmt; ColumnCount: var TSqlSmallInt): TSqlSmallInt {.
  2. dynlib: odbclib, importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLPrepare(StatementHandle: SqlHStmt; StatementText: PSQLCHAR;
  2. TextLength: TSqlInteger): TSqlSmallInt {.dynlib: odbclib,
  3. importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLPrepareW(StatementHandle: SqlHStmt; StatementText: WideCString;
  2. TextLength: TSqlInteger): TSqlSmallInt {.dynlib: odbclib,
  3. importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLPrimaryKeys(hstmt: SqlHStmt; CatalogName: PSQLCHAR;
  2. NameLength1: TSqlSmallInt; SchemaName: PSQLCHAR;
  3. NameLength2: TSqlSmallInt; TableName: PSQLCHAR;
  4. NameLength3: TSqlSmallInt): TSqlSmallInt {.dynlib: odbclib,
  5. importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLProcedureColumns(hstmt: SqlHStmt; CatalogName: PSQLCHAR;
  2. NameLength1: TSqlSmallInt; SchemaName: PSQLCHAR;
  3. NameLength2: TSqlSmallInt; ProcName: PSQLCHAR;
  4. NameLength3: TSqlSmallInt; ColumnName: PSQLCHAR;
  5. NameLength4: TSqlSmallInt): TSqlSmallInt {.
  6. dynlib: odbclib, importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLProcedures(hstmt: SqlHStmt; szTableQualifier: PSQLCHAR;
  2. cbTableQualifier: TSqlSmallInt; szTableOwner: PSQLCHAR;
  3. cbTableOwner: TSqlSmallInt; szTableName: PSQLCHAR;
  4. cbTableName: TSqlSmallInt): TSqlSmallInt {.dynlib: odbclib,
  5. importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLPutData(StatementHandle: SqlHStmt; Data: SqlPointer;
  2. StrLen_or_Ind: TSqlLen): TSqlSmallInt {.dynlib: odbclib,
  3. importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLRowCount(StatementHandle: SqlHStmt; RowCount: var TSqlLen): TSqlSmallInt {.
  2. dynlib: odbclib, importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLSetConnectAttr(ConnectionHandle: SqlHDBC; Attribute: TSqlInteger;
  2. Value: SqlPointer; StringLength: TSqlInteger): TSqlSmallInt {.
  3. dynlib: odbclib, importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLSetCursorName(StatementHandle: SqlHStmt; CursorName: PSQLCHAR;
  2. NameLength: TSqlSmallInt): TSqlSmallInt {.dynlib: odbclib,
  3. importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLSetEnvAttr(EnvironmentHandle: SqlHEnv; Attribute: TSqlInteger;
  2. Value: SqlPointer; StringLength: TSqlInteger): TSqlSmallInt {.
  3. dynlib: odbclib, importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLSetPos(hstmt: SqlHStmt; irow: SqlUSmallInt; fOption: SqlUSmallInt;
  2. fLock: SqlUSmallInt): TSqlSmallInt {.dynlib: odbclib, importc,
  3. ...raises: [], tags: [], forbids: [].}
  1. proc SQLSetStmtAttr(StatementHandle: SqlHStmt; Attribute: TSqlInteger;
  2. Value: SqlPointer; StringLength: TSqlInteger): TSqlSmallInt {.
  3. dynlib: odbclib, importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLSpecialColumns(StatementHandle: SqlHStmt; IdentifierType: SqlUSmallInt;
  2. CatalogName: PSQLCHAR; NameLength1: TSqlSmallInt;
  3. SchemaName: PSQLCHAR; NameLength2: TSqlSmallInt;
  4. TableName: PSQLCHAR; NameLength3: TSqlSmallInt;
  5. Scope: SqlUSmallInt; Nullable: SqlUSmallInt): TSqlSmallInt {.
  6. dynlib: odbclib, importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLStatistics(hstmt: SqlHStmt; CatalogName: PSQLCHAR;
  2. NameLength1: TSqlSmallInt; SchemaName: PSQLCHAR;
  3. NameLength2: TSqlSmallInt; TableName: PSQLCHAR;
  4. NameLength3: TSqlSmallInt; Unique: SqlUSmallInt;
  5. Reserved: SqlUSmallInt): TSqlSmallInt {.dynlib: odbclib,
  6. importc, ...raises: [], tags: [], forbids: [].}
  1. proc SQLTables(hstmt: SqlHStmt; szTableQualifier: PSQLCHAR;
  2. cbTableQualifier: TSqlSmallInt; szTableOwner: PSQLCHAR;
  3. cbTableOwner: TSqlSmallInt; szTableName: PSQLCHAR;
  4. cbTableName: TSqlSmallInt; szTableType: PSQLCHAR;
  5. cbTableType: TSqlSmallInt): TSqlSmallInt {.dynlib: odbclib,
  6. importc, ...raises: [], tags: [], forbids: [].}