📄 sqlext.h
字号:
/* SQL_SIMULATE_CURSOR options */#define SQL_SC_NON_UNIQUE 0UL#define SQL_SC_TRY_UNIQUE 1UL#define SQL_SC_UNIQUE 2UL/* SQL_RETRIEVE_DATA options */#define SQL_RD_OFF 0UL#define SQL_RD_ON 1UL#define SQL_RD_DEFAULT SQL_RD_ON/* SQL_USE_BOOKMARKS options */#define SQL_UB_OFF 0UL#define SQL_UB_ON 01UL#define SQL_UB_DEFAULT SQL_UB_OFF/* New values for SQL_USE_BOOKMARKS attribute */#if (ODBCVER >= 0x0300)#define SQL_UB_FIXED SQL_UB_ON#define SQL_UB_VARIABLE 2UL#endif /* ODBCVER >= 0x0300 *//* extended descriptor field */#if (ODBCVER >= 0x0300)#define SQL_DESC_ARRAY_SIZE 20#define SQL_DESC_ARRAY_STATUS_PTR 21#define SQL_DESC_AUTO_UNIQUE_VALUE SQL_COLUMN_AUTO_INCREMENT#define SQL_DESC_BASE_COLUMN_NAME 22#define SQL_DESC_BASE_TABLE_NAME 23#define SQL_DESC_BIND_OFFSET_PTR 24#define SQL_DESC_BIND_TYPE 25#define SQL_DESC_CASE_SENSITIVE SQL_COLUMN_CASE_SENSITIVE#define SQL_DESC_CATALOG_NAME SQL_COLUMN_QUALIFIER_NAME#define SQL_DESC_CONCISE_TYPE SQL_COLUMN_TYPE#define SQL_DESC_DATETIME_INTERVAL_PRECISION 26#define SQL_DESC_DISPLAY_SIZE SQL_COLUMN_DISPLAY_SIZE#define SQL_DESC_FIXED_PREC_SCALE SQL_COLUMN_MONEY#define SQL_DESC_LABEL SQL_COLUMN_LABEL#define SQL_DESC_LITERAL_PREFIX 27#define SQL_DESC_LITERAL_SUFFIX 28#define SQL_DESC_LOCAL_TYPE_NAME 29#define SQL_DESC_MAXIMUM_SCALE 30#define SQL_DESC_MINIMUM_SCALE 31#define SQL_DESC_NUM_PREC_RADIX 32#define SQL_DESC_PARAMETER_TYPE 33#define SQL_DESC_ROWS_PROCESSED_PTR 34#if (ODBCVER >= 0x0350)#define SQL_DESC_ROWVER 35#endif /* ODBCVER >= 0x0350 */#define SQL_DESC_SCHEMA_NAME SQL_COLUMN_OWNER_NAME#define SQL_DESC_SEARCHABLE SQL_COLUMN_SEARCHABLE#define SQL_DESC_TYPE_NAME SQL_COLUMN_TYPE_NAME#define SQL_DESC_TABLE_NAME SQL_COLUMN_TABLE_NAME#define SQL_DESC_UNSIGNED SQL_COLUMN_UNSIGNED#define SQL_DESC_UPDATABLE SQL_COLUMN_UPDATABLE#endif /* ODBCVER >= 0x0300 *//* defines for diagnostics fields */#if (ODBCVER >= 0x0300)#define SQL_DIAG_CURSOR_ROW_COUNT (-1249)#define SQL_DIAG_ROW_NUMBER (-1248)#define SQL_DIAG_COLUMN_NUMBER (-1247)#endif /* ODBCVER >= 0x0300 *//* SQL extended datatypes */#define SQL_DATE 9#if (ODBCVER >= 0x0300)#define SQL_INTERVAL 10#endif /* ODBCVER >= 0x0300 */#define SQL_TIME 10#define SQL_TIMESTAMP 11#define SQL_LONGVARCHAR (-1)#define SQL_BINARY (-2)#define SQL_VARBINARY (-3)#define SQL_LONGVARBINARY (-4)#define SQL_BIGINT (-5)#define SQL_TINYINT (-6)#define SQL_BIT (-7)#if (ODBCVER >= 0x0350)#define SQL_GUID (-11)#endif /* ODBCVER >= 0x0350 */#if (ODBCVER >= 0x0300)/* interval code */#define SQL_CODE_YEAR 1#define SQL_CODE_MONTH 2#define SQL_CODE_DAY 3#define SQL_CODE_HOUR 4#define SQL_CODE_MINUTE 5#define SQL_CODE_SECOND 6#define SQL_CODE_YEAR_TO_MONTH 7#define SQL_CODE_DAY_TO_HOUR 8#define SQL_CODE_DAY_TO_MINUTE 9#define SQL_CODE_DAY_TO_SECOND 10#define SQL_CODE_HOUR_TO_MINUTE 11#define SQL_CODE_HOUR_TO_SECOND 12#define SQL_CODE_MINUTE_TO_SECOND 13#define SQL_INTERVAL_YEAR (100 + SQL_CODE_YEAR)#define SQL_INTERVAL_MONTH (100 + SQL_CODE_MONTH)#define SQL_INTERVAL_DAY (100 + SQL_CODE_DAY)#define SQL_INTERVAL_HOUR (100 + SQL_CODE_HOUR)#define SQL_INTERVAL_MINUTE (100 + SQL_CODE_MINUTE)#define SQL_INTERVAL_SECOND (100 + SQL_CODE_SECOND)#define SQL_INTERVAL_YEAR_TO_MONTH (100 + SQL_CODE_YEAR_TO_MONTH)#define SQL_INTERVAL_DAY_TO_HOUR (100 + SQL_CODE_DAY_TO_HOUR)#define SQL_INTERVAL_DAY_TO_MINUTE (100 + SQL_CODE_DAY_TO_MINUTE)#define SQL_INTERVAL_DAY_TO_SECOND (100 + SQL_CODE_DAY_TO_SECOND)#define SQL_INTERVAL_HOUR_TO_MINUTE (100 + SQL_CODE_HOUR_TO_MINUTE)#define SQL_INTERVAL_HOUR_TO_SECOND (100 + SQL_CODE_HOUR_TO_SECOND)#define 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 */#if (ODBCVER <= 0x0300)#define SQL_UNICODE (-95)#define SQL_UNICODE_VARCHAR (-96)#define SQL_UNICODE_LONGVARCHAR (-97)#define SQL_UNICODE_CHAR SQL_UNICODE#else/* The previous definitions for SQL_UNICODE_ are historical and obsolete */#define SQL_UNICODE SQL_WCHAR#define SQL_UNICODE_VARCHAR SQL_WVARCHAR#define SQL_UNICODE_LONGVARCHAR SQL_WLONGVARCHAR#define SQL_UNICODE_CHAR SQL_WCHAR#endif#if (ODBCVER < 0x0300)#define SQL_TYPE_DRIVER_START SQL_INTERVAL_YEAR#define SQL_TYPE_DRIVER_END SQL_UNICODE_LONGVARCHAR#endif /* ODBCVER < 0x0300 *//* C datatype to SQL datatype mapping SQL types ------------------- */#define SQL_C_CHAR SQL_CHAR /* CHAR, VARCHAR, DECIMAL, NUMERIC */#define SQL_C_LONG SQL_INTEGER /* INTEGER */#define SQL_C_SHORT SQL_SMALLINT /* SMALLINT */#define SQL_C_FLOAT SQL_REAL /* REAL */#define SQL_C_DOUBLE SQL_DOUBLE /* FLOAT, DOUBLE */#if (ODBCVER >= 0x0300)#define SQL_C_NUMERIC SQL_NUMERIC#endif /* ODBCVER >= 0x0300 */#define SQL_C_DEFAULT 99#define SQL_SIGNED_OFFSET (-20)#define SQL_UNSIGNED_OFFSET (-22)/* C datatype to SQL datatype mapping */#define SQL_C_DATE SQL_DATE#define SQL_C_TIME SQL_TIME#define SQL_C_TIMESTAMP SQL_TIMESTAMP#if (ODBCVER >= 0x0300)#define SQL_C_TYPE_DATE SQL_TYPE_DATE#define SQL_C_TYPE_TIME SQL_TYPE_TIME#define SQL_C_TYPE_TIMESTAMP SQL_TYPE_TIMESTAMP#define SQL_C_INTERVAL_YEAR SQL_INTERVAL_YEAR#define SQL_C_INTERVAL_MONTH SQL_INTERVAL_MONTH#define SQL_C_INTERVAL_DAY SQL_INTERVAL_DAY#define SQL_C_INTERVAL_HOUR SQL_INTERVAL_HOUR#define SQL_C_INTERVAL_MINUTE SQL_INTERVAL_MINUTE#define SQL_C_INTERVAL_SECOND SQL_INTERVAL_SECOND#define SQL_C_INTERVAL_YEAR_TO_MONTH SQL_INTERVAL_YEAR_TO_MONTH#define SQL_C_INTERVAL_DAY_TO_HOUR SQL_INTERVAL_DAY_TO_HOUR#define SQL_C_INTERVAL_DAY_TO_MINUTE SQL_INTERVAL_DAY_TO_MINUTE#define SQL_C_INTERVAL_DAY_TO_SECOND SQL_INTERVAL_DAY_TO_SECOND#define SQL_C_INTERVAL_HOUR_TO_MINUTE SQL_INTERVAL_HOUR_TO_MINUTE#define SQL_C_INTERVAL_HOUR_TO_SECOND SQL_INTERVAL_HOUR_TO_SECOND#define SQL_C_INTERVAL_MINUTE_TO_SECOND SQL_INTERVAL_MINUTE_TO_SECOND#endif /* ODBCVER >= 0x0300 */#define SQL_C_BINARY SQL_BINARY#define SQL_C_BIT SQL_BIT#if (ODBCVER >= 0x0300)#define SQL_C_SBIGINT (SQL_BIGINT+SQL_SIGNED_OFFSET) /* SIGNED BIGINT */#define SQL_C_UBIGINT (SQL_BIGINT+SQL_UNSIGNED_OFFSET) /* UNSIGNED BIGINT */#endif /* ODBCVER >= 0x0300 */#define SQL_C_TINYINT SQL_TINYINT#define SQL_C_SLONG (SQL_C_LONG+SQL_SIGNED_OFFSET) /* SIGNED INTEGER */#define SQL_C_SSHORT (SQL_C_SHORT+SQL_SIGNED_OFFSET) /* SIGNED SMALLINT */#define SQL_C_STINYINT (SQL_TINYINT+SQL_SIGNED_OFFSET) /* SIGNED TINYINT */#define SQL_C_ULONG (SQL_C_LONG+SQL_UNSIGNED_OFFSET) /* UNSIGNED INTEGER */#define SQL_C_USHORT (SQL_C_SHORT+SQL_UNSIGNED_OFFSET) /* UNSIGNED SMALLINT */#define SQL_C_UTINYINT (SQL_TINYINT+SQL_UNSIGNED_OFFSET) /* UNSIGNED TINYINT */#if (ODBCVER >= 0x0300)#define SQL_C_BOOKMARK SQL_C_ULONG /* BOOKMARK */#else#if (SIZEOF_LONG == 8)#ifndef DO_YOU_KNOW_WHAT_YOUR_ARE_DOING#define SQL_C_BOOKMARK SQL_C_ULONG /* BOOKMARK */#else#define SQL_C_BOOKMARK SQL_C_UBIGINT /* BOOKMARK */#endif#else#define SQL_C_BOOKMARK SQL_C_ULONG /* BOOKMARK */#endif#endif#if (ODBCVER >= 0x0350)#define SQL_C_GUID SQL_GUID#endif /* ODBCVER >= 0x0350 */#define SQL_TYPE_NULL 0#if (ODBCVER < 0x0300)#define SQL_TYPE_MIN SQL_BIT#define SQL_TYPE_MAX SQL_VARCHAR#endif#if (ODBCVER >= 0x0300)#define SQL_C_VARBOOKMARK SQL_C_BINARY#endif /* ODBCVER >= 0x0300 *//* define for SQL_DIAG_ROW_NUMBER and SQL_DIAG_COLUMN_NUMBER */#if (ODBCVER >= 0x0300)#define SQL_NO_ROW_NUMBER (-1)#define SQL_NO_COLUMN_NUMBER (-1)#define SQL_ROW_NUMBER_UNKNOWN (-2)#define SQL_COLUMN_NUMBER_UNKNOWN (-2)#endif/* SQLBindParameter extensions */#define SQL_DEFAULT_PARAM (-5)#define SQL_IGNORE (-6)#if (ODBCVER >= 0x0300)#define SQL_COLUMN_IGNORE SQL_IGNORE#endif /* ODBCVER >= 0x0300 */#define SQL_LEN_DATA_AT_EXEC_OFFSET (-100)#define SQL_LEN_DATA_AT_EXEC(length) (-(length)+SQL_LEN_DATA_AT_EXEC_OFFSET)/* binary length for driver specific attributes */#define SQL_LEN_BINARY_ATTR_OFFSET (-100)#define SQL_LEN_BINARY_ATTR(length) (-(length)+SQL_LEN_BINARY_ATTR_OFFSET)/* Defines used by Driver Manager when mapping SQLSetParam to SQLBindParameter*/#define SQL_PARAM_TYPE_DEFAULT SQL_PARAM_INPUT_OUTPUT#define SQL_SETPARAM_VALUE_MAX (-1L)/* SQLColAttributes defines */#define SQL_COLUMN_COUNT 0#define SQL_COLUMN_NAME 1#define SQL_COLUMN_TYPE 2#define SQL_COLUMN_LENGTH 3#define SQL_COLUMN_PRECISION 4#define SQL_COLUMN_SCALE 5#define SQL_COLUMN_DISPLAY_SIZE 6#define SQL_COLUMN_NULLABLE 7#define SQL_COLUMN_UNSIGNED 8#define SQL_COLUMN_MONEY 9#define SQL_COLUMN_UPDATABLE 10#define SQL_COLUMN_AUTO_INCREMENT 11#define SQL_COLUMN_CASE_SENSITIVE 12#define SQL_COLUMN_SEARCHABLE 13#define SQL_COLUMN_TYPE_NAME 14#define SQL_COLUMN_TABLE_NAME 15#define SQL_COLUMN_OWNER_NAME 16#define SQL_COLUMN_QUALIFIER_NAME 17#define SQL_COLUMN_LABEL 18#define SQL_COLATT_OPT_MAX SQL_COLUMN_LABEL#if (ODBCVER < 0x0300)#define SQL_COLUMN_DRIVER_START 1000#endif /* ODBCVER < 0x0300 */#define SQL_COLATT_OPT_MIN SQL_COLUMN_COUNT/* SQLColAttributes subdefines for SQL_COLUMN_UPDATABLE */#define SQL_ATTR_READONLY 0#define SQL_ATTR_WRITE 1#define SQL_ATTR_READWRITE_UNKNOWN 2/* SQLColAttributes subdefines for SQL_COLUMN_SEARCHABLE *//* These are also used by SQLGetInfo */#define SQL_UNSEARCHABLE 0#define SQL_LIKE_ONLY 1#define SQL_ALL_EXCEPT_LIKE 2#define SQL_SEARCHABLE 3#define SQL_PRED_SEARCHABLE SQL_SEARCHABLE/* Special return values for SQLGetData */#define SQL_NO_TOTAL (-4)/********************************************//* SQLGetFunctions: additional values for *//* fFunction to represent functions that *//* are not in the X/Open spec. *//********************************************/#if (ODBCVER >= 0x0300)#define SQL_API_SQLALLOCHANDLESTD 73#define SQL_API_SQLBULKOPERATIONS 24#endif /* ODBCVER >= 0x0300 */#define SQL_API_SQLBINDPARAMETER 72#define SQL_API_SQLBROWSECONNECT 55#define SQL_API_SQLCOLATTRIBUTES 6#define SQL_API_SQLCOLUMNPRIVILEGES 56#define SQL_API_SQLDESCRIBEPARAM 58#define SQL_API_SQLDRIVERCONNECT 41#define SQL_API_SQLDRIVERS 71#define SQL_API_SQLEXTENDEDFETCH 59#define SQL_API_SQLFOREIGNKEYS 60#define SQL_API_SQLMORERESULTS 61#define SQL_API_SQLNATIVESQL 62#define SQL_API_SQLNUMPARAMS 63#define SQL_API_SQLPARAMOPTIONS 64#define SQL_API_SQLPRIMARYKEYS 65#define SQL_API_SQLPROCEDURECOLUMNS 66#define SQL_API_SQLPROCEDURES 67#define SQL_API_SQLSETPOS 68#define SQL_API_SQLSETSCROLLOPTIONS 69#define SQL_API_SQLTABLEPRIVILEGES 70/*-------------------------------------------*//* SQL_EXT_API_LAST is not useful with ODBC *//* version 3.0 because some of the values *//* from X/Open are in the 10000 range. *//*-------------------------------------------*/#if (ODBCVER < 0x0300)#define SQL_EXT_API_LAST SQL_API_SQLBINDPARAMETER#define SQL_NUM_FUNCTIONS 23#define SQL_EXT_API_START 40#define SQL_NUM_EXTENSIONS (SQL_EXT_API_LAST-SQL_EXT_API_START+1)#endif/*--------------------------------------------*/⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -