📄 sdodbc.pas
字号:
SQL_ATTR_AUTOCOMMIT = SQL_AUTOCOMMIT;
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_ODBC_CURSORS = SQL_ODBC_CURSORS;
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_ATTR_TXN_ISOLATION = SQL_TXN_ISOLATION;
//#endif /* ODBCVER >= 0x0300 */
SQL_ATTR_CONNECTION_DEAD = 1209; // GetConnectAttr only
// SQL_CONNECT_OPT_DRVR_START is not meaningful for 3.0 driver
//#if (ODBCVER < 0x0300)
SQL_CONNECT_OPT_DRVR_START = 1000;
//#endif /* ODBCVER < 0x0300 */
//#if (ODBCVER < 0x0300)
SQL_CONN_OPT_MAX = SQL_PACKET_SIZE;
SQL_CONN_OPT_MIN = SQL_ACCESS_MODE;
//#endif /* ODBCVER < 0x0300 */
// SQL_ACCESS_MODE options
SQL_MODE_READ_WRITE = 0;
SQL_MODE_READ_ONLY = 1;
SQL_MODE_DEFAULT = SQL_MODE_READ_WRITE;
// SQL_AUTOCOMMIT options
SQL_AUTOCOMMIT_OFF = 0;
SQL_AUTOCOMMIT_ON = 1;
SQL_AUTOCOMMIT_DEFAULT = SQL_AUTOCOMMIT_ON;
// SQL_LOGIN_TIMEOUT options
SQL_LOGIN_TIMEOUT_DEFAULT = 15;
// SQL_OPT_TRACE options
SQL_OPT_TRACE_OFF = 0;
SQL_OPT_TRACE_ON = 1;
SQL_OPT_TRACE_DEFAULT = SQL_OPT_TRACE_OFF;
SQL_OPT_TRACE_FILE_DEFAULT = '\SQL.LOG';
// SQL_ODBC_CURSORS options
SQL_CUR_USE_IF_NEEDED = 0;
SQL_CUR_USE_ODBC = 1;
SQL_CUR_USE_DRIVER = 2;
SQL_CUR_DEFAULT = SQL_CUR_USE_DRIVER;
//#if (ODBCVER >= 0x0300)
// values for SQL_ATTR_DISCONNECT_BEHAVIOR
SQL_DB_RETURN_TO_POOL = 0;
SQL_DB_DISCONNECT = 1;
SQL_DB_DEFAULT = SQL_DB_RETURN_TO_POOL;
// values for SQL_ATTR_ENLIST_IN_DTC
SQL_DTC_DONE = 0;
//#endif /* ODBCVER >= 0x0300 */
// values for SQL_ATTR_CONNECTION_DEAD
SQL_CD_TRUE = 1; // Connection is closed/dead
SQL_CD_FALSE = 0; // Connection is open/available
// statement attributes
SQL_QUERY_TIMEOUT = 0;
SQL_MAX_ROWS = 1;
SQL_NOSCAN = 2;
SQL_MAX_LENGTH = 3;
SQL_ASYNC_ENABLE = 4; // same as SQL_ATTR_ASYNC_ENABLE
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; // GetStmtOption Only
SQL_ROW_NUMBER = 14; // GetStmtOption Only
//#if (ODBCVER >= 0x0300)
// statement attributes for ODBC 3.0
SQL_ATTR_ASYNC_ENABLE = 4;
SQL_ATTR_CONCURRENCY = SQL_CONCURRENCY;
SQL_ATTR_CURSOR_TYPE = SQL_CURSOR_TYPE;
SQL_ATTR_ENABLE_AUTO_IPD = 15;
SQL_ATTR_FETCH_BOOKMARK_PTR = 16;
SQL_ATTR_KEYSET_SIZE = SQL_KEYSET_SIZE;
SQL_ATTR_MAX_LENGTH = SQL_MAX_LENGTH;
SQL_ATTR_MAX_ROWS = SQL_MAX_ROWS;
SQL_ATTR_NOSCAN = SQL_NOSCAN;
SQL_ATTR_PARAM_BIND_OFFSET_PTR= 17;
SQL_ATTR_PARAM_BIND_TYPE = 18;
SQL_ATTR_PARAM_OPERATION_PTR = 19;
SQL_ATTR_PARAM_STATUS_PTR = 20;
SQL_ATTR_PARAMS_PROCESSED_PTR = 21;
SQL_ATTR_PARAMSET_SIZE = 22;
SQL_ATTR_QUERY_TIMEOUT = SQL_QUERY_TIMEOUT;
SQL_ATTR_RETRIEVE_DATA = SQL_RETRIEVE_DATA;
SQL_ATTR_ROW_BIND_OFFSET_PTR = 23;
SQL_ATTR_ROW_BIND_TYPE = SQL_BIND_TYPE;
SQL_ATTR_ROW_NUMBER = SQL_ROW_NUMBER; // GetStmtAttr
SQL_ATTR_ROW_OPERATION_PTR = 24;
SQL_ATTR_ROW_STATUS_PTR = 25;
SQL_ATTR_ROWS_FETCHED_PTR = 26;
SQL_ATTR_ROW_ARRAY_SIZE = 27;
SQL_ATTR_SIMULATE_CURSOR = SQL_SIMULATE_CURSOR;
SQL_ATTR_USE_BOOKMARKS = SQL_USE_BOOKMARKS;
//#endif /* ODBCVER >= 0x0300 */
//#if (ODBCVER < 0x0300)
SQL_STMT_OPT_MAX = SQL_ROW_NUMBER;
SQL_STMT_OPT_MIN = SQL_QUERY_TIMEOUT;
//#endif /* ODBCVER < 0x0300 */
//#if (ODBCVER >= 0x0300)
// whether an attribute is a pointer or not
SQL_IS_POINTER = (-4);
SQL_IS_UINTEGER = (-5);
SQL_IS_INTEGER = (-6);
SQL_IS_USMALLINT = (-7);
SQL_IS_SMALLINT = (-8);
// the value of SQL_ATTR_PARAM_BIND_TYPE
SQL_PARAM_BIND_BY_COLUMN = 0;
SQL_PARAM_BIND_TYPE_DEFAULT = SQL_PARAM_BIND_BY_COLUMN;
//#endif /* ODBCVER >= 0x0300 */
// SQL_QUERY_TIMEOUT options
SQL_QUERY_TIMEOUT_DEFAULT = 0;
// SQL_MAX_ROWS options
SQL_MAX_ROWS_DEFAULT = 0;
// SQL_NOSCAN options
SQL_NOSCAN_OFF = 0; // 1.0 FALSE
SQL_NOSCAN_ON = 1; // 1.0 TRUE
SQL_NOSCAN_DEFAULT = SQL_NOSCAN_OFF;
// SQL_MAX_LENGTH options
SQL_MAX_LENGTH_DEFAULT = 0;
// values for SQL_ATTR_ASYNC_ENABLE
SQL_ASYNC_ENABLE_OFF = 0;
SQL_ASYNC_ENABLE_ON = 1;
SQL_ASYNC_ENABLE_DEFAULT = SQL_ASYNC_ENABLE_OFF;
// SQL_BIND_TYPE options
SQL_BIND_BY_COLUMN = 0;
SQL_BIND_TYPE_DEFAULT = SQL_BIND_BY_COLUMN; // Default value
// SQL_CONCURRENCY options
SQL_CONCUR_READ_ONLY = 1;
SQL_CONCUR_LOCK = 2;
SQL_CONCUR_ROWVER = 3;
SQL_CONCUR_VALUES = 4;
SQL_CONCUR_DEFAULT = SQL_CONCUR_READ_ONLY; // Default value
// SQL_CURSOR_TYPE options
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; // Default value
// SQL_ROWSET_SIZE options
SQL_ROWSET_SIZE_DEFAULT = 1;
// SQL_KEYSET_SIZE options
SQL_KEYSET_SIZE_DEFAULT = 0;
// SQL_SIMULATE_CURSOR options
SQL_SC_NON_UNIQUE = 0;
SQL_SC_TRY_UNIQUE = 1;
SQL_SC_UNIQUE = 2;
// SQL_RETRIEVE_DATA options
SQL_RD_OFF = 0;
SQL_RD_ON = 1;
SQL_RD_DEFAULT = SQL_RD_ON;
// SQL_USE_BOOKMARKS options
SQL_UB_OFF = 0;
SQL_UB_ON = 1;
SQL_UB_DEFAULT = SQL_UB_OFF;
//#if (ODBCVER >= 0x0300)
// New values for SQL_USE_BOOKMARKS attribute
SQL_UB_FIXED = SQL_UB_ON;
SQL_UB_VARIABLE = 2;
//#endif /* ODBCVER >= 0x0300 */
// SQL extended datatypes
SQL_DATE = 9;
//#if (ODBCVER >= 0x0300)
SQL_INTERVAL = 10;
//#endif /* ODBCVER >= 0x0300 */
SQL_TIME = 10;
SQL_TIMESTAMP = 11;
SQL_LONGVARCHAR = (-1);
SQL_BINARY = (-2);
SQL_VARBINARY = (-3);
SQL_LONGVARBINARY = (-4);
SQL_BIGINT = (-5);
SQL_TINYINT = (-6);
SQL_BIT = (-7);
//#if (ODBCVER >= 0x0350)
SQL_GUID = (-11);
//#endif /* ODBCVER >= 0x0350 */
//#if (ODBCVER >= 0x0300)
// interval code
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);
{#else
#define SQL_INTERVAL_YEAR (-80)
#define SQL_INTERVAL_MONTH (-81)
#define SQL_INTERVAL_YEAR_TO_MONTH (-82)
#define SQL_INTERVAL_DAY (-83)
#define SQL_INTERVAL_HOUR (-84)
#define SQL_INTERVAL_MINUTE (-85)
#define SQL_INTERVAL_SECOND (-86)
#define SQL_INTERVAL_DAY_TO_HOUR (-87)
#define SQL_INTERVAL_DAY_TO_MINUTE (-88)
#define SQL_INTERVAL_DAY_TO_SECOND (-89)
#define SQL_INTERVAL_HOUR_TO_MINUTE (-90)
#define SQL_INTERVAL_HOUR_TO_SECOND (-91)
#define SQL_INTERVAL_MINUTE_TO_SECOND (-92)
}
//#endif /* ODBCVER >= 0x0300 */
SQL_UNICODE = (-95);
SQL_UNICODE_VARCHAR = (-96);
SQL_UNICODE_LONGVARCHAR = (-97);
SQL_UNICODE_CHAR = SQL_UNICODE;
//#if (ODBCVER < 0x0300)
SQL_TYPE_DRIVER_START = SQL_INTERVAL_YEAR;
SQL_TYPE_DRIVER_END = SQL_UNICODE_LONGVARCHAR;
//#endif /* ODBCVER < 0x0300 */
// C datatype to SQL datatype mapping SQL types
SQL_C_CHAR = SQL_CHAR; // CHAR, VARCHAR, DECIMAL, NUMERIC
SQL_C_LONG = SQL_INTEGER; // INTEGER
SQL_C_SHORT = SQL_SMALLINT; // SMALLINT
SQL_C_FLOAT = SQL_REAL; // REAL
SQL_C_DOUBLE = SQL_DOUBLE; // FLOAT, DOUBLE
//#if (ODBCVER >= 0x0300)
SQL_C_NUMERIC = SQL_NUMERIC;
//#endif /* ODBCVER >= 0x0300 */
SQL_C_DEFAULT = 99;
SQL_SIGNED_OFFSET = (-20);
SQL_UNSIGNED_OFFSET = (-22);
// C datatype to SQL datatype mapping
SQL_C_DATE = SQL_DATE;
SQL_C_TIME = SQL_TIME;
SQL_C_TIMESTAMP = SQL_TIMESTAMP;
//#if (ODBCVER >= 0x0300)
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;
//#endif /* ODBCVER >= 0x0300 */
SQL_C_BINARY = SQL_BINARY;
SQL_C_BIT = SQL_BIT;
//#if (ODBCVER >= 0x0300)
SQL_C_SBIGINT = (SQL_BIGINT+SQL_SIGNED_OFFSET); // SIGNED BIGINT
SQL_C_UBIGINT = (SQL_BIGINT+SQL_UNSIGNED_OFFSET); // UNSIGNED BIGINT
//#endif /* ODBCVER >= 0x0300 */
SQL_C_TINYINT = SQL_TINYINT;
SQL_C_SLONG = (SQL_C_LONG+SQL_SIGNED_OFFSET); // SIGNED INTEGER
SQL_C_SSHORT = (SQL_C_SHORT+SQL_SIGNED_OFFSET); // SIGNED SMALLINT
SQL_C_STINYINT = (SQL_TINYINT+SQL_SIGNED_OFFSET); // SIGNED TINYINT
SQL_C_ULONG = (SQL_C_LONG+SQL_UNSIGNED_OFFSET); // UNSIGNED INTEGER
SQL_C_USHORT = (SQL_C_SHORT+SQL_UNSIGNED_OFFSET); // UNSIGNED SMALLINT
SQL_C_UTINYINT = (SQL_TINYINT+SQL_UNSIGNED_OFFSET); // UNSIGNED TINYINT
SQL_C_BOOKMARK = SQL_C_ULONG; // BOOKMARK
//#if (ODBCVER >= 0x0350)
SQL_C_GUID = SQL_GUID;
//#endif /* ODBCVER >= 0x0350 */
SQL_TYPE_NULL = 0;
//#if (ODBCVER < 0x0300)
SQL_TYPE_MIN = SQL_BIT;
SQL_TYPE_MAX = SQL_VARCHAR;
//#endif
//#if (ODBCVER >= 0x0300)
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -