sdodbc.hpp

SQLDirect Component Library is a light-weight Borland Database Engine replacement for Borland Delphi

static const Shortint SQL_SPECIAL_CHARACTERS = 0x5e;
static const Shortint SQL_MAX_COLUMNS_IN_GROUP_BY = 0x61;
static const Shortint SQL_MAXIMUM_COLUMNS_IN_GROUP_BY = 0x61;
static const Shortint SQL_MAX_COLUMNS_IN_INDEX = 0x62;
static const Shortint SQL_MAXIMUM_COLUMNS_IN_INDEX = 0x62;
static const Shortint SQL_MAX_COLUMNS_IN_ORDER_BY = 0x63;
static const Shortint SQL_MAXIMUM_COLUMNS_IN_ORDER_BY = 0x63;
static const Shortint SQL_MAX_COLUMNS_IN_SELECT = 0x64;
static const Shortint SQL_MAXIMUM_COLUMNS_IN_SELECT = 0x64;
static const Shortint SQL_MAX_COLUMNS_IN_TABLE = 0x65;
static const Shortint SQL_MAX_INDEX_SIZE = 0x66;
static const Shortint SQL_MAXIMUM_INDEX_SIZE = 0x66;
static const Shortint SQL_MAX_ROW_SIZE = 0x68;
static const Shortint SQL_MAXIMUM_ROW_SIZE = 0x68;
static const Shortint SQL_MAX_STATEMENT_LEN = 0x69;
static const Shortint SQL_MAXIMUM_STATEMENT_LENGTH = 0x69;
static const Shortint SQL_MAX_TABLES_IN_SELECT = 0x6a;
static const Shortint SQL_MAXIMUM_TABLES_IN_SELECT = 0x6a;
static const Shortint SQL_MAX_USER_NAME_LEN = 0x6b;
static const Shortint SQL_MAXIMUM_USER_NAME_LENGTH = 0x6b;
static const Shortint SQL_OJ_CAPABILITIES = 0x73;
static const Shortint SQL_OUTER_JOIN_CAPABILITIES = 0x73;
static const Word SQL_XOPEN_CLI_YEAR = 0x2710;
static const Word SQL_CURSOR_SENSITIVITY = 0x2711;
static const Word SQL_DESCRIBE_PARAMETER = 0x2712;
static const Word SQL_CATALOG_NAME = 0x2713;
static const Word SQL_COLLATION_SEQ = 0x2714;
static const Word SQL_MAX_IDENTIFIER_LEN = 0x2715;
static const Word SQL_MAXIMUM_IDENTIFIER_LENGTH = 0x2715;
static const Shortint SQL_AT_ADD_COLUMN = 0x1;
static const Shortint SQL_AT_DROP_COLUMN = 0x2;
static const Shortint SQL_AT_ADD_CONSTRAINT = 0x8;
static const Shortint SQL_AM_NONE = 0x0;
static const Shortint SQL_AM_CONNECTION = 0x1;
static const Shortint SQL_AM_STATEMENT = 0x2;
static const Shortint SQL_CB_DELETE = 0x0;
static const Shortint SQL_CB_CLOSE = 0x1;
static const Shortint SQL_CB_PRESERVE = 0x2;
static const Shortint SQL_FD_FETCH_NEXT = 0x1;
static const Shortint SQL_FD_FETCH_FIRST = 0x2;
static const Shortint SQL_FD_FETCH_LAST = 0x4;
static const Shortint SQL_FD_FETCH_PRIOR = 0x8;
static const Shortint SQL_FD_FETCH_ABSOLUTE = 0x10;
static const Shortint SQL_FD_FETCH_RELATIVE = 0x20;
static const Shortint SQL_GD_ANY_COLUMN = 0x1;
static const Shortint SQL_GD_ANY_ORDER = 0x2;
static const Shortint SQL_IC_UPPER = 0x1;
static const Shortint SQL_IC_LOWER = 0x2;
static const Shortint SQL_IC_SENSITIVE = 0x3;
static const Shortint SQL_IC_MIXED = 0x4;
static const Shortint SQL_OJ_LEFT = 0x1;
static const Shortint SQL_OJ_RIGHT = 0x2;
static const Shortint SQL_OJ_FULL = 0x4;
static const Shortint SQL_OJ_NESTED = 0x8;
static const Shortint SQL_OJ_NOT_ORDERED = 0x10;
static const Shortint SQL_OJ_INNER = 0x20;
static const Shortint SQL_OJ_ALL_COMPARISON_OPS = 0x40;
static const Shortint SQL_SCCO_READ_ONLY = 0x1;
static const Shortint SQL_SCCO_LOCK = 0x2;
static const Shortint SQL_SCCO_OPT_ROWVER = 0x4;
static const Shortint SQL_SCCO_OPT_VALUES = 0x8;
static const Shortint SQL_TC_NONE = 0x0;
static const Shortint SQL_TC_DML = 0x1;
static const Shortint SQL_TC_ALL = 0x2;
static const Shortint SQL_TC_DDL_COMMIT = 0x3;
static const Shortint SQL_TC_DDL_IGNORE = 0x4;
static const Shortint SQL_TXN_READ_UNCOMMITTED = 0x1;
static const Shortint SQL_TRANSACTION_READ_UNCOMMITTED = 0x1;
static const Shortint SQL_TXN_READ_COMMITTED = 0x2;
static const Shortint SQL_TRANSACTION_READ_COMMITTED = 0x2;
static const Shortint SQL_TXN_REPEATABLE_READ = 0x4;
static const Shortint SQL_TRANSACTION_REPEATABLE_READ = 0x4;
static const Shortint SQL_TXN_SERIALIZABLE = 0x8;
static const Shortint SQL_TRANSACTION_SERIALIZABLE = 0x8;
static const Shortint SQL_NC_HIGH = 0x0;
static const Shortint SQL_NC_LOW = 0x1;
static const Shortint SQL_IS_YEAR = 0x1;
static const Shortint SQL_IS_MONTH = 0x2;
static const Shortint SQL_IS_DAY = 0x3;
static const Shortint SQL_IS_HOUR = 0x4;
static const Shortint SQL_IS_MINUTE = 0x5;
static const Shortint SQL_IS_SECOND = 0x6;
static const Shortint SQL_IS_YEAR_TO_MONTH = 0x7;
static const Shortint SQL_IS_DAY_TO_HOUR = 0x8;
static const Shortint SQL_IS_DAY_TO_MINUTE = 0x9;
static const Shortint SQL_IS_DAY_TO_SECOND = 0xa;
static const Shortint SQL_IS_HOUR_TO_MINUTE = 0xb;
static const Shortint SQL_IS_HOUR_TO_SECOND = 0xc;
static const Shortint SQL_IS_MINUTE_TO_SECOND = 0xd;
static const Shortint SQL_SQLSTATE_SIZE = 0x5;
static const Shortint SQL_MAX_DSN_LENGTH = 0x20;
static const Word SQL_MAX_OPTION_STRING_LENGTH = 0x100;
static const Shortint SQL_HANDLE_SENV = 0x5;
static const Byte SQL_ATTR_ODBC_VERSION = 0xc8;
static const Byte SQL_ATTR_CONNECTION_POOLING = 0xc9;
static const Byte SQL_ATTR_CP_MATCH = 0xca;
static const Shortint SQL_CP_OFF = 0x0;
static const Shortint SQL_CP_ONE_PER_DRIVER = 0x1;
static const Shortint SQL_CP_ONE_PER_HENV = 0x2;
static const Shortint SQL_CP_DEFAULT = 0x0;
static const Shortint SQL_CP_STRICT_MATCH = 0x0;
static const Shortint SQL_CP_RELAXED_MATCH = 0x1;
static const Shortint SQL_CP_MATCH_DEFAULT = 0x0;
static const Shortint SQL_OV_ODBC2 = 0x2;
static const Shortint SQL_OV_ODBC3 = 0x3;
static const Shortint SQL_ACCESS_MODE = 0x65;
static const Shortint SQL_AUTOCOMMIT = 0x66;
static const Shortint SQL_LOGIN_TIMEOUT = 0x67;
static const Shortint SQL_OPT_TRACE = 0x68;
static const Shortint SQL_OPT_TRACEFILE = 0x69;
static const Shortint SQL_TRANSLATE_DLL = 0x6a;
static const Shortint SQL_TRANSLATE_OPTION = 0x6b;
static const Shortint SQL_TXN_ISOLATION = 0x6c;
static const Shortint SQL_CURRENT_QUALIFIER = 0x6d;
static const Shortint SQL_ODBC_CURSORS = 0x6e;
static const Shortint SQL_QUIET_MODE = 0x6f;
static const Shortint SQL_PACKET_SIZE = 0x70;
static const Shortint SQL_ATTR_ACCESS_MODE = 0x65;
static const Shortint SQL_ATTR_AUTOCOMMIT = 0x66;
static const Shortint SQL_ATTR_CONNECTION_TIMEOUT = 0x71;
static const Shortint SQL_ATTR_CURRENT_CATALOG = 0x6d;
static const Shortint SQL_ATTR_DISCONNECT_BEHAVIOR = 0x72;
static const Word SQL_ATTR_ENLIST_IN_DTC = 0x4b7;
static const Word SQL_ATTR_ENLIST_IN_XA = 0x4b8;
static const Shortint SQL_ATTR_LOGIN_TIMEOUT = 0x67;
static const Shortint SQL_ATTR_ODBC_CURSORS = 0x6e;
static const Shortint SQL_ATTR_PACKET_SIZE = 0x70;
static const Shortint SQL_ATTR_QUIET_MODE = 0x6f;
static const Shortint SQL_ATTR_TRACE = 0x68;
static const Shortint SQL_ATTR_TRACEFILE = 0x69;
static const Shortint SQL_ATTR_TRANSLATE_LIB = 0x6a;
static const Shortint SQL_ATTR_TRANSLATE_OPTION = 0x6b;
static const Shortint SQL_ATTR_TXN_ISOLATION = 0x6c;
static const Word SQL_ATTR_CONNECTION_DEAD = 0x4b9;
static const Word SQL_CONNECT_OPT_DRVR_START = 0x3e8;
static const Shortint SQL_CONN_OPT_MAX = 0x70;
static const Shortint SQL_CONN_OPT_MIN = 0x65;
static const Shortint SQL_MODE_READ_WRITE = 0x0;
static const Shortint SQL_MODE_READ_ONLY = 0x1;
static const Shortint SQL_MODE_DEFAULT = 0x0;
static const Shortint SQL_AUTOCOMMIT_OFF = 0x0;
static const Shortint SQL_AUTOCOMMIT_ON = 0x1;
static const Shortint SQL_AUTOCOMMIT_DEFAULT = 0x1;
static const Shortint SQL_LOGIN_TIMEOUT_DEFAULT = 0xf;
static const Shortint SQL_OPT_TRACE_OFF = 0x0;
static const Shortint SQL_OPT_TRACE_ON = 0x1;
static const Shortint SQL_OPT_TRACE_DEFAULT = 0x0;
#define SQL_OPT_TRACE_FILE_DEFAULT "\\SQL.LOG"
static const Shortint SQL_CUR_USE_IF_NEEDED = 0x0;
static const Shortint SQL_CUR_USE_ODBC = 0x1;
static const Shortint SQL_CUR_USE_DRIVER = 0x2;
static const Shortint SQL_CUR_DEFAULT = 0x2;
static const Shortint SQL_DB_RETURN_TO_POOL = 0x0;
static const Shortint SQL_DB_DISCONNECT = 0x1;
static const Shortint SQL_DB_DEFAULT = 0x0;
static const Shortint SQL_DTC_DONE = 0x0;
static const Shortint SQL_CD_TRUE = 0x1;
static const Shortint SQL_CD_FALSE = 0x0;
static const Shortint SQL_QUERY_TIMEOUT = 0x0;
static const Shortint SQL_MAX_ROWS = 0x1;
static const Shortint SQL_NOSCAN = 0x2;
static const Shortint SQL_MAX_LENGTH = 0x3;
static const Shortint SQL_ASYNC_ENABLE = 0x4;
static const Shortint SQL_BIND_TYPE = 0x5;
static const Shortint SQL_CURSOR_TYPE = 0x6;
static const Shortint SQL_CONCURRENCY = 0x7;
static const Shortint SQL_KEYSET_SIZE = 0x8;
static const Shortint SQL_ROWSET_SIZE = 0x9;
static const Shortint SQL_SIMULATE_CURSOR = 0xa;
static const Shortint SQL_RETRIEVE_DATA = 0xb;
static const Shortint SQL_USE_BOOKMARKS = 0xc;
static const Shortint SQL_GET_BOOKMARK = 0xd;
static const Shortint SQL_ROW_NUMBER = 0xe;
static const Shortint SQL_ATTR_ASYNC_ENABLE = 0x4;
static const Shortint SQL_ATTR_CONCURRENCY = 0x7;
static const Shortint SQL_ATTR_CURSOR_TYPE = 0x6;
static const Shortint SQL_ATTR_ENABLE_AUTO_IPD = 0xf;
static const Shortint SQL_ATTR_FETCH_BOOKMARK_PTR = 0x10;
static const Shortint SQL_ATTR_KEYSET_SIZE = 0x8;
static const Shortint SQL_ATTR_MAX_LENGTH = 0x3;
static const Shortint SQL_ATTR_MAX_ROWS = 0x1;
static const Shortint SQL_ATTR_NOSCAN = 0x2;
static const Shortint SQL_ATTR_PARAM_BIND_OFFSET_PTR = 0x11;
static const Shortint SQL_ATTR_PARAM_BIND_TYPE = 0x12;
static const Shortint SQL_ATTR_PARAM_OPERATION_PTR = 0x13;
static const Shortint SQL_ATTR_PARAM_STATUS_PTR = 0x14;
static const Shortint SQL_ATTR_PARAMS_PROCESSED_PTR = 0x15;
static const Shortint SQL_ATTR_PARAMSET_SIZE = 0x16;
static const Shortint SQL_ATTR_QUERY_TIMEOUT = 0x0;
static const Shortint SQL_ATTR_RETRIEVE_DATA = 0xb;
static const Shortint SQL_ATTR_ROW_BIND_OFFSET_PTR = 0x17;
static const Shortint SQL_ATTR_ROW_BIND_TYPE = 0x5;
static const Shortint SQL_ATTR_ROW_NUMBER = 0xe;
static const Shortint SQL_ATTR_ROW_OPERATION_PTR = 0x18;
static const Shortint SQL_ATTR_ROW_STATUS_PTR = 0x19;
static const Shortint SQL_ATTR_ROWS_FETCHED_PTR = 0x1a;
static const Shortint SQL_ATTR_ROW_ARRAY_SIZE = 0x1b;
static const Shortint SQL_ATTR_SIMULATE_CURSOR = 0xa;
static const Shortint SQL_ATTR_USE_BOOKMARKS = 0xc;
static const Shortint SQL_STMT_OPT_MAX = 0xe;
static const Shortint SQL_STMT_OPT_MIN = 0x0;
static const Shortint SQL_IS_POINTER = 0xfffffffc;
static const Shortint SQL_IS_UINTEGER = 0xfffffffb;
static const Shortint SQL_IS_INTEGER = 0xfffffffa;
static const Shortint SQL_IS_USMALLINT = 0xfffffff9;
static const Shortint SQL_IS_SMALLINT = 0xfffffff8;
static const Shortint SQL_PARAM_BIND_BY_COLUMN = 0x0;
static const Shortint SQL_PARAM_BIND_TYPE_DEFAULT = 0x0;
static const Shortint SQL_QUERY_TIMEOUT_DEFAULT = 0x0;
static const Shortint SQL_MAX_ROWS_DEFAULT = 0x0;
static const Shortint SQL_NOSCAN_OFF = 0x0;
static const Shortint SQL_NOSCAN_ON = 0x1;
static const Shortint SQL_NOSCAN_DEFAULT = 0x0;
static const Shortint SQL_MAX_LENGTH_DEFAULT = 0x0;
static const Shortint SQL_ASYNC_ENABLE_OFF = 0x0;
static const Shortint SQL_ASYNC_ENABLE_ON = 0x1;
static const Shortint SQL_ASYNC_ENABLE_DEFAULT = 0x0;
static const Shortint SQL_BIND_BY_COLUMN = 0x0;
static const Shortint SQL_BIND_TYPE_DEFAULT = 0x0;
static const Shortint SQL_CONCUR_READ_ONLY = 0x1;
static const Shortint SQL_CONCUR_LOCK = 0x2;
static const Shortint SQL_CONCUR_ROWVER = 0x3;
static const Shortint SQL_CONCUR_VALUES = 0x4;
static const Shortint SQL_CONCUR_DEFAULT = 0x1;
static const Shortint SQL_CURSOR_FORWARD_ONLY = 0x0;
static const Shortint SQL_CURSOR_KEYSET_DRIVEN = 0x1;
static const Shortint SQL_CURSOR_DYNAMIC = 0x2;
static const Shortint SQL_CURSOR_STATIC = 0x3;
static const Shortint SQL_CURSOR_TYPE_DEFAULT = 0x0;
static const Shortint SQL_ROWSET_SIZE_DEFAULT = 0x1;
static const Shortint SQL_KEYSET_SIZE_DEFAULT = 0x0;
static const Shortint SQL_SC_NON_UNIQUE = 0x0;
static const Shortint SQL_SC_TRY_UNIQUE = 0x1;
static const Shortint SQL_SC_UNIQUE = 0x2;
static const Shortint SQL_RD_OFF = 0x0;
static const Shortint SQL_RD_ON = 0x1;
static const Shortint SQL_RD_DEFAULT = 0x1;
static const Shortint SQL_UB_OFF = 0x0;
static const Shortint SQL_UB_ON = 0x1;
static const Shortint SQL_UB_DEFAULT = 0x0;
static const Shortint SQL_UB_FIXED = 0x1;
static const Shortint SQL_UB_VARIABLE = 0x2;
static const Shortint SQL_DATE = 0x9;
static const Shortint SQL_INTERVAL = 0xa;
static const Shortint SQL_TIME = 0xa;
static const Shortint SQL_TIMESTAMP = 0xb;
static const Shortint SQL_LONGVARCHAR = 0xffffffff;
static const Shortint SQL_BINARY = 0xfffffffe;
static const Shortint SQL_VARBINARY = 0xfffffffd;
static const Shortint SQL_LONGVARBINARY = 0xfffffffc;
static const Shortint SQL_BIGINT = 0xfffffffb;
static const Shortint SQL_TINYINT = 0xfffffffa;
static const Shortint SQL_BIT = 0xfffffff9;
static const Shortint SQL_GUID = 0xfffffff5;
static const Shortint SQL_CODE_YEAR = 0x1;
static const Shortint SQL_CODE_MONTH = 0x2;
static const Shortint SQL_CODE_DAY = 0x3;
static const Shortint SQL_CODE_HOUR = 0x4;
static const Shortint SQL_CODE_MINUTE = 0x5;
static const Shortint SQL_CODE_SECOND = 0x6;
static const Shortint SQL_CODE_YEAR_TO_MONTH = 0x7;
static const Shortint SQL_CODE_DAY_TO_HOUR = 0x8;
static const Shortint SQL_CODE_DAY_TO_MINUTE = 0x9;
static const Shortint SQL_CODE_DAY_TO_SECOND = 0xa;
static const Shortint SQL_CODE_HOUR_TO_MINUTE = 0xb;
static const Shortint SQL_CODE_HOUR_TO_SECOND = 0xc;
static const Shortint SQL_CODE_MINUTE_TO_SECOND = 0xd;
static const Shortint SQL_INTERVAL_YEAR = 0x65;
static const Shortint SQL_INTERVAL_MONTH = 0x66;
static const Shortint SQL_INTERVAL_DAY = 0x67;
static const Shortint SQL_INTERVAL_HOUR = 0x68;
static const Shortint SQL_INTERVAL_MINUTE = 0x69;
static const Shortint SQL_INTERVAL_SECOND = 0x6a;
static const Shortint SQL_INTERVAL_YEAR_TO_MONTH = 0x6b;
static const Shortint SQL_INTERVAL_DAY_TO_HOUR = 0x6c;
static const Shortint SQL_INTERVAL_DAY_TO_MINUTE = 0x6d;
static const Shortint SQL_INTERVAL_DAY_TO_SECOND = 0x6e;
static const Shortint SQL_INTERVAL_HOUR_TO_MINUTE = 0x6f;
static const Shortint SQL_INTERVAL_HOUR_TO_SECOND = 0x70;
static const Shortint SQL_INTERVAL_MINUTE_TO_SECOND = 0x71;
static const Shortint SQL_UNICODE = 0xffffffa1;
static const Shortint SQL_UNICODE_VARCHAR = 0xffffffa0;
static const Shortint SQL_UNICODE_LONGVARCHAR = 0xffffff9f;
static const Shortint SQL_UNICODE_CHAR = 0xffffffa1;
static const Shortint SQL_TYPE_DRIVER_START = 0x65;
static const Shortint SQL_TYPE_DRIVER_END = 0xffffff9f;
static const Shortint SQL_C_CHAR = 0x1;
static const Shortint SQL_C_LONG = 0x4;
static const Shortint SQL_C_SHORT = 0x5;
static const Shortint SQL_C_FLOAT = 0x7;
static const Shortint SQL_C_DOUBLE = 0x8;
static const Shortint SQL_C_NUMERIC = 0x2;
static const Shortint SQL_C_DEFAULT = 0x63;
static const Shortint SQL_SIGNED_OFFSET = 0xffffffec;
static const Shortint SQL_UNSIGNED_OFFSET = 0xffffffea;
static const Shortint SQL_C_DATE = 0x9;
static const Shortint SQL_C_TIME = 0xa;
static const