📄 sqlfront.h
字号:
// Error code returns
#define INT_EXIT 0
#define INT_CONTINUE 1
#define INT_CANCEL 2
// dboptions
#define DBBUFFER 0
#define DBOFFSET 1
#define DBROWCOUNT 2
#define DBSTAT 3
#define DBTEXTLIMIT 4
#define DBTEXTSIZE 5
#define DBARITHABORT 6
#define DBARITHIGNORE 7
#define DBNOAUTOFREE 8
#define DBNOCOUNT 9
#define DBNOEXEC 10
#define DBPARSEONLY 11
#define DBSHOWPLAN 12
#define DBSTORPROCID 13
#if defined(DBMSWIN) || defined(DBNTWIN32)
#define DBANSItoOEM 14
#endif
#ifdef DBNTWIN32
#define DBOEMtoANSI 15
#endif
#define DBCLIENTCURSORS 16
#define DBSETTIME 17
#define DBQUOTEDIDENT 18
// Data Type Tokens
#define SQLVOID 0x1f
#define SQLTEXT 0x23
#define SQLVARBINARY 0x25
#define SQLINTN 0x26
#define SQLVARCHAR 0x27
#define SQLBINARY 0x2d
#define SQLIMAGE 0x22
#define SQLCHAR 0x2f
#define SQLINT1 0x30
#define SQLBIT 0x32
#define SQLINT2 0x34
#define SQLINT4 0x38
#define SQLMONEY 0x3c
#define SQLDATETIME 0x3d
#define SQLFLT8 0x3e
#define SQLFLTN 0x6d
#define SQLMONEYN 0x6e
#define SQLDATETIMN 0x6f
#define SQLFLT4 0x3b
#define SQLMONEY4 0x7a
#define SQLDATETIM4 0x3a
#define SQLDECIMAL 0x6a
#define SQLNUMERIC 0x6c
// Data stream tokens
#define SQLCOLFMT 0xa1
#define OLD_SQLCOLFMT 0x2a
#define SQLPROCID 0x7c
#define SQLCOLNAME 0xa0
#define SQLTABNAME 0xa4
#define SQLCOLINFO 0xa5
#define SQLALTNAME 0xa7
#define SQLALTFMT 0xa8
#define SQLERROR 0xaa
#define SQLINFO 0xab
#define SQLRETURNVALUE 0xac
#define SQLRETURNSTATUS 0x79
#define SQLRETURN 0xdb
#define SQLCONTROL 0xae
#define SQLALTCONTROL 0xaf
#define SQLROW 0xd1
#define SQLALTROW 0xd3
#define SQLDONE 0xfd
#define SQLDONEPROC 0xfe
#define SQLDONEINPROC 0xff
#define SQLOFFSET 0x78
#define SQLORDER 0xa9
#define SQLLOGINACK 0xad // NOTICE: change to real value
// Ag op tokens
#define SQLAOPCNT 0x4b
#define SQLAOPSUM 0x4d
#define SQLAOPAVG 0x4f
#define SQLAOPMIN 0x51
#define SQLAOPMAX 0x52
#define SQLAOPANY 0x53
#define SQLAOPNOOP 0x56
// Error numbers (dberrs) DB-Library error codes
#define SQLEMEM 10000
#define SQLENULL 10001
#define SQLENLOG 10002
#define SQLEPWD 10003
#define SQLECONN 10004
#define SQLEDDNE 10005
#define SQLENULLO 10006
#define SQLESMSG 10007
#define SQLEBTOK 10008
#define SQLENSPE 10009
#define SQLEREAD 10010
#define SQLECNOR 10011
#define SQLETSIT 10012
#define SQLEPARM 10013
#define SQLEAUTN 10014
#define SQLECOFL 10015
#define SQLERDCN 10016
#define SQLEICN 10017
#define SQLECLOS 10018
#define SQLENTXT 10019
#define SQLEDNTI 10020
#define SQLETMTD 10021
#define SQLEASEC 10022
#define SQLENTLL 10023
#define SQLETIME 10024
#define SQLEWRIT 10025
#define SQLEMODE 10026
#define SQLEOOB 10027
#define SQLEITIM 10028
#define SQLEDBPS 10029
#define SQLEIOPT 10030
#define SQLEASNL 10031
#define SQLEASUL 10032
#define SQLENPRM 10033
#define SQLEDBOP 10034
#define SQLENSIP 10035
#define SQLECNULL 10036
#define SQLESEOF 10037
#define SQLERPND 10038
#define SQLECSYN 10039
#define SQLENONET 10040
#define SQLEBTYP 10041
#define SQLEABNC 10042
#define SQLEABMT 10043
#define SQLEABNP 10044
#define SQLEBNCR 10045
#define SQLEAAMT 10046
#define SQLENXID 10047
#define SQLEIFNB 10048
#define SQLEKBCO 10049
#define SQLEBBCI 10050
#define SQLEKBCI 10051
#define SQLEBCWE 10052
#define SQLEBCNN 10053
#define SQLEBCOR 10054
#define SQLEBCPI 10055
#define SQLEBCPN 10056
#define SQLEBCPB 10057
#define SQLEVDPT 10058
#define SQLEBIVI 10059
#define SQLEBCBC 10060
#define SQLEBCFO 10061
#define SQLEBCVH 10062
#define SQLEBCUO 10063
#define SQLEBUOE 10064
#define SQLEBWEF 10065
#define SQLEBTMT 10066
#define SQLEBEOF 10067
#define SQLEBCSI 10068
#define SQLEPNUL 10069
#define SQLEBSKERR 10070
#define SQLEBDIO 10071
#define SQLEBCNT 10072
#define SQLEMDBP 10073
#define SQLINIT 10074
#define SQLCRSINV 10075
#define SQLCRSCMD 10076
#define SQLCRSNOIND 10077
#define SQLCRSDIS 10078
#define SQLCRSAGR 10079
#define SQLCRSORD 10080
#define SQLCRSMEM 10081
#define SQLCRSBSKEY 10082
#define SQLCRSNORES 10083
#define SQLCRSVIEW 10084
#define SQLCRSBUFR 10085
#define SQLCRSFROWN 10086
#define SQLCRSBROL 10087
#define SQLCRSFRAND 10088
#define SQLCRSFLAST 10089
#define SQLCRSRO 10090
#define SQLCRSTAB 10091
#define SQLCRSUPDTAB 10092
#define SQLCRSUPDNB 10093
#define SQLCRSVIIND 10094
#define SQLCRSNOUPD 10095
#define SQLCRSOS2 10096
#define SQLEBCSA 10097
#define SQLEBCRO 10098
#define SQLEBCNE 10099
#define SQLEBCSK 10100
#define SQLEUVBF 10101
#define SQLEBIHC 10102
#define SQLEBWFF 10103
#define SQLNUMVAL 10104
#define SQLEOLDVR 10105
#define SQLEBCPS 10106
#define SQLEDTC 10107
#define SQLENOTIMPL 10108
#define SQLENONFLOAT 10109
#define SQLECONNFB 10110
// The severity levels are defined here
#define EXINFO 1 // Informational, non-error
#define EXUSER 2 // User error
#define EXNONFATAL 3 // Non-fatal error
#define EXCONVERSION 4 // Error in DB-LIBRARY data conversion
#define EXSERVER 5 // The Server has returned an error flag
#define EXTIME 6 // We have exceeded our timeout period while
// waiting for a response from the Server - the
// DBPROCESS is still alive
#define EXPROGRAM 7 // Coding error in user program
#define EXRESOURCE 8 // Running out of resources - the DBPROCESS may be dead
#define EXCOMM 9 // Failure in communication with Server - the DBPROCESS is dead
#define EXFATAL 10 // Fatal error - the DBPROCESS is dead
#define EXCONSISTENCY 11 // Internal software error - notify MS Technical Supprt
// Offset identifiers
#define OFF_SELECT 0x16d
#define OFF_FROM 0x14f
#define OFF_ORDER 0x165
#define OFF_COMPUTE 0x139
#define OFF_TABLE 0x173
#define OFF_PROCEDURE 0x16a
#define OFF_STATEMENT 0x1cb
#define OFF_PARAM 0x1c4
#define OFF_EXEC 0x12c
// Print lengths for certain fixed length data types
#define PRINT4 11
#define PRINT2 6
#define PRINT1 3
#define PRFLT8 20
#define PRMONEY 26
#define PRBIT 3
#define PRDATETIME 27
#define PRDECIMAL (MAXNUMERICDIG + 2)
#define PRNUMERIC (MAXNUMERICDIG + 2)
#define SUCCEED 1
#define FAIL 0
#define SUCCEED_ABORT 2
#define DBUNKNOWN 2
#define MORE_ROWS -1
#define NO_MORE_ROWS -2
#define REG_ROW MORE_ROWS
#define BUF_FULL -3
// Status code for dbresults(). Possible return values are
// SUCCEED, FAIL, and NO_MORE_RESULTS.
#define NO_MORE_RESULTS 2
#define NO_MORE_RPC_RESULTS 3
// Macros for dbsetlname()
#define DBSETHOST 1
#define DBSETUSER 2
#define DBSETPWD 3
#define DBSETAPP 4
#define DBSETID 5
#define DBSETLANG 6
#define DBSETSECURE 7
#define DBVER42 8
#define DBVER60 9
#define DBSETLOGINTIME 10
#define DBSETFALLBACK 12
// Standard exit and error values
#define STDEXIT 0
#define ERREXIT -1
// dbrpcinit flags
#define DBRPCRECOMPILE 0x0001
#define DBRPCRESET 0x0004
#define DBRPCCURSOR 0x0008
// dbrpcparam flags
#define DBRPCRETURN 0x1
#define DBRPCDEFAULT 0x2
// Cursor related constants
// Following flags are used in the concuropt parameter in the dbcursoropen function
#define CUR_READONLY 1 // Read only cursor, no data modifications
#define CUR_LOCKCC 2 // Intent to update, all fetched data locked when
// dbcursorfetch is called inside a transaction block
#define CUR_OPTCC 3 // Optimistic concurrency control, data modifications
// succeed only if the row hasn't been updated since
// the last fetch.
#define CUR_OPTCCVAL 4 // Optimistic concurrency control based on selected column values
// Following flags are used in the scrollopt parameter in dbcursoropen
#define CUR_FORWARD 0 // Forward only scrolling
#define CUR_KEYSET -1 // Keyset driven scrolling
#define CUR_DYNAMIC 1 // Fully dynamic
#define CUR_INSENSITIVE -2 // Server-side cursors only
// Following flags define the fetchtype in the dbcursorfetch function
#define FETCH_FIRST 1 // Fetch first n rows
#define FETCH_NEXT 2 // Fetch next n rows
#define FETCH_PREV 3 // Fetch previous n rows
#define FETCH_RANDOM 4 // Fetch n rows beginning with given row #
#define FETCH_RELATIVE 5 // Fetch relative to previous fetch row #
#define FETCH_LAST 6 // Fetch the last n rows
// Following flags define the per row status as filled by dbcursorfetch and/or dbcursorfetchex
#define FTC_EMPTY 0x00 // No row available
#define FTC_SUCCEED 0x01 // Fetch succeeded, (failed if not set)
#define FTC_MISSING 0x02 // The row is missing
#define FTC_ENDOFKEYSET 0x04 // End of the keyset reached
#define FTC_ENDOFRESULTS 0x08 // End of results set reached
// Following flags define the operator types for the dbcursor function
#define CRS_UPDATE 1 // Update operation
#define CRS_DELETE 2 // Delete operation
#define CRS_INSERT 3 // Insert operation
#define CRS_REFRESH 4 // Refetch given row
#define CRS_LOCKCC 5 // Lock given row
// Following value can be passed to the dbcursorbind function for NOBIND type
#define NOBIND -2 // Return length and pointer to data
// Following are values used by DBCURSORINFO's Type parameter
#define CU_CLIENT 0x00000001
#define CU_SERVER 0x00000002
#define CU_KEYSET 0x00000004
#define CU_MIXED 0x00000008
#define CU_DYNAMIC 0x00000010
#define CU_FORWARD 0x00000020
#define CU_INSENSITIVE 0x00000040
#define CU_READONLY 0x00000080
#define CU_LOCKCC 0x00000100
#define CU_OPTCC 0x00000200
#define CU_OPTCCVAL 0x00000400
// Following are values used by DBCURSORINFO's Status parameter
#define CU_FILLING 0x00000001
#define CU_FILLED 0x00000002
// Following are values used by dbupdatetext's type parameter
#define UT_TEXTPTR 0x0001
#define UT_TEXT 0x0002
#define UT_MORETEXT 0x0004
#define UT_DELETEONLY 0x0008
#define UT_LOG 0x0010
// The following values are passed to dbserverenum for searching criteria.
#define NET_SEARCH 0x0001
#define LOC_SEARCH 0x0002
// These constants are the possible return values from dbserverenum.
#define ENUM_SUCCESS 0x0000
#define MORE_DATA 0x0001
#define NET_NOT_AVAIL 0x0002
#define OUT_OF_MEMORY 0x0004
#define NOT_SUPPORTED 0x0008
#define ENUM_INVALID_PARAM 0x0010
// Netlib Error problem codes. ConnectionError() should return one of
// these as the dblib-mapped problem code, so the corresponding string
// is sent to the dblib app's error handler as dberrstr. Return NE_E_NOMAP
// for a generic DB-Library error string (as in prior versions of dblib).
#define NE_E_NOMAP 0 // No string; uses dblib default.
#define NE_E_NOMEMORY 1 // Insufficient memory.
#define NE_E_NOACCESS 2 // Access denied.
#define NE_E_CONNBUSY 3 // Connection is busy.
#define NE_E_CONNBROKEN 4 // Connection broken.
#define NE_E_TOOMANYCONN 5 // Connection limit exceeded.
#define NE_E_SERVERNOTFOUND 6 // Specified SQL server not found.
#define NE_E_NETNOTSTARTED 7 // The network has not been started.
#define NE_E_NORESOURCE 8 // Insufficient network resources.
#define NE_E_NETBUSY 9 // Network is busy.
#define NE_E_NONETACCESS 10 // Network access denied.
#define NE_E_GENERAL 11 // General network error. Check your documentation.
#define NE_E_CONNMODE 12 // Incorrect connection mode.
#define NE_E_NAMENOTFOUND 13 // Name not found in directory service.
#define NE_E_INVALIDCONN 14 // Invalid connection.
#define NE_E_NETDATAERR 15 // Error reading or writing network data.
#define NE_E_TOOMANYFILES 16 // Too many open file handles.
#define NE_E_CANTCONNECT 17 // SQL Server does not exist or access denied.
#define NE_MAX_NETERROR 17
#ifdef __cplusplus
}
#endif
#pragma option pop /*P_O_Pop*/
#endif // _INC_SQLFRONT
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -