Mercurial > projects > ddbg_continued
comparison win32/sqlext.d @ 1:4a9dcbd9e54f
-files of 0.13 beta
-fixes so that it now compiles with the current dmd version
author | marton@basel.hu |
---|---|
date | Tue, 05 Apr 2011 20:44:01 +0200 |
parents | |
children |
comparison
equal
deleted
inserted
replaced
0:586e4a649642 | 1:4a9dcbd9e54f |
---|---|
1 /***********************************************************************\ | |
2 * sqlext.d * | |
3 * * | |
4 * Windows API header module * | |
5 * * | |
6 * Translated from MinGW Windows headers * | |
7 * * | |
8 * Placed into public domain * | |
9 \***********************************************************************/ | |
10 module win32.sqlext; | |
11 | |
12 /* Conversion notes: | |
13 The MinGW file was a horrible mess. All of the #defines were sorted alphabetically, | |
14 which is crazy. This file needs a lot of work. | |
15 In MinGW, sqlext #includes sqlucode, but sqlucode #includes sqlext, | |
16 creating a circular dependency! | |
17 */ | |
18 | |
19 public import win32.sql; | |
20 private import win32.windef; | |
21 | |
22 const SQL_SPEC_MAJOR = 3; | |
23 const SQL_SPEC_MINOR = 51; | |
24 const char[] SQL_SPEC_STRING = "03.51"; | |
25 const SQL_ACCESS_MODE = 101; | |
26 const SQL_ACTIVE_CONNECTIONS = 0; | |
27 const SQL_ACTIVE_STATEMENTS = 1; | |
28 | |
29 const SQL_DATE = 9; | |
30 const SQL_TIME = 10; | |
31 const SQL_SIGNED_OFFSET = -20; | |
32 const SQL_TINYINT = -6; | |
33 const SQL_TIMESTAMP = 11; | |
34 const SQL_UNSIGNED_OFFSET = -22; | |
35 | |
36 const SQL_ADD = 4; | |
37 const SQL_ALL_EXCEPT_LIKE = 2; | |
38 | |
39 const SQL_API_ALL_FUNCTIONS = 0; | |
40 const SQL_API_SQLCOLATTRIBUTES = 6; | |
41 const SQL_API_SQLDRIVERCONNECT = 41; | |
42 const SQL_API_SQLBROWSECONNECT = 55; | |
43 const SQL_API_SQLCOLUMNPRIVILEGES = 56; | |
44 const SQL_API_SQLDESCRIBEPARAM = 58; | |
45 const SQL_API_SQLEXTENDEDFETCH = 59; | |
46 const SQL_API_SQLFOREIGNKEYS = 60; | |
47 const SQL_API_SQLMORERESULTS = 61; | |
48 const SQL_API_SQLNATIVESQL = 62; | |
49 const SQL_API_SQLNUMPARAMS = 63; | |
50 const SQL_API_SQLPARAMOPTIONS = 64; | |
51 const SQL_API_SQLPRIMARYKEYS = 65; | |
52 const SQL_API_SQLPROCEDURECOLUMNS = 66; | |
53 const SQL_API_SQLPROCEDURES = 67; | |
54 const SQL_API_SQLSETPOS = 68; | |
55 const SQL_API_SQLSETSCROLLOPTIONS = 69; | |
56 const SQL_API_SQLTABLEPRIVILEGES = 70; | |
57 const SQL_API_SQLDRIVERS = 71; | |
58 const SQL_API_SQLBINDPARAMETER = 72; | |
59 const SQL_API_LOADBYORDINAL = 199; | |
60 | |
61 const SQL_ASYNC_ENABLE = 4; | |
62 const SQL_ASYNC_ENABLE_OFF = 0UL; | |
63 const SQL_ASYNC_ENABLE_ON = 1UL; | |
64 const SQL_ASYNC_ENABLE_DEFAULT = SQL_ASYNC_ENABLE_OFF; | |
65 | |
66 const SQL_ATTR_CONNECTION_DEAD = 1209; | |
67 const SQL_ATTR_READONLY = 0; | |
68 const SQL_ATTR_READWRITE_UNKNOWN = 2; | |
69 const SQL_ATTR_WRITE = 1; | |
70 | |
71 const SQL_AUTOCOMMIT = 102; | |
72 const SQL_AUTOCOMMIT_OFF = 0UL; | |
73 const SQL_AUTOCOMMIT_ON = 1UL; | |
74 const SQL_AUTOCOMMIT_DEFAULT = SQL_AUTOCOMMIT_ON; | |
75 const SQL_BEST_ROWID = 1; | |
76 const SQL_BIGINT = -5; | |
77 const SQL_BINARY = -2; | |
78 const SQL_BIND_BY_COLUMN = 0UL; | |
79 const SQL_BIND_TYPE = 5; | |
80 const SQL_BIND_TYPE_DEFAULT = SQL_BIND_BY_COLUMN; | |
81 const SQL_BIT = -7; | |
82 | |
83 const SQL_BOOKMARK_PERSISTENCE = 82; | |
84 | |
85 // for BOOKMARK_PERSISTENCE | |
86 const SQL_BP_CLOSE = 1; | |
87 const SQL_BP_DELETE = 2; | |
88 const SQL_BP_DROP = 4; | |
89 const SQL_BP_TRANSACTION = 8; | |
90 const SQL_BP_UPDATE = 16; | |
91 const SQL_BP_OTHER_HSTMT = 32; | |
92 const SQL_BP_SCROLL = 64; | |
93 | |
94 const SQL_C_BINARY = SQL_BINARY; | |
95 const SQL_C_BIT = SQL_BIT; | |
96 const SQL_C_CHAR = SQL_CHAR; | |
97 const SQL_C_DATE = SQL_DATE; | |
98 const SQL_C_DOUBLE = SQL_DOUBLE; | |
99 const SQL_C_FLOAT = SQL_REAL; | |
100 const SQL_C_LONG = SQL_INTEGER; | |
101 const SQL_C_SHORT = SQL_SMALLINT; | |
102 const SQL_C_SLONG = SQL_C_LONG+SQL_SIGNED_OFFSET; | |
103 const SQL_C_SSHORT = SQL_C_SHORT+SQL_SIGNED_OFFSET; | |
104 const SQL_C_STINYINT = SQL_TINYINT+SQL_SIGNED_OFFSET; | |
105 const SQL_C_TIME = SQL_TIME; | |
106 const SQL_C_TIMESTAMP = SQL_TIMESTAMP; | |
107 const SQL_C_TINYINT = SQL_TINYINT; | |
108 const SQL_C_ULONG = SQL_C_LONG+SQL_UNSIGNED_OFFSET; | |
109 const SQL_C_USHORT = SQL_C_SHORT+SQL_UNSIGNED_OFFSET; | |
110 const SQL_C_UTINYINT = SQL_TINYINT+SQL_UNSIGNED_OFFSET; | |
111 const SQL_C_BOOKMARK = SQL_C_ULONG; | |
112 const SQL_C_DEFAULT = 99; | |
113 | |
114 const SQL_CASCADE = 0; | |
115 const SQL_CB_NON_NULL = 1; | |
116 const SQL_CB_NULL = 0; | |
117 deprecated { | |
118 const SQL_CC_CLOSE = SQL_CB_CLOSE;/* deprecated */ | |
119 const SQL_CC_DELETE = SQL_CB_DELETE;/* deprecated */ | |
120 const SQL_CC_PRESERVE = SQL_CB_PRESERVE;/* deprecated */ | |
121 } | |
122 const SQL_CD_FALSE = 0L; | |
123 const SQL_CD_TRUE = 1L; | |
124 | |
125 const SQL_CN_ANY = 2; | |
126 const SQL_CN_DIFFERENT = 1; | |
127 const SQL_CN_NONE = 0; | |
128 | |
129 const SQL_COLUMN_ALIAS = 87; | |
130 | |
131 const SQL_COLUMN_COUNT = 0; | |
132 const SQL_COLUMN_NAME = 1; | |
133 const SQL_COLUMN_DISPLAY_SIZE = 6; | |
134 const SQL_COLUMN_LABEL = 18; | |
135 const SQL_COLUMN_LENGTH = 3; | |
136 const SQL_COLUMN_MONEY = 9; | |
137 const SQL_COLUMN_NULLABLE = 7; | |
138 const SQL_COLUMN_OWNER_NAME = 16; | |
139 const SQL_COLUMN_PRECISION = 4; | |
140 const SQL_COLUMN_QUALIFIER_NAME = 17; | |
141 const SQL_COLUMN_SCALE = 5; | |
142 const SQL_COLUMN_UNSIGNED = 8; | |
143 const SQL_COLUMN_UPDATABLE = 10; | |
144 const SQL_COLUMN_AUTO_INCREMENT = 11; | |
145 const SQL_COLUMN_CASE_SENSITIVE = 12; | |
146 const SQL_COLUMN_SEARCHABLE = 13; | |
147 const SQL_COLUMN_TYPE = 2; | |
148 const SQL_COLUMN_TYPE_NAME = 14; | |
149 const SQL_COLUMN_TABLE_NAME = 15; | |
150 | |
151 const SQL_CONCAT_NULL_BEHAVIOR = 22; | |
152 | |
153 const SQL_CONCUR_READ_ONLY = 1; | |
154 const SQL_CONCUR_DEFAULT = SQL_CONCUR_READ_ONLY; | |
155 const SQL_CONCUR_LOCK = 2; | |
156 const SQL_CONCUR_ROWVER = 3; | |
157 const SQL_CONCUR_TIMESTAMP = SQL_CONCUR_ROWVER;/* deprecated */ | |
158 const SQL_CONCUR_VALUES = 4; | |
159 | |
160 const SQL_CONCURRENCY = 7; | |
161 const SQL_CONVERT_BIGINT = 53; | |
162 const SQL_CONVERT_BINARY = 54; | |
163 const SQL_CONVERT_BIT = 55; | |
164 const SQL_CONVERT_CHAR = 56; | |
165 const SQL_CONVERT_DATE = 57; | |
166 const SQL_CONVERT_DECIMAL = 58; | |
167 const SQL_CONVERT_DOUBLE = 59; | |
168 const SQL_CONVERT_FLOAT = 60; | |
169 const SQL_CONVERT_FUNCTIONS = 48; | |
170 const SQL_CONVERT_INTEGER = 61; | |
171 const SQL_CONVERT_LONGVARBINARY = 71; | |
172 const SQL_CONVERT_LONGVARCHAR = 62; | |
173 const SQL_CONVERT_NUMERIC = 63; | |
174 const SQL_CONVERT_REAL = 64; | |
175 const SQL_CONVERT_SMALLINT = 65; | |
176 const SQL_CONVERT_TIME = 66; | |
177 const SQL_CONVERT_TIMESTAMP = 67; | |
178 const SQL_CONVERT_TINYINT = 68; | |
179 const SQL_CONVERT_VARBINARY = 69; | |
180 const SQL_CONVERT_VARCHAR = 70; | |
181 const SQL_CORRELATION_NAME = 74; | |
182 const SQL_CR_CLOSE = SQL_CB_CLOSE;/* deprecated */ | |
183 const SQL_CR_DELETE = SQL_CB_DELETE;/* deprecated */ | |
184 const SQL_CR_PRESERVE = SQL_CB_PRESERVE;/* deprecated */ | |
185 | |
186 enum : ULONG { | |
187 SQL_CUR_USE_IF_NEEDED = 0, | |
188 SQL_CUR_USE_ODBC, | |
189 SQL_CUR_USE_DRIVER, | |
190 SQL_CUR_DEFAULT = SQL_CUR_USE_DRIVER | |
191 } | |
192 | |
193 const SQL_CURRENT_QUALIFIER = 109; | |
194 const SQL_CURSOR_DYNAMIC = 2UL; | |
195 const SQL_CURSOR_FORWARD_ONLY = 0UL; | |
196 const SQL_CURSOR_KEYSET_DRIVEN = 1UL; | |
197 const SQL_CURSOR_ROLLBACK_BEHAVIOR = 24; | |
198 const SQL_CURSOR_STATIC = 3UL; | |
199 const SQL_CURSOR_TYPE = 6; | |
200 const SQL_CURSOR_TYPE_DEFAULT = SQL_CURSOR_FORWARD_ONLY; | |
201 | |
202 const SQL_CV_CASCADED = 0x00000004L; | |
203 const SQL_CV_CHECK_OPTION = 0x00000002L; | |
204 const SQL_CV_CREATE_VIEW = 0x00000001L; | |
205 const SQL_CV_LOCAL = 0x00000008L; | |
206 const SQL_CVT_BIGINT = 0x00004000L; | |
207 const SQL_CVT_BINARY = 0x00000400L; | |
208 const SQL_CVT_BIT = 0x00001000L; | |
209 const SQL_CVT_CHAR = 0x00000001L; | |
210 const SQL_CVT_DATE = 0x00008000L; | |
211 const SQL_CVT_DECIMAL = 0x00000004L; | |
212 const SQL_CVT_DOUBLE = 0x00000080L; | |
213 const SQL_CVT_FLOAT = 0x00000020L; | |
214 const SQL_CVT_INTEGER = 0x00000008L; | |
215 const SQL_CVT_LONGVARBINARY = 0x00040000L; | |
216 const SQL_CVT_LONGVARCHAR = 0x00000200L; | |
217 const SQL_CVT_NUMERIC = 0x00000002L; | |
218 const SQL_CVT_REAL = 0x00000040L; | |
219 const SQL_CVT_SMALLINT = 0x00000010L; | |
220 const SQL_CVT_TIME = 0x00010000L; | |
221 const SQL_CVT_TIMESTAMP = 0x00020000L; | |
222 const SQL_CVT_TINYINT = 0x00002000L; | |
223 const SQL_CVT_VARBINARY = 0x00000800L; | |
224 const SQL_CVT_VARCHAR = 0x00000100L; | |
225 const SQL_DATABASE_NAME = 16;/* deprecated */ | |
226 | |
227 const SQL_DEFAULT_PARAM = -5; | |
228 const SQL_DELETE = 3; | |
229 | |
230 const SQL_DRIVER_COMPLETE = 1; | |
231 const SQL_DRIVER_COMPLETE_REQUIRED = 3; | |
232 const SQL_DRIVER_HDBC = 3; | |
233 const SQL_DRIVER_HENV = 4; | |
234 const SQL_DRIVER_HLIB = 76; | |
235 const SQL_DRIVER_HSTMT = 5; | |
236 const SQL_DRIVER_NAME = 6; | |
237 const SQL_DRIVER_NOPROMPT = 0; | |
238 const SQL_DRIVER_ODBC_VER = 77; | |
239 const SQL_DRIVER_PROMPT = 2; | |
240 const SQL_DRIVER_VER = 7; | |
241 | |
242 const SQL_DTC_ENLIST_EXPENSIVE = 1; | |
243 const SQL_DTC_UNENLIST_EXPENSIVE = 2; | |
244 const SQL_DTC_TRANSITION_COST = 1750; | |
245 const SQL_ENSURE = 1; | |
246 const SQL_ENTIRE_ROWSET = 0; | |
247 const SQL_EXPRESSIONS_IN_ORDERBY = 27; | |
248 const SQL_FD_FETCH_BOOKMARK = 128; | |
249 const SQL_FD_FETCH_PREV = SQL_FD_FETCH_PRIOR;/* deprecated */ | |
250 const SQL_FD_FETCH_RESUME = 64; | |
251 const SQL_FETCH_BOOKMARK = 8; | |
252 const SQL_FETCH_PREV = SQL_FETCH_PRIOR;/* deprecated */ | |
253 const SQL_FETCH_RESUME = 7;/* deprecated */ | |
254 | |
255 const SQL_FILE_NOT_SUPPORTED = 0x0000; | |
256 const SQL_FILE_TABLE = 0x0001; | |
257 const SQL_FILE_QUALIFIER = 0x0002; | |
258 const SQL_FILE_CATALOG = SQL_FILE_QUALIFIER; | |
259 const SQL_FILE_USAGE = 84; | |
260 | |
261 const SQL_FN_CVT_CONVERT = 0x00000001L; | |
262 const SQL_FN_NUM_ABS = 0x00000001L; | |
263 const SQL_FN_NUM_ACOS = 0x00000002L; | |
264 const SQL_FN_NUM_ASIN = 0x00000004L; | |
265 const SQL_FN_NUM_ATAN = 0x00000008L; | |
266 const SQL_FN_NUM_ATAN2 = 0x00000010L; | |
267 const SQL_FN_NUM_CEILING = 0x00000020L; | |
268 const SQL_FN_NUM_COS = 0x00000040L; | |
269 const SQL_FN_NUM_COT = 0x00000080L; | |
270 const SQL_FN_NUM_DEGREES = 0x00040000L; | |
271 const SQL_FN_NUM_EXP = 0x00000100L; | |
272 const SQL_FN_NUM_FLOOR = 0x00000200L; | |
273 const SQL_FN_NUM_LOG = 0x00000400L; | |
274 const SQL_FN_NUM_LOG10 = 0x00080000L; | |
275 const SQL_FN_NUM_MOD = 0x00000800L; | |
276 const SQL_FN_NUM_PI = 0x00010000L; | |
277 const SQL_FN_NUM_POWER = 0x00100000L; | |
278 const SQL_FN_NUM_RADIANS = 0x00200000L; | |
279 const SQL_FN_NUM_RAND = 0x00020000L; | |
280 const SQL_FN_NUM_ROUND = 0x00400000L; | |
281 const SQL_FN_NUM_SIGN = 0x00001000L; | |
282 const SQL_FN_NUM_SIN = 0x00002000L; | |
283 const SQL_FN_NUM_SQRT = 0x00004000L; | |
284 const SQL_FN_NUM_TAN = 0x00008000L; | |
285 const SQL_FN_NUM_TRUNCATE = 0x00800000L; | |
286 const SQL_FN_STR_ASCII = 0x00002000L; | |
287 const SQL_FN_STR_CHAR = 0x00004000L; | |
288 const SQL_FN_STR_CONCAT = 0x00000001L; | |
289 const SQL_FN_STR_DIFFERENCE = 0x00008000L; | |
290 const SQL_FN_STR_INSERT = 0x00000002L; | |
291 const SQL_FN_STR_LCASE = 0x00000040L; | |
292 const SQL_FN_STR_LEFT = 0x00000004L; | |
293 const SQL_FN_STR_LENGTH = 0x00000010L; | |
294 const SQL_FN_STR_LOCATE = 0x00000020L; | |
295 const SQL_FN_STR_LOCATE_2 = 0x00010000L; | |
296 const SQL_FN_STR_LTRIM = 0x00000008L; | |
297 const SQL_FN_STR_REPEAT = 0x00000080L; | |
298 const SQL_FN_STR_REPLACE = 0x00000100L; | |
299 const SQL_FN_STR_RIGHT = 0x00000200L; | |
300 const SQL_FN_STR_RTRIM = 0x00000400L; | |
301 const SQL_FN_STR_SOUNDEX = 0x00020000L; | |
302 const SQL_FN_STR_SPACE = 0x00040000L; | |
303 const SQL_FN_STR_SUBSTRING = 0x00000800L; | |
304 const SQL_FN_STR_UCASE = 0x00001000L; | |
305 const SQL_FN_SYS_DBNAME = 0x00000002L; | |
306 const SQL_FN_SYS_IFNULL = 0x00000004L; | |
307 const SQL_FN_SYS_USERNAME = 0x00000001L; | |
308 const SQL_FN_TD_CURDATE = 0x00000002L; | |
309 const SQL_FN_TD_CURTIME = 0x00000200L; | |
310 const SQL_FN_TD_DAYNAME = 0x00008000L; | |
311 const SQL_FN_TD_DAYOFMONTH = 0x00000004L; | |
312 const SQL_FN_TD_DAYOFWEEK = 0x00000008L; | |
313 const SQL_FN_TD_DAYOFYEAR = 0x00000010L; | |
314 const SQL_FN_TD_HOUR = 0x00000400L; | |
315 const SQL_FN_TD_MINUTE = 0x00000800L; | |
316 const SQL_FN_TD_MONTH = 0x00000020L; | |
317 const SQL_FN_TD_MONTHNAME = 0x00010000L; | |
318 const SQL_FN_TD_NOW = 0x00000001L; | |
319 const SQL_FN_TD_QUARTER = 0x00000040L; | |
320 const SQL_FN_TD_SECOND = 0x00001000L; | |
321 const SQL_FN_TD_TIMESTAMPADD = 0x00002000L; | |
322 const SQL_FN_TD_TIMESTAMPDIFF = 0x00004000L; | |
323 const SQL_FN_TD_WEEK = 0x00000080L; | |
324 const SQL_FN_TD_YEAR = 0x00000100L; | |
325 const SQL_FN_TSI_DAY = 0x00000010L; | |
326 const SQL_FN_TSI_FRAC_SECOND = 0x00000001L; | |
327 const SQL_FN_TSI_HOUR = 0x00000008L; | |
328 const SQL_FN_TSI_MINUTE = 0x00000004L; | |
329 const SQL_FN_TSI_MONTH = 0x00000040L; | |
330 const SQL_FN_TSI_QUARTER = 0x00000080L; | |
331 const SQL_FN_TSI_SECOND = 0x00000002L; | |
332 const SQL_FN_TSI_WEEK = 0x00000020L; | |
333 const SQL_FN_TSI_YEAR = 0x00000100L; | |
334 const SQL_GB_GROUP_BY_CONTAINS_SELECT = 2; | |
335 const SQL_GB_GROUP_BY_EQUALS_SELECT = 1; | |
336 const SQL_GB_NO_RELATION = 3; | |
337 const SQL_GB_NOT_SUPPORTED = 0; | |
338 const SQL_GD_BLOCK = 4; | |
339 const SQL_GD_BOUND = 8; | |
340 const SQL_GET_BOOKMARK = 13; | |
341 const SQL_GROUP_BY = 88; | |
342 const SQL_IGNORE = -6; | |
343 const SQL_INFO_FIRST = 0; | |
344 const SQL_KEYSET_SIZE = 8; | |
345 const SQL_KEYSET_SIZE_DEFAULT = 0UL; | |
346 const SQL_KEYWORDS = 89; | |
347 const SQL_LCK_EXCLUSIVE = 2; | |
348 const SQL_LCK_NO_CHANGE = 1; | |
349 const SQL_LCK_UNLOCK = 4; | |
350 | |
351 const SQL_LEN_BINARY_ATTR_OFFSET = -100; | |
352 const SQL_LEN_DATA_AT_EXEC_OFFSET = -100; | |
353 //MACRO #define SQL_LEN_BINARY_ATTR(length) (-(length)+SQL_LEN_BINARY_ATTR_OFFSET) | |
354 //MACRO #define SQL_LEN_DATA_AT_EXEC(length) (-(length)+SQL_LEN_DATA_AT_EXEC_OFFSET) | |
355 | |
356 const SQL_LIKE_ESCAPE_CLAUSE = 113; | |
357 const SQL_LIKE_ONLY = 1; | |
358 const SQL_LOCK_EXCLUSIVE = 1; | |
359 const SQL_LOCK_NO_CHANGE = 0; | |
360 const SQL_LOCK_TYPES = 78; | |
361 const SQL_LOCK_UNLOCK = 2; | |
362 const SQL_LOGIN_TIMEOUT = 103; | |
363 const SQL_LOGIN_TIMEOUT_DEFAULT = 15UL; | |
364 const SQL_LONGVARBINARY = -4; | |
365 const SQL_LONGVARCHAR = -1; | |
366 const SQL_MAX_BINARY_LITERAL_LEN = 112; | |
367 const SQL_MAX_CHAR_LITERAL_LEN = 108; | |
368 const SQL_MAX_DSN_LENGTH = 32; | |
369 const SQL_MAX_LENGTH = 3; | |
370 const SQL_MAX_LENGTH_DEFAULT = 0UL; | |
371 const SQL_MAX_OPTION_STRING_LENGTH = 256; | |
372 const SQL_MAX_OWNER_NAME_LEN = 32; | |
373 const SQL_MAX_PROCEDURE_NAME_LEN = 33; | |
374 const SQL_MAX_QUALIFIER_NAME_LEN = 34; | |
375 const SQL_MAX_ROW_SIZE_INCLUDES_LONG = 103; | |
376 const SQL_MAX_ROWS = 1; | |
377 const SQL_MAX_ROWS_DEFAULT = 0UL; | |
378 | |
379 const SQL_MODE_READ_WRITE = 0UL; | |
380 const SQL_MODE_READ_ONLY = 1UL; | |
381 const SQL_MODE_DEFAULT = SQL_MODE_READ_WRITE; | |
382 | |
383 const SQL_MULT_RESULT_SETS = 36; | |
384 const SQL_MULTIPLE_ACTIVE_TXN = 37; | |
385 const SQL_NC_END = 0x0004; | |
386 const SQL_NC_START = 0x0002; | |
387 const SQL_NEED_LONG_DATA_LEN = 111; | |
388 const SQL_NNC_NON_NULL = 0x0001; | |
389 const SQL_NNC_NULL = 0x0000; | |
390 const SQL_NO_TOTAL = -4; | |
391 const SQL_NON_NULLABLE_COLUMNS = 75; | |
392 | |
393 const SQL_NOSCAN_OFF = 0UL; | |
394 const SQL_NOSCAN_ON = 1UL; | |
395 const SQL_NOSCAN = 2; | |
396 const SQL_NOSCAN_DEFAULT = SQL_NOSCAN_OFF; | |
397 | |
398 const SQL_NUMERIC_FUNCTIONS = 49; | |
399 const SQL_OAC_LEVEL1 = 0x0001; | |
400 const SQL_OAC_LEVEL2 = 0x0002; | |
401 const SQL_OAC_NONE = 0x0000; | |
402 const SQL_ODBC_API_CONFORMANCE = 9; | |
403 const SQL_ODBC_CURSORS = 110; | |
404 const SQL_ODBC_SAG_CLI_CONFORMANCE = 12; | |
405 const SQL_ODBC_SQL_CONFORMANCE = 15; | |
406 const SQL_ODBC_SQL_OPT_IEF = 73; | |
407 const SQL_ODBC_VER = 10; | |
408 const SQL_OPT_TRACE = 104; | |
409 | |
410 const SQL_OPT_TRACE_FILE_DEFAULT = "\\SQL.LOG"; | |
411 const SQL_OPT_TRACE_OFF = 0UL; | |
412 const SQL_OPT_TRACE_DEFAULT = SQL_OPT_TRACE_OFF; | |
413 const SQL_OPT_TRACE_ON = 1UL; | |
414 | |
415 const SQL_OPT_TRACEFILE = 105; | |
416 const SQL_OSC_CORE = 1; | |
417 const SQL_OSC_EXTENDED = 2; | |
418 const SQL_OSC_MINIMUM = 0; | |
419 const SQL_OSCC_COMPLIANT = 1; | |
420 const SQL_OSCC_NOT_COMPLIANT = 0; | |
421 const SQL_OU_DML_STATEMENTS = 1; | |
422 const SQL_OU_INDEX_DEFINITION = 8; | |
423 const SQL_OU_PRIVILEGE_DEFINITION = 16; | |
424 const SQL_OU_PROCEDURE_INVOCATION = 2; | |
425 const SQL_OU_TABLE_DEFINITION = 4; | |
426 const SQL_OUTER_JOINS = 38; | |
427 const SQL_OWNER_TERM = 39; | |
428 const SQL_OWNER_USAGE = 91; | |
429 const SQL_PACKET_SIZE = 112; | |
430 const SQL_PARAM_INPUT = 1; | |
431 const SQL_PARAM_INPUT_OUTPUT = 2; | |
432 const SQL_PARAM_OUTPUT = 4; | |
433 const SQL_PARAM_TYPE_DEFAULT = SQL_PARAM_INPUT_OUTPUT; | |
434 const SQL_PARAM_TYPE_UNKNOWN = 0; | |
435 const SQL_PC_NOT_PSEUDO = 1; | |
436 const SQL_POS_ADD = 16; | |
437 const SQL_POS_DELETE = 8; | |
438 const SQL_POS_OPERATIONS = 79; | |
439 const SQL_POS_POSITION = 1; | |
440 const SQL_POS_REFRESH = 2; | |
441 const SQL_POS_UPDATE = 4; | |
442 const SQL_POSITION = 0; | |
443 const SQL_POSITIONED_STATEMENTS = 80; | |
444 const SQL_PROCEDURE_TERM = 40; | |
445 const SQL_PROCEDURES = 21; | |
446 const SQL_PS_POSITIONED_DELETE = 1; | |
447 const SQL_PS_POSITIONED_UPDATE = 2; | |
448 const SQL_PS_SELECT_FOR_UPDATE = 4; | |
449 const SQL_PT_FUNCTION = 2; | |
450 const SQL_PT_PROCEDURE = 1; | |
451 const SQL_PT_UNKNOWN = 0; | |
452 const SQL_QL_END = 0x0002; | |
453 const SQL_QL_START = 0x0001; | |
454 const SQL_QU_DML_STATEMENTS = 1; | |
455 const SQL_QU_INDEX_DEFINITION = 8; | |
456 const SQL_QU_PRIVILEGE_DEFINITION = 16; | |
457 const SQL_QU_PROCEDURE_INVOCATION = 2; | |
458 const SQL_QU_TABLE_DEFINITION = 4; | |
459 const SQL_QUALIFIER_LOCATION = 114; | |
460 const SQL_QUALIFIER_NAME_SEPARATOR = 41; | |
461 const SQL_QUALIFIER_TERM = 42; | |
462 const SQL_QUALIFIER_USAGE = 92; | |
463 const SQL_QUERY_TIMEOUT = 0; | |
464 const SQL_QUERY_TIMEOUT_DEFAULT = 0UL; | |
465 const SQL_QUICK = 0; | |
466 const SQL_QUIET_MODE = 111; | |
467 const SQL_QUOTED_IDENTIFIER_CASE = 93; | |
468 | |
469 const SQL_RD_OFF = 0UL; | |
470 const SQL_RD_ON = 1UL; | |
471 const SQL_RD_DEFAULT = SQL_RD_ON; | |
472 | |
473 const SQL_REFRESH = 1; | |
474 const SQL_RESTRICT = 1; | |
475 const SQL_RESULT_COL = 3; | |
476 const SQL_RETRIEVE_DATA = 11; | |
477 const SQL_RETURN_VALUE = 5; | |
478 const SQL_ROW_ADDED = 4; | |
479 const SQL_ROW_DELETED = 1; | |
480 const SQL_ROW_ERROR = 5; | |
481 const SQL_ROW_NOROW = 3; | |
482 const SQL_ROW_NUMBER = 14; | |
483 const SQL_ROW_SUCCESS = 0; | |
484 const SQL_ROW_UPDATED = 2; | |
485 const SQL_ROW_UPDATES = 11; | |
486 const SQL_ROWSET_SIZE = 9; | |
487 const SQL_ROWSET_SIZE_DEFAULT = 1UL; | |
488 const SQL_ROWVER = 2; | |
489 const SQL_SC_NON_UNIQUE = 0UL; | |
490 const SQL_SC_TRY_UNIQUE = 1UL; | |
491 const SQL_SC_UNIQUE = 2UL; | |
492 const SQL_SCCO_OPT_TIMESTAMP = SQL_SCCO_OPT_ROWVER;/* deprecated */ | |
493 const SQL_SCROLL_DYNAMIC = -2L;/* deprecated */ | |
494 const SQL_SCROLL_FORWARD_ONLY = 0L;/* deprecated */ | |
495 const SQL_SCROLL_KEYSET_DRIVEN = -1L;/* deprecated */ | |
496 const SQL_SCROLL_OPTIONS = 44; | |
497 const SQL_SCROLL_STATIC = -3L;/* deprecated */ | |
498 const SQL_SEARCHABLE = 3; | |
499 const SQL_SET_NULL = 2; | |
500 const SQL_SETPARAM_VALUE_MAX = -1L; | |
501 const SQL_SETPOS_MAX_LOCK_VALUE = SQL_LOCK_UNLOCK; | |
502 const SQL_SETPOS_MAX_OPTION_VALUE = SQL_ADD; | |
503 const SQL_SIMULATE_CURSOR = 10; | |
504 const SQL_SO_DYNAMIC = 4; | |
505 const SQL_SO_FORWARD_ONLY = 1; | |
506 const SQL_SO_KEYSET_DRIVEN = 2; | |
507 const SQL_SO_MIXED = 8; | |
508 const SQL_SO_STATIC = 16; | |
509 const SQL_SQ_COMPARISON = 1; | |
510 const SQL_SQ_CORRELATED_SUBQUERIES = 16; | |
511 const SQL_SQ_EXISTS = 2; | |
512 const SQL_SQ_IN = 4; | |
513 const SQL_SQ_QUANTIFIED = 8; | |
514 const SQL_SQLSTATE_SIZE = 5; | |
515 const SQL_SS_ADDITIONS = 1; | |
516 const SQL_SS_DELETIONS = 2; | |
517 const SQL_SS_UPDATES = 4; | |
518 const SQL_STATIC_SENSITIVITY = 83; | |
519 const SQL_STRING_FUNCTIONS = 50; | |
520 const SQL_SUBQUERIES = 95; | |
521 const SQL_SYSTEM_FUNCTIONS = 51; | |
522 const SQL_TABLE_STAT = 0; | |
523 const SQL_TABLE_TERM = 45; | |
524 const SQL_TIMEDATE_ADD_INTERVALS = 109; | |
525 const SQL_TIMEDATE_DIFF_INTERVALS = 110; | |
526 const SQL_TIMEDATE_FUNCTIONS = 52; | |
527 const SQL_TRANSLATE_DLL = 106; | |
528 const SQL_TRANSLATE_OPTION = 107; | |
529 const SQL_TXN_ISOLATION = 108; | |
530 const SQL_TXN_VERSIONING = 16; | |
531 const SQL_TYPE_NULL = 0; | |
532 const SQL_U_UNION = 1; | |
533 const SQL_U_UNION_ALL = 2; | |
534 | |
535 const SQL_UB_OFF = 0UL; | |
536 const SQL_UB_DEFAULT = SQL_UB_OFF; | |
537 const SQL_UB_ON = 01UL; | |
538 | |
539 const SQL_UNION = 96; | |
540 const SQL_UNSEARCHABLE = 0; | |
541 const SQL_UPDATE = 2; | |
542 const SQL_USE_BOOKMARKS = 12; | |
543 const SQL_VARBINARY = -3; | |
544 | |
545 const SQL_COLATT_OPT_MAX = SQL_COLUMN_LABEL; | |
546 const SQL_COLATT_OPT_MIN = SQL_COLUMN_COUNT; | |
547 const SQL_PRED_SEARCHABLE = SQL_SEARCHABLE; | |
548 | |
549 //MACRO #define SQL_POSITION_TO(s, r) SQLSetPos(s, r, SQL_POSITION, SQL_LOCK_NO_CHANGE) | |
550 | |
551 //MACRO #define SQL_LOCK_RECORD(s, r, l) SQLSetPos(s, r, SQL_POSITION, l) | |
552 | |
553 //MACRO #define SQL_REFRESH_RECORD(s, r, l) SQLSetPos(s, r, SQL_REFRESH, l) | |
554 | |
555 //MACRO #define SQL_UPDATE_RECORD(s, r) SQLSetPos(s, r, SQL_UPDATE, SQL_LOCK_NO_CHANGE) | |
556 | |
557 //MACRO #define SQL_DELETE_RECORD(s, r) SQLSetPos(s, r, SQL_DELETE, SQL_LOCK_NO_CHANGE) | |
558 | |
559 //MACRO #define SQL_ADD_RECORD(s, r) SQLSetPos(s, r, SQL_ADD, SQL_LOCK_NO_CHANGE) | |
560 | |
561 | |
562 static if (ODBCVER < 0x0300) { | |
563 const SQL_CONNECT_OPT_DRVR_START = 1000; | |
564 const SQL_CONN_OPT_MAX = SQL_PACKET_SIZE; | |
565 const SQL_CONN_OPT_MIN = SQL_ACCESS_MODE; | |
566 const SQL_STMT_OPT_MAX = SQL_ROW_NUMBER; | |
567 const SQL_STMT_OPT_MIN = SQL_QUERY_TIMEOUT; | |
568 const SQL_TYPE_DRIVER_START = SQL_INTERVAL_YEAR; | |
569 const SQL_TYPE_DRIVER_END = SQL_UNICODE_LONGVARCHAR; | |
570 const SQL_TYPE_MIN = SQL_BIT; | |
571 const SQL_TYPE_MAX = SQL_VARCHAR; | |
572 } | |
573 | |
574 static if (ODBCVER < 0x0300) { | |
575 const SQL_NO_DATA_FOUND = 100; | |
576 const SQL_INTERVAL_YEAR = -80; | |
577 const SQL_INTERVAL_MONTH = -81; | |
578 const SQL_INTERVAL_YEAR_TO_MONTH = -82; | |
579 const SQL_INTERVAL_DAY = -83; | |
580 const SQL_INTERVAL_HOUR = -84; | |
581 const SQL_INTERVAL_MINUTE = -85; | |
582 const SQL_INTERVAL_SECOND = -86; | |
583 const SQL_INTERVAL_DAY_TO_HOUR = -87; | |
584 const SQL_INTERVAL_DAY_TO_MINUTE = -88; | |
585 const SQL_INTERVAL_DAY_TO_SECOND = -89; | |
586 const SQL_INTERVAL_HOUR_TO_MINUTE = -90; | |
587 const SQL_INTERVAL_HOUR_TO_SECOND = -91; | |
588 const SQL_INTERVAL_MINUTE_TO_SECOND = -92; | |
589 } else { | |
590 const SQL_NO_DATA_FOUND = SQL_NO_DATA; | |
591 const SQL_CODE_YEAR = 1; | |
592 const SQL_CODE_MONTH = 2; | |
593 const SQL_CODE_DAY = 3; | |
594 const SQL_CODE_HOUR = 4; | |
595 const SQL_CODE_MINUTE = 5; | |
596 const SQL_CODE_SECOND = 6; | |
597 const SQL_CODE_YEAR_TO_MONTH = 7; | |
598 const SQL_CODE_DAY_TO_HOUR = 8; | |
599 const SQL_CODE_DAY_TO_MINUTE = 9; | |
600 const SQL_CODE_DAY_TO_SECOND = 10; | |
601 const SQL_CODE_HOUR_TO_MINUTE = 11; | |
602 const SQL_CODE_HOUR_TO_SECOND = 12; | |
603 const SQL_CODE_MINUTE_TO_SECOND = 13; | |
604 const SQL_INTERVAL_YEAR = 100 + SQL_CODE_YEAR; | |
605 const SQL_INTERVAL_MONTH = 100 + SQL_CODE_MONTH; | |
606 const SQL_INTERVAL_DAY = 100 + SQL_CODE_DAY; | |
607 const SQL_INTERVAL_HOUR = 100 + SQL_CODE_HOUR; | |
608 const SQL_INTERVAL_MINUTE = 100 + SQL_CODE_MINUTE; | |
609 const SQL_INTERVAL_SECOND = 100 + SQL_CODE_SECOND; | |
610 const SQL_INTERVAL_YEAR_TO_MONTH = 100 + SQL_CODE_YEAR_TO_MONTH; | |
611 const SQL_INTERVAL_DAY_TO_HOUR = 100 + SQL_CODE_DAY_TO_HOUR; | |
612 const SQL_INTERVAL_DAY_TO_MINUTE = 100 + SQL_CODE_DAY_TO_MINUTE; | |
613 const SQL_INTERVAL_DAY_TO_SECOND = 100 + SQL_CODE_DAY_TO_SECOND; | |
614 const SQL_INTERVAL_HOUR_TO_MINUTE = 100 + SQL_CODE_HOUR_TO_MINUTE; | |
615 const SQL_INTERVAL_HOUR_TO_SECOND = 100 + SQL_CODE_HOUR_TO_SECOND; | |
616 const SQL_INTERVAL_MINUTE_TO_SECOND = 100 + SQL_CODE_MINUTE_TO_SECOND; | |
617 }//[Yes] #endif | |
618 | |
619 | |
620 static if ((ODBCVER >= 0x0201) && (ODBCVER < 0x0300)) { | |
621 const SQL_OJ_CAPABILITIES = 65003; | |
622 } | |
623 | |
624 static if (ODBCVER >= 0x0250) { | |
625 const SQL_NO_ACTION = 3; | |
626 const SQL_SET_DEFAULT = 4; | |
627 } | |
628 | |
629 static if (ODBCVER >= 0x0300) { | |
630 const SQL_ACTIVE_ENVIRONMENTS = 116; | |
631 const SQL_AD_ADD_CONSTRAINT_DEFERRABLE = 0x00000080L; | |
632 const SQL_AD_ADD_CONSTRAINT_INITIALLY_DEFERRED = 0x00000020L; | |
633 const SQL_AD_ADD_CONSTRAINT_INITIALLY_IMMEDIATE = 0x00000040L; | |
634 const SQL_AD_ADD_CONSTRAINT_NON_DEFERRABLE = 0x00000100L; | |
635 const SQL_AD_ADD_DOMAIN_CONSTRAINT = 0x00000002L; | |
636 const SQL_AD_ADD_DOMAIN_DEFAULT = 0x00000008L; | |
637 const SQL_AD_CONSTRAINT_NAME_DEFINITION = 0x00000001L; | |
638 const SQL_AD_DROP_DOMAIN_CONSTRAINT = 0x00000004L; | |
639 const SQL_AD_DROP_DOMAIN_DEFAULT = 0x00000010L; | |
640 const SQL_AF_ALL = 0x00000040L; | |
641 const SQL_AF_AVG = 0x00000001L; | |
642 const SQL_AF_COUNT = 0x00000002L; | |
643 const SQL_AF_DISTINCT = 0x00000020L; | |
644 const SQL_AF_MAX = 0x00000004L; | |
645 const SQL_AF_MIN = 0x00000008L; | |
646 const SQL_AF_SUM = 0x00000010L; | |
647 const SQL_AGGREGATE_FUNCTIONS = 169; | |
648 const SQL_ALL_CATALOGS = "%"; | |
649 const SQL_ALL_SCHEMAS = "%"; | |
650 const SQL_ALL_TABLE_TYPES = "%"; | |
651 const SQL_ALTER_DOMAIN = 117; | |
652 const SQL_AM_CONNECTION = 1; | |
653 const SQL_AM_NONE = 0; | |
654 const SQL_AM_STATEMENT = 2; | |
655 const SQL_API_ODBC3_ALL_FUNCTIONS = 999; | |
656 const SQL_API_ODBC3_ALL_FUNCTIONS_SIZE = 250; | |
657 const SQL_API_SQLALLOCHANDLESTD = 73; | |
658 const SQL_API_SQLBULKOPERATIONS = 24; | |
659 const SQL_ASYNC_MODE = 10021; | |
660 const SQL_AT_ADD_COLUMN_COLLATION = 0x00000080L; | |
661 const SQL_AT_ADD_COLUMN_DEFAULT = 0x00000040L; | |
662 const SQL_AT_ADD_COLUMN_SINGLE = 0x00000020L; | |
663 const SQL_AT_ADD_TABLE_CONSTRAINT = 0x00001000L; | |
664 const SQL_AT_CONSTRAINT_DEFERRABLE = 0x00040000L; | |
665 const SQL_AT_CONSTRAINT_INITIALLY_DEFERRED = 0x00010000L; | |
666 const SQL_AT_CONSTRAINT_INITIALLY_IMMEDIATE = 0x00020000L; | |
667 const SQL_AT_CONSTRAINT_NAME_DEFINITION = 0x00008000L; | |
668 const SQL_AT_CONSTRAINT_NON_DEFERRABLE = 0x00080000L; | |
669 const SQL_AT_DROP_COLUMN_CASCADE = 0x00000400L; | |
670 const SQL_AT_DROP_COLUMN_DEFAULT = 0x00000200L; | |
671 const SQL_AT_DROP_COLUMN_RESTRICT = 0x00000800L; | |
672 const SQL_AT_DROP_TABLE_CONSTRAINT_CASCADE = 0x00002000L; | |
673 const SQL_AT_DROP_TABLE_CONSTRAINT_RESTRICT = 0x00004000L; | |
674 const SQL_AT_SET_COLUMN_DEFAULT = 0x00000100L; | |
675 const SQL_ATTR_ACCESS_MODE = SQL_ACCESS_MODE; | |
676 const SQL_ATTR_ASYNC_ENABLE = 4; | |
677 const SQL_ATTR_AUTOCOMMIT = SQL_AUTOCOMMIT; | |
678 const SQL_ATTR_CONCURRENCY = SQL_CONCURRENCY; | |
679 const SQL_ATTR_CONNECTION_POOLING = 201; | |
680 const SQL_ATTR_CONNECTION_TIMEOUT = 113; | |
681 const SQL_ATTR_CP_MATCH = 202; | |
682 const SQL_ATTR_CURRENT_CATALOG = SQL_CURRENT_QUALIFIER; | |
683 const SQL_ATTR_CURSOR_TYPE = SQL_CURSOR_TYPE; | |
684 const SQL_ATTR_DISCONNECT_BEHAVIOR = 114; | |
685 const SQL_ATTR_ENABLE_AUTO_IPD = 15; | |
686 const SQL_ATTR_ENLIST_IN_DTC = 1207; | |
687 const SQL_ATTR_ENLIST_IN_XA = 1208; | |
688 const SQL_ATTR_FETCH_BOOKMARK_PTR = 16; | |
689 const SQL_ATTR_KEYSET_SIZE = SQL_KEYSET_SIZE; | |
690 const SQL_ATTR_LOGIN_TIMEOUT = SQL_LOGIN_TIMEOUT; | |
691 const SQL_ATTR_MAX_LENGTH = SQL_MAX_LENGTH; | |
692 const SQL_ATTR_MAX_ROWS = SQL_MAX_ROWS; | |
693 const SQL_ATTR_NOSCAN = SQL_NOSCAN; | |
694 const SQL_ATTR_ODBC_CURSORS = SQL_ODBC_CURSORS; | |
695 const SQL_ATTR_ODBC_VERSION = 200; | |
696 const SQL_ATTR_PACKET_SIZE = SQL_PACKET_SIZE; | |
697 const SQL_ATTR_PARAM_BIND_OFFSET_PTR = 17; | |
698 const SQL_ATTR_PARAM_BIND_TYPE = 18; | |
699 const SQL_ATTR_PARAM_OPERATION_PTR = 19; | |
700 const SQL_ATTR_PARAM_STATUS_PTR = 20; | |
701 const SQL_ATTR_PARAMS_PROCESSED_PTR = 21; | |
702 const SQL_ATTR_PARAMSET_SIZE = 22; | |
703 const SQL_ATTR_QUERY_TIMEOUT = SQL_QUERY_TIMEOUT; | |
704 const SQL_ATTR_QUIET_MODE = SQL_QUIET_MODE; | |
705 const SQL_ATTR_RETRIEVE_DATA = SQL_RETRIEVE_DATA; | |
706 const SQL_ATTR_ROW_ARRAY_SIZE = 27; | |
707 const SQL_ATTR_ROW_BIND_OFFSET_PTR = 23; | |
708 const SQL_ATTR_ROW_BIND_TYPE = SQL_BIND_TYPE; | |
709 const SQL_ATTR_ROW_NUMBER = SQL_ROW_NUMBER; | |
710 const SQL_ATTR_ROW_OPERATION_PTR = 24; | |
711 const SQL_ATTR_ROW_STATUS_PTR = 25; | |
712 const SQL_ATTR_ROWS_FETCHED_PTR = 26; | |
713 const SQL_ATTR_SIMULATE_CURSOR = SQL_SIMULATE_CURSOR; | |
714 const SQL_ATTR_TRACE = SQL_OPT_TRACE; | |
715 const SQL_ATTR_TRACEFILE = SQL_OPT_TRACEFILE; | |
716 const SQL_ATTR_TRANSLATE_LIB = SQL_TRANSLATE_DLL; | |
717 const SQL_ATTR_TRANSLATE_OPTION = SQL_TRANSLATE_OPTION; | |
718 const SQL_ATTR_TXN_ISOLATION = SQL_TXN_ISOLATION; | |
719 const SQL_ATTR_USE_BOOKMARKS = SQL_USE_BOOKMARKS; | |
720 const SQL_BATCH_ROW_COUNT = 120; | |
721 const SQL_BATCH_SUPPORT = 121; | |
722 const SQL_BRC_EXPLICIT = 0x0000002; | |
723 const SQL_BRC_PROCEDURES = 0x0000001; | |
724 const SQL_BRC_ROLLED_UP = 0x0000004; | |
725 const SQL_BS_ROW_COUNT_EXPLICIT = 0x00000002L; | |
726 const SQL_BS_ROW_COUNT_PROC = 0x00000008L; | |
727 const SQL_BS_SELECT_EXPLICIT = 0x00000001L; | |
728 const SQL_BS_SELECT_PROC = 0x00000004L; | |
729 const SQL_C_INTERVAL_DAY = SQL_INTERVAL_DAY; | |
730 const SQL_C_INTERVAL_DAY_TO_HOUR = SQL_INTERVAL_DAY_TO_HOUR; | |
731 const SQL_C_INTERVAL_DAY_TO_MINUTE = SQL_INTERVAL_DAY_TO_MINUTE; | |
732 const SQL_C_INTERVAL_DAY_TO_SECOND = SQL_INTERVAL_DAY_TO_SECOND; | |
733 const SQL_C_INTERVAL_HOUR = SQL_INTERVAL_HOUR; | |
734 const SQL_C_INTERVAL_HOUR_TO_MINUTE = SQL_INTERVAL_HOUR_TO_MINUTE; | |
735 const SQL_C_INTERVAL_HOUR_TO_SECOND = SQL_INTERVAL_HOUR_TO_SECOND; | |
736 const SQL_C_INTERVAL_MINUTE = SQL_INTERVAL_MINUTE; | |
737 const SQL_C_INTERVAL_MINUTE_TO_SECOND = SQL_INTERVAL_MINUTE_TO_SECOND; | |
738 const SQL_C_INTERVAL_MONTH = SQL_INTERVAL_MONTH; | |
739 const SQL_C_INTERVAL_SECOND = SQL_INTERVAL_SECOND; | |
740 const SQL_C_INTERVAL_YEAR = SQL_INTERVAL_YEAR; | |
741 const SQL_C_INTERVAL_YEAR_TO_MONTH = SQL_INTERVAL_YEAR_TO_MONTH; | |
742 const SQL_C_NUMERIC = SQL_NUMERIC; | |
743 const SQL_C_SBIGINT = SQL_BIGINT+SQL_SIGNED_OFFSET; | |
744 const SQL_C_TYPE_DATE = SQL_TYPE_DATE; | |
745 const SQL_C_TYPE_TIME = SQL_TYPE_TIME; | |
746 const SQL_C_TYPE_TIMESTAMP = SQL_TYPE_TIMESTAMP; | |
747 const SQL_C_UBIGINT = SQL_BIGINT+SQL_UNSIGNED_OFFSET; | |
748 const SQL_C_VARBOOKMARK = SQL_C_BINARY; | |
749 const SQL_CA_CONSTRAINT_DEFERRABLE = 0x00000040L; | |
750 const SQL_CA_CONSTRAINT_INITIALLY_DEFERRED = 0x00000010L; | |
751 const SQL_CA_CONSTRAINT_INITIALLY_IMMEDIATE = 0x00000020L; | |
752 const SQL_CA_CONSTRAINT_NON_DEFERRABLE = 0x00000080L; | |
753 const SQL_CA_CREATE_ASSERTION = 0x00000001L; | |
754 const SQL_CA1_ABSOLUTE = 0x00000002L; | |
755 const SQL_CA1_BOOKMARK = 0x00000008L; | |
756 const SQL_CA1_BULK_ADD = 0x00010000L; | |
757 const SQL_CA1_BULK_DELETE_BY_BOOKMARK = 0x00040000L; | |
758 const SQL_CA1_BULK_FETCH_BY_BOOKMARK = 0x00080000L; | |
759 const SQL_CA1_BULK_UPDATE_BY_BOOKMARK = 0x00020000L; | |
760 const SQL_CA1_LOCK_EXCLUSIVE = 0x00000080L; | |
761 const SQL_CA1_LOCK_NO_CHANGE = 0x00000040L; | |
762 const SQL_CA1_LOCK_UNLOCK = 0x00000100L; | |
763 const SQL_CA1_NEXT = 0x00000001L; | |
764 const SQL_CA1_POS_DELETE = 0x00000800L; | |
765 const SQL_CA1_POS_POSITION = 0x00000200L; | |
766 const SQL_CA1_POS_REFRESH = 0x00001000L; | |
767 const SQL_CA1_POS_UPDATE = 0x00000400L; | |
768 const SQL_CA1_POSITIONED_DELETE = 0x00004000L; | |
769 const SQL_CA1_POSITIONED_UPDATE = 0x00002000L; | |
770 const SQL_CA1_RELATIVE = 0x00000004L; | |
771 const SQL_CA1_SELECT_FOR_UPDATE = 0x00008000L; | |
772 const SQL_CA2_CRC_APPROXIMATE = 0x00002000L; | |
773 const SQL_CA2_CRC_EXACT = 0x00001000L; | |
774 const SQL_CA2_LOCK_CONCURRENCY = 0x00000002L; | |
775 | |
776 const SQL_CA2_MAX_ROWS_CATALOG = 0x00000800L; | |
777 const SQL_CA2_MAX_ROWS_DELETE = 0x00000200L; | |
778 const SQL_CA2_MAX_ROWS_INSERT = 0x00000100L; | |
779 const SQL_CA2_MAX_ROWS_SELECT = 0x00000080L; | |
780 const SQL_CA2_MAX_ROWS_UPDATE = 0x00000400L; | |
781 const SQL_CA2_MAX_ROWS_AFFECTS_ALL = SQL_CA2_MAX_ROWS_SELECT | SQL_CA2_MAX_ROWS_INSERT | | |
782 SQL_CA2_MAX_ROWS_DELETE | SQL_CA2_MAX_ROWS_UPDATE | SQL_CA2_MAX_ROWS_CATALOG; | |
783 | |
784 const SQL_CA2_OPT_ROWVER_CONCURRENCY = 0x00000004L; | |
785 const SQL_CA2_OPT_VALUES_CONCURRENCY = 0x00000008L; | |
786 const SQL_CA2_READ_ONLY_CONCURRENCY = 0x00000001L; | |
787 const SQL_CA2_SENSITIVITY_ADDITIONS = 0x00000010L; | |
788 const SQL_CA2_SENSITIVITY_DELETIONS = 0x00000020L; | |
789 const SQL_CA2_SENSITIVITY_UPDATES = 0x00000040L; | |
790 const SQL_CA2_SIMULATE_NON_UNIQUE = 0x00004000L; | |
791 const SQL_CA2_SIMULATE_TRY_UNIQUE = 0x00008000L; | |
792 const SQL_CA2_SIMULATE_UNIQUE = 0x00010000L; | |
793 const SQL_CATALOG_LOCATION = SQL_QUALIFIER_LOCATION; | |
794 const SQL_CATALOG_NAME_SEPARATOR = SQL_QUALIFIER_NAME_SEPARATOR; | |
795 const SQL_CATALOG_TERM = SQL_QUALIFIER_TERM; | |
796 const SQL_CATALOG_USAGE = SQL_QUALIFIER_USAGE; | |
797 const SQL_CCOL_CREATE_COLLATION = 0x00000001L; | |
798 const SQL_CCS_COLLATE_CLAUSE = 0x00000002L; | |
799 const SQL_CCS_CREATE_CHARACTER_SET = 0x00000001L; | |
800 const SQL_CCS_LIMITED_COLLATION = 0x00000004L; | |
801 const SQL_CDO_COLLATION = 0x00000008L; | |
802 const SQL_CDO_CONSTRAINT = 0x00000004L; | |
803 const SQL_CDO_CONSTRAINT_DEFERRABLE = 0x00000080L; | |
804 const SQL_CDO_CONSTRAINT_INITIALLY_DEFERRED = 0x00000020L; | |
805 const SQL_CDO_CONSTRAINT_INITIALLY_IMMEDIATE = 0x00000040L; | |
806 const SQL_CDO_CONSTRAINT_NAME_DEFINITION = 0x00000010L; | |
807 const SQL_CDO_CONSTRAINT_NON_DEFERRABLE = 0x00000100L; | |
808 const SQL_CDO_CREATE_DOMAIN = 0x00000001L; | |
809 const SQL_CDO_DEFAULT = 0x00000002L; | |
810 const SQL_CL_END = SQL_QL_END; | |
811 const SQL_CL_START = SQL_QL_START; | |
812 const SQL_COL_PRED_BASIC = SQL_ALL_EXCEPT_LIKE; | |
813 const SQL_COL_PRED_CHAR = SQL_LIKE_ONLY; | |
814 const SQL_COLUMN_DRIVER_START = 1000; | |
815 const SQL_COLUMN_IGNORE = SQL_IGNORE; | |
816 const SQL_COLUMN_NUMBER_UNKNOWN = -2; | |
817 const SQL_CONVERT_GUID = 173; | |
818 | |
819 const SQL_CONVERT_WCHAR = 122; | |
820 const SQL_CONVERT_INTERVAL_DAY_TIME = 123; | |
821 const SQL_CONVERT_INTERVAL_YEAR_MONTH = 124; | |
822 const SQL_CONVERT_WLONGVARCHAR = 125; | |
823 const SQL_CONVERT_WVARCHAR = 126; | |
824 | |
825 const SQL_CREATE_ASSERTION = 127; | |
826 const SQL_CREATE_CHARACTER_SET = 128; | |
827 const SQL_CREATE_COLLATION = 129; | |
828 const SQL_CREATE_DOMAIN = 130; | |
829 const SQL_CREATE_SCHEMA = 131; | |
830 const SQL_CREATE_TABLE = 132; | |
831 const SQL_CREATE_TRANSLATION = 133; | |
832 const SQL_CREATE_VIEW = 134; | |
833 | |
834 | |
835 const SQL_CP_OFF = 0UL; | |
836 const SQL_CP_DEFAULT = SQL_CP_OFF; | |
837 const SQL_CP_ONE_PER_DRIVER = 1UL; | |
838 const SQL_CP_ONE_PER_HENV = 2UL; | |
839 | |
840 const SQL_CP_STRICT_MATCH = 0UL; | |
841 const SQL_CP_MATCH_DEFAULT = SQL_CP_STRICT_MATCH; | |
842 const SQL_CP_RELAXED_MATCH = 1UL; | |
843 | |
844 const SQL_CS_CREATE_SCHEMA = 0x00000001L; | |
845 const SQL_CS_AUTHORIZATION = 0x00000002L; | |
846 const SQL_CS_DEFAULT_CHARACTER_SET = 0x00000004L; | |
847 | |
848 const SQL_CT_COLUMN_COLLATION = 0x00000800L; | |
849 const SQL_CT_COLUMN_CONSTRAINT = 0x00000200L; | |
850 const SQL_CT_COLUMN_DEFAULT = 0x00000400L; | |
851 const SQL_CT_COMMIT_DELETE = 0x00000004L; | |
852 const SQL_CT_COMMIT_PRESERVE = 0x00000002L; | |
853 const SQL_CT_CONSTRAINT_DEFERRABLE = 0x00000080L; | |
854 const SQL_CT_CONSTRAINT_INITIALLY_DEFERRED = 0x00000020L; | |
855 const SQL_CT_CONSTRAINT_INITIALLY_IMMEDIATE = 0x00000040L; | |
856 const SQL_CT_CONSTRAINT_NAME_DEFINITION = 0x00002000L; | |
857 const SQL_CT_CONSTRAINT_NON_DEFERRABLE = 0x00000100L; | |
858 const SQL_CT_CREATE_TABLE = 0x00000001L; | |
859 const SQL_CT_GLOBAL_TEMPORARY = 0x00000008L; | |
860 const SQL_CT_LOCAL_TEMPORARY = 0x00000010L; | |
861 const SQL_CT_TABLE_CONSTRAINT = 0x00001000L; | |
862 | |
863 const SQL_CTR_CREATE_TRANSLATION = 0x00000001L; | |
864 | |
865 const SQL_CU_DML_STATEMENTS = SQL_QU_DML_STATEMENTS; | |
866 const SQL_CU_INDEX_DEFINITION = SQL_QU_INDEX_DEFINITION; | |
867 const SQL_CU_PRIVILEGE_DEFINITION = SQL_QU_PRIVILEGE_DEFINITION; | |
868 const SQL_CU_PROCEDURE_INVOCATION = SQL_QU_PROCEDURE_INVOCATION; | |
869 const SQL_CU_TABLE_DEFINITION = SQL_QU_TABLE_DEFINITION; | |
870 | |
871 const SQL_CVT_INTERVAL_YEAR_MONTH = 0x00080000L; | |
872 const SQL_CVT_INTERVAL_DAY_TIME = 0x00100000L; | |
873 const SQL_CVT_WCHAR = 0x00200000L; | |
874 const SQL_CVT_WLONGVARCHAR = 0x00400000L; | |
875 const SQL_CVT_WVARCHAR = 0x00800000L; | |
876 const SQL_CVT_GUID = 0x01000000L; | |
877 | |
878 const SQL_DA_DROP_ASSERTION = 0x00000001L; | |
879 const SQL_DATETIME_LITERALS = 119; | |
880 | |
881 const SQL_DB_DISCONNECT = 1UL; | |
882 const SQL_DB_RETURN_TO_POOL = 0UL; | |
883 const SQL_DB_DEFAULT = SQL_DB_RETURN_TO_POOL; | |
884 | |
885 const SQL_DC_DROP_COLLATION = 0x00000001L; | |
886 const SQL_DCS_DROP_CHARACTER_SET = 0x00000001L; | |
887 const SQL_DD_CASCADE = 0x00000004L; | |
888 const SQL_DD_DROP_DOMAIN = 0x00000001L; | |
889 const SQL_DD_RESTRICT = 0x00000002L; | |
890 const SQL_DDL_INDEX = 170; | |
891 const SQL_DELETE_BY_BOOKMARK = 6; | |
892 const SQL_DESC_ARRAY_SIZE = 20; | |
893 const SQL_DESC_ARRAY_STATUS_PTR = 21; | |
894 const SQL_DESC_AUTO_UNIQUE_VALUE = SQL_COLUMN_AUTO_INCREMENT; | |
895 const SQL_DESC_BASE_COLUMN_NAME = 22; | |
896 const SQL_DESC_BASE_TABLE_NAME = 23; | |
897 const SQL_DESC_BIND_OFFSET_PTR = 24; | |
898 const SQL_DESC_BIND_TYPE = 25; | |
899 const SQL_DESC_CASE_SENSITIVE = SQL_COLUMN_CASE_SENSITIVE; | |
900 const SQL_DESC_CATALOG_NAME = SQL_COLUMN_QUALIFIER_NAME; | |
901 const SQL_DESC_CONCISE_TYPE = SQL_COLUMN_TYPE; | |
902 const SQL_DESC_DATETIME_INTERVAL_PRECISION = 26; | |
903 const SQL_DESC_DISPLAY_SIZE = SQL_COLUMN_DISPLAY_SIZE; | |
904 const SQL_DESC_FIXED_PREC_SCALE = SQL_COLUMN_MONEY; | |
905 const SQL_DESC_LABEL = SQL_COLUMN_LABEL; | |
906 const SQL_DESC_LITERAL_PREFIX = 27; | |
907 const SQL_DESC_LITERAL_SUFFIX = 28; | |
908 const SQL_DESC_LOCAL_TYPE_NAME = 29; | |
909 const SQL_DESC_MAXIMUM_SCALE = 30; | |
910 const SQL_DESC_MINIMUM_SCALE = 31; | |
911 const SQL_DESC_NUM_PREC_RADIX = 32; | |
912 const SQL_DESC_PARAMETER_TYPE = 33; | |
913 const SQL_DESC_ROWS_PROCESSED_PTR = 34; | |
914 const SQL_DESC_SCHEMA_NAME = SQL_COLUMN_OWNER_NAME; | |
915 const SQL_DESC_SEARCHABLE = SQL_COLUMN_SEARCHABLE; | |
916 const SQL_DESC_TABLE_NAME = SQL_COLUMN_TABLE_NAME; | |
917 const SQL_DESC_TYPE_NAME = SQL_COLUMN_TYPE_NAME; | |
918 const SQL_DESC_UNSIGNED = SQL_COLUMN_UNSIGNED; | |
919 const SQL_DESC_UPDATABLE = SQL_COLUMN_UPDATABLE; | |
920 const SQL_DI_CREATE_INDEX = 0x00000001L; | |
921 const SQL_DI_DROP_INDEX = 0x00000002L; | |
922 | |
923 const SQL_DIAG_COLUMN_NUMBER = -1247; | |
924 const SQL_DIAG_ROW_NUMBER = -1248; | |
925 const SQL_DIAG_CURSOR_ROW_COUNT = -1249; | |
926 | |
927 const SQL_DL_SQL92_DATE = 0x00000001L; | |
928 const SQL_DL_SQL92_INTERVAL_DAY = 0x00000020L; | |
929 const SQL_DL_SQL92_INTERVAL_DAY_TO_HOUR = 0x00000400L; | |
930 const SQL_DL_SQL92_INTERVAL_DAY_TO_MINUTE = 0x00000800L; | |
931 const SQL_DL_SQL92_INTERVAL_DAY_TO_SECOND = 0x00001000L; | |
932 const SQL_DL_SQL92_INTERVAL_HOUR = 0x00000040L; | |
933 const SQL_DL_SQL92_INTERVAL_HOUR_TO_MINUTE = 0x00002000L; | |
934 const SQL_DL_SQL92_INTERVAL_HOUR_TO_SECOND = 0x00004000L; | |
935 const SQL_DL_SQL92_INTERVAL_MINUTE = 0x00000080L; | |
936 const SQL_DL_SQL92_INTERVAL_MINUTE_TO_SECOND = 0x00008000L; | |
937 const SQL_DL_SQL92_INTERVAL_MONTH = 0x00000010L; | |
938 const SQL_DL_SQL92_INTERVAL_SECOND = 0x00000100L; | |
939 const SQL_DL_SQL92_INTERVAL_YEAR = 0x00000008L; | |
940 const SQL_DL_SQL92_INTERVAL_YEAR_TO_MONTH = 0x00000200L; | |
941 const SQL_DL_SQL92_TIME = 0x00000002L; | |
942 const SQL_DL_SQL92_TIMESTAMP = 0x00000004L; | |
943 const SQL_DM_VER = 171; | |
944 const SQL_DRIVER_HDESC = 135; | |
945 const SQL_DROP_ASSERTION = 136; | |
946 const SQL_DROP_CHARACTER_SET = 137; | |
947 const SQL_DROP_COLLATION = 138; | |
948 const SQL_DROP_DOMAIN = 139; | |
949 const SQL_DROP_SCHEMA = 140; | |
950 const SQL_DROP_TABLE = 141; | |
951 const SQL_DROP_TRANSLATION = 142; | |
952 const SQL_DROP_VIEW = 143; | |
953 const SQL_DS_CASCADE = 0x00000004L; | |
954 const SQL_DS_DROP_SCHEMA = 0x00000001L; | |
955 const SQL_DS_RESTRICT = 0x00000002L; | |
956 const SQL_DT_CASCADE = 0x00000004L; | |
957 const SQL_DT_DROP_TABLE = 0x00000001L; | |
958 const SQL_DT_RESTRICT = 0x00000002L; | |
959 const SQL_DTC_DONE = 0L; | |
960 const SQL_DTR_DROP_TRANSLATION = 0x00000001L; | |
961 const SQL_DV_CASCADE = 0x00000004L; | |
962 const SQL_DV_DROP_VIEW = 0x00000001L; | |
963 const SQL_DV_RESTRICT = 0x00000002L; | |
964 const SQL_DYNAMIC_CURSOR_ATTRIBUTES1 = 144; | |
965 const SQL_DYNAMIC_CURSOR_ATTRIBUTES2 = 145; | |
966 const SQL_EXT_API_LAST = SQL_API_SQLBINDPARAMETER; | |
967 const SQL_EXT_API_START = 40; | |
968 const SQL_FETCH_BY_BOOKMARK = 7; | |
969 const SQL_FETCH_FIRST_SYSTEM = 32; | |
970 const SQL_FETCH_FIRST_USER = 31; | |
971 const SQL_FN_CVT_CAST = 0x00000002L; | |
972 const SQL_FN_STR_BIT_LENGTH = 0x00080000L; | |
973 const SQL_FN_STR_CHAR_LENGTH = 0x00100000L; | |
974 const SQL_FN_STR_CHARACTER_LENGTH = 0x00200000L; | |
975 const SQL_FN_STR_OCTET_LENGTH = 0x00400000L; | |
976 const SQL_FN_STR_POSITION = 0x00800000L; | |
977 const SQL_FN_TD_CURRENT_DATE = 0x00020000L; | |
978 const SQL_FN_TD_CURRENT_TIME = 0x00040000L; | |
979 const SQL_FN_TD_CURRENT_TIMESTAMP = 0x00080000L; | |
980 const SQL_FN_TD_EXTRACT = 0x00100000L; | |
981 const SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1 = 146; | |
982 const SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2 = 147; | |
983 /* #define SQL_FUNC_EXISTS(exists, api) | |
984 ((*(((UWORD*) (exists)) + ((api) >> 4)) & (1 << ((api) & 15)) ) ? | |
985 SQL_TRUE : SQL_FALSE ) | |
986 */ | |
987 const SQL_GB_COLLATE = 0x0004; | |
988 const SQL_HANDLE_SENV = 5; | |
989 | |
990 const SQL_IK_NONE = 0; | |
991 const SQL_IK_ASC = 1; | |
992 const SQL_IK_DESC = 2; | |
993 const SQL_IK_ALL = SQL_IK_ASC | SQL_IK_DESC; | |
994 | |
995 const SQL_INDEX_KEYWORDS = 148; | |
996 const SQL_INFO_DRIVER_START = 1000; | |
997 const SQL_INFO_LAST = SQL_QUALIFIER_LOCATION; | |
998 const SQL_INFO_SCHEMA_VIEWS = 149; | |
999 const SQL_INITIALLY_DEFERRED = 5; | |
1000 const SQL_INITIALLY_IMMEDIATE = 6; | |
1001 const SQL_INSERT_STATEMENT = 172; | |
1002 const SQL_INTERVAL = 10; | |
1003 const SQL_IS_INSERT_LITERALS = 0x00000001L; | |
1004 const SQL_IS_INSERT_SEARCHED = 0x00000002L; | |
1005 const SQL_IS_INTEGER = -6; | |
1006 const SQL_IS_POINTER = -4; | |
1007 const SQL_IS_SELECT_INTO = 0x00000004L; | |
1008 const SQL_IS_SMALLINT = -8; | |
1009 const SQL_IS_UINTEGER = -5; | |
1010 const SQL_IS_USMALLINT = -7; | |
1011 const SQL_ISV_ASSERTIONS = 0x00000001L; | |
1012 const SQL_ISV_CHARACTER_SETS = 0x00000002L; | |
1013 const SQL_ISV_CHECK_CONSTRAINTS = 0x00000004L; | |
1014 const SQL_ISV_COLLATIONS = 0x00000008L; | |
1015 const SQL_ISV_COLUMN_DOMAIN_USAGE = 0x00000010L; | |
1016 const SQL_ISV_COLUMN_PRIVILEGES = 0x00000020L; | |
1017 const SQL_ISV_COLUMNS = 0x00000040L; | |
1018 const SQL_ISV_CONSTRAINT_COLUMN_USAGE = 0x00000080L; | |
1019 const SQL_ISV_CONSTRAINT_TABLE_USAGE = 0x00000100L; | |
1020 const SQL_ISV_DOMAIN_CONSTRAINTS = 0x00000200L; | |
1021 const SQL_ISV_DOMAINS = 0x00000400L; | |
1022 const SQL_ISV_KEY_COLUMN_USAGE = 0x00000800L; | |
1023 const SQL_ISV_REFERENTIAL_CONSTRAINTS = 0x00001000L; | |
1024 const SQL_ISV_SCHEMATA = 0x00002000L; | |
1025 const SQL_ISV_SQL_LANGUAGES = 0x00004000L; | |
1026 const SQL_ISV_TABLE_CONSTRAINTS = 0x00008000L; | |
1027 const SQL_ISV_TABLE_PRIVILEGES = 0x00010000L; | |
1028 const SQL_ISV_TABLES = 0x00020000L; | |
1029 const SQL_ISV_TRANSLATIONS = 0x00040000L; | |
1030 const SQL_ISV_USAGE_PRIVILEGES = 0x00080000L; | |
1031 const SQL_ISV_VIEW_COLUMN_USAGE = 0x00100000L; | |
1032 const SQL_ISV_VIEW_TABLE_USAGE = 0x00200000L; | |
1033 const SQL_ISV_VIEWS = 0x00400000L; | |
1034 const SQL_KEYSET_CURSOR_ATTRIBUTES1 = 150; | |
1035 const SQL_KEYSET_CURSOR_ATTRIBUTES2 = 151; | |
1036 const SQL_MAX_ASYNC_CONCURRENT_STATEMENTS = 10022; | |
1037 const SQL_NO_COLUMN_NUMBER = -1; | |
1038 const SQL_NO_ROW_NUMBER = -1; | |
1039 const SQL_NOT_DEFERRABLE = 7; | |
1040 const SQL_NUM_EXTENSIONS = SQL_EXT_API_LAST-SQL_EXT_API_START+1; | |
1041 const SQL_NUM_FUNCTIONS = 23; | |
1042 const SQL_ODBC_INTERFACE_CONFORMANCE = 152; | |
1043 | |
1044 enum : ULONG { | |
1045 SQL_OIC_CORE = 1, | |
1046 SQL_OIC_LEVEL1, | |
1047 SQL_OIC_LEVEL2 | |
1048 } | |
1049 enum : ULONG { | |
1050 SQL_OV_ODBC2 = 2, | |
1051 SQL_OV_ODBC3 = 3 | |
1052 } | |
1053 | |
1054 const ULONG | |
1055 SQL_PARAM_BIND_BY_COLUMN = 0, | |
1056 SQL_PARAM_BIND_TYPE_DEFAULT = SQL_PARAM_BIND_BY_COLUMN; | |
1057 | |
1058 const SQL_PARAM_ARRAY_ROW_COUNTS = 153; | |
1059 const SQL_PARAM_ARRAY_SELECTS = 154; | |
1060 const SQL_PARAM_DIAG_UNAVAILABLE = 1; | |
1061 const SQL_PARAM_ERROR = 5; | |
1062 const SQL_PARAM_IGNORE = 1; | |
1063 const SQL_PARAM_PROCEED = 0; | |
1064 const SQL_PARAM_SUCCESS = 0; | |
1065 const SQL_PARAM_SUCCESS_WITH_INFO = 6; | |
1066 const SQL_PARAM_UNUSED = 7; | |
1067 | |
1068 const SQL_PARC_BATCH = 1; | |
1069 const SQL_PARC_NO_BATCH = 2; | |
1070 const SQL_PAS_BATCH = 1; | |
1071 const SQL_PAS_NO_BATCH = 2; | |
1072 const SQL_PAS_NO_SELECT = 3; | |
1073 | |
1074 const SQL_ROW_IGNORE = 1; | |
1075 const SQL_ROW_NUMBER_UNKNOWN = -2; | |
1076 const SQL_ROW_PROCEED = 0; | |
1077 const SQL_ROW_SUCCESS_WITH_INFO = 6; | |
1078 | |
1079 const SQL_SC_FIPS127_2_TRANSITIONAL = 0x00000002L; | |
1080 const SQL_SC_SQL92_ENTRY = 0x00000001L; | |
1081 const SQL_SC_SQL92_FULL = 0x00000008L; | |
1082 const SQL_SC_SQL92_INTERMEDIATE = 0x00000004L; | |
1083 | |
1084 const SQL_SCC_ISO92_CLI = 0x00000002L; | |
1085 const SQL_SCC_XOPEN_CLI_VERSION1 = 0x00000001L; | |
1086 | |
1087 const SQL_SCHEMA_TERM = SQL_OWNER_TERM; | |
1088 const SQL_SCHEMA_USAGE = SQL_OWNER_USAGE; | |
1089 const SQL_SDF_CURRENT_DATE = 0x00000001L; | |
1090 const SQL_SDF_CURRENT_TIME = 0x00000002L; | |
1091 const SQL_SDF_CURRENT_TIMESTAMP = 0x00000004L; | |
1092 const SQL_SFKD_CASCADE = 0x00000001L; | |
1093 const SQL_SFKD_NO_ACTION = 0x00000002L; | |
1094 const SQL_SFKD_SET_DEFAULT = 0x00000004L; | |
1095 const SQL_SFKD_SET_NULL = 0x00000008L; | |
1096 const SQL_SFKU_CASCADE = 0x00000001L; | |
1097 const SQL_SFKU_NO_ACTION = 0x00000002L; | |
1098 const SQL_SFKU_SET_DEFAULT = 0x00000004L; | |
1099 const SQL_SFKU_SET_NULL = 0x00000008L; | |
1100 const SQL_SG_DELETE_TABLE = 0x00000020L; | |
1101 const SQL_SG_INSERT_COLUMN = 0x00000080L; | |
1102 const SQL_SG_INSERT_TABLE = 0x00000040L; | |
1103 const SQL_SG_REFERENCES_COLUMN = 0x00000200L; | |
1104 const SQL_SG_REFERENCES_TABLE = 0x00000100L; | |
1105 const SQL_SG_SELECT_TABLE = 0x00000400L; | |
1106 const SQL_SG_UPDATE_COLUMN = 0x00001000L; | |
1107 const SQL_SG_UPDATE_TABLE = 0x00000800L; | |
1108 const SQL_SG_USAGE_ON_CHARACTER_SET = 0x00000002L; | |
1109 const SQL_SG_USAGE_ON_COLLATION = 0x00000004L; | |
1110 const SQL_SG_USAGE_ON_DOMAIN = 0x00000001L; | |
1111 const SQL_SG_USAGE_ON_TRANSLATION = 0x00000008L; | |
1112 const SQL_SG_WITH_GRANT_OPTION = 0x00000010L; | |
1113 const SQL_SNVF_BIT_LENGTH = 0x00000001L; | |
1114 const SQL_SNVF_CHAR_LENGTH = 0x00000002L; | |
1115 const SQL_SNVF_CHARACTER_LENGTH = 0x00000004L; | |
1116 const SQL_SNVF_EXTRACT = 0x00000008L; | |
1117 const SQL_SNVF_OCTET_LENGTH = 0x00000010L; | |
1118 const SQL_SNVF_POSITION = 0x00000020L; | |
1119 const SQL_SP_BETWEEN = 0x00000800L; | |
1120 const SQL_SP_COMPARISON = 0x00001000L; | |
1121 const SQL_SP_EXISTS = 0x00000001L; | |
1122 const SQL_SP_IN = 0x00000400L; | |
1123 const SQL_SP_ISNOTNULL = 0x00000002L; | |
1124 const SQL_SP_ISNULL = 0x00000004L; | |
1125 const SQL_SP_LIKE = 0x00000200L; | |
1126 const SQL_SP_MATCH_FULL = 0x00000008L; | |
1127 const SQL_SP_MATCH_PARTIAL = 0x00000010L; | |
1128 const SQL_SP_MATCH_UNIQUE_FULL = 0x00000020L; | |
1129 const SQL_SP_MATCH_UNIQUE_PARTIAL = 0x00000040L; | |
1130 const SQL_SP_OVERLAPS = 0x00000080L; | |
1131 const SQL_SP_QUANTIFIED_COMPARISON = 0x00002000L; | |
1132 const SQL_SP_UNIQUE = 0x00000100L; | |
1133 const SQL_SQL_CONFORMANCE = 118; | |
1134 const SQL_SQL92_DATETIME_FUNCTIONS = 155; | |
1135 const SQL_SQL92_FOREIGN_KEY_DELETE_RULE = 156; | |
1136 const SQL_SQL92_FOREIGN_KEY_UPDATE_RULE = 157; | |
1137 const SQL_SQL92_GRANT = 158; | |
1138 const SQL_SQL92_NUMERIC_VALUE_FUNCTIONS = 159; | |
1139 const SQL_SQL92_PREDICATES = 160; | |
1140 const SQL_SQL92_RELATIONAL_JOIN_OPERATORS = 161; | |
1141 const SQL_SQL92_REVOKE = 162; | |
1142 const SQL_SQL92_ROW_VALUE_CONSTRUCTOR = 163; | |
1143 const SQL_SQL92_STRING_FUNCTIONS = 164; | |
1144 const SQL_SQL92_VALUE_EXPRESSIONS = 165; | |
1145 const SQL_SR_CASCADE = 0x00000020L; | |
1146 const SQL_SR_DELETE_TABLE = 0x00000080L; | |
1147 const SQL_SR_GRANT_OPTION_FOR = 0x00000010L; | |
1148 const SQL_SR_INSERT_COLUMN = 0x00000200L; | |
1149 const SQL_SR_INSERT_TABLE = 0x00000100L; | |
1150 const SQL_SR_REFERENCES_COLUMN = 0x00000800L; | |
1151 const SQL_SR_REFERENCES_TABLE = 0x00000400L; | |
1152 const SQL_SR_RESTRICT = 0x00000040L; | |
1153 const SQL_SR_SELECT_TABLE = 0x00001000L; | |
1154 const SQL_SR_UPDATE_COLUMN = 0x00004000L; | |
1155 const SQL_SR_UPDATE_TABLE = 0x00002000L; | |
1156 const SQL_SR_USAGE_ON_CHARACTER_SET = 0x00000002L; | |
1157 const SQL_SR_USAGE_ON_COLLATION = 0x00000004L; | |
1158 const SQL_SR_USAGE_ON_DOMAIN = 0x00000001L; | |
1159 const SQL_SR_USAGE_ON_TRANSLATION = 0x00000008L; | |
1160 const SQL_SRJO_CORRESPONDING_CLAUSE = 0x00000001L; | |
1161 const SQL_SRJO_CROSS_JOIN = 0x00000002L; | |
1162 const SQL_SRJO_EXCEPT_JOIN = 0x00000004L; | |
1163 const SQL_SRJO_FULL_OUTER_JOIN = 0x00000008L; | |
1164 const SQL_SRJO_INNER_JOIN = 0x00000010L; | |
1165 const SQL_SRJO_INTERSECT_JOIN = 0x00000020L; | |
1166 const SQL_SRJO_LEFT_OUTER_JOIN = 0x00000040L; | |
1167 const SQL_SRJO_NATURAL_JOIN = 0x00000080L; | |
1168 const SQL_SRJO_RIGHT_OUTER_JOIN = 0x00000100L; | |
1169 const SQL_SRJO_UNION_JOIN = 0x00000200L; | |
1170 const SQL_SRVC_DEFAULT = 0x00000004L; | |
1171 const SQL_SRVC_NULL = 0x00000002L; | |
1172 const SQL_SRVC_ROW_SUBQUERY = 0x00000008L; | |
1173 const SQL_SRVC_VALUE_EXPRESSION = 0x00000001L; | |
1174 const SQL_SSF_CONVERT = 0x00000001L; | |
1175 const SQL_SSF_LOWER = 0x00000002L; | |
1176 const SQL_SSF_SUBSTRING = 0x00000008L; | |
1177 const SQL_SSF_TRANSLATE = 0x00000010L; | |
1178 const SQL_SSF_TRIM_BOTH = 0x00000020L; | |
1179 const SQL_SSF_TRIM_LEADING = 0x00000040L; | |
1180 const SQL_SSF_TRIM_TRAILING = 0x00000080L; | |
1181 const SQL_SSF_UPPER = 0x00000004L; | |
1182 const SQL_STANDARD_CLI_CONFORMANCE = 166; | |
1183 const SQL_STATIC_CURSOR_ATTRIBUTES1 = 167; | |
1184 const SQL_STATIC_CURSOR_ATTRIBUTES2 = 168; | |
1185 const SQL_SU_DML_STATEMENTS = SQL_OU_DML_STATEMENTS; | |
1186 const SQL_SU_INDEX_DEFINITION = SQL_OU_INDEX_DEFINITION; | |
1187 const SQL_SU_PRIVILEGE_DEFINITION = SQL_OU_PRIVILEGE_DEFINITION; | |
1188 const SQL_SU_PROCEDURE_INVOCATION = SQL_OU_PROCEDURE_INVOCATION; | |
1189 const SQL_SU_TABLE_DEFINITION = SQL_OU_TABLE_DEFINITION; | |
1190 const SQL_SVE_CASE = 0x00000001L; | |
1191 const SQL_SVE_CAST = 0x00000002L; | |
1192 const SQL_SVE_COALESCE = 0x00000004L; | |
1193 const SQL_SVE_NULLIF = 0x00000008L; | |
1194 const SQL_UB_FIXED = SQL_UB_ON; | |
1195 const SQL_UB_VARIABLE = 2UL; | |
1196 const SQL_UNION_STATEMENT = SQL_UNION; | |
1197 const SQL_UPDATE_BY_BOOKMARK = 5; | |
1198 const SQL_US_UNION = SQL_U_UNION; | |
1199 const SQL_US_UNION_ALL = SQL_U_UNION_ALL; | |
1200 }//[Yes] #endif /* ODBCVER >= 0x300 */ | |
1201 static if (ODBCVER >= 0x0350) { | |
1202 const SQL_DESC_ROWVER = 35; | |
1203 const SQL_GUID = -11; | |
1204 const SQL_C_GUID = SQL_GUID; | |
1205 //#ifdef ODBC_STD | |
1206 //#define SQLAllocHandle SQLAllocHandleStd | |
1207 //#define SQLAllocEnv(p) SQLAllocHandleStd(SQL_HANDLE_ENV, SQL_NULL_HANDLE, p) | |
1208 //#define SQL_YEAR SQL_CODE_YEAR | |
1209 //#define SQL_MONTH SQL_CODE_MONTH | |
1210 //#define SQL_DAY SQL_CODE_DAY | |
1211 //#define SQL_HOUR SQL_CODE_HOUR | |
1212 //#define SQL_MINUTE SQL_CODE_MINUTE | |
1213 //#define SQL_SECOND SQL_CODE_SECOND | |
1214 //#define SQL_YEAR_TO_MONTH SQL_CODE_YEAR_TO_MONTH | |
1215 //#define SQL_DAY_TO_HOUR SQL_CODE_DAY_TO_HOUR | |
1216 //#define SQL_DAY_TO_MINUTE SQL_CODE_DAY_TO_MINUTE | |
1217 //#define SQL_DAY_TO_SECOND SQL_CODE_DAY_TO_SECOND | |
1218 //#define SQL_HOUR_TO_MINUTE SQL_CODE_HOUR_TO_MINUTE | |
1219 //#define SQL_HOUR_TO_SECOND SQL_CODE_HOUR_TO_SECOND | |
1220 //#define SQL_MINUTE_TO_SECOND SQL_CODE_MINUTE_TO_SECOND | |
1221 //#endif /* ODBC_STD */ | |
1222 }//#endif /* ODBCVER >= 0x0350 */ | |
1223 | |
1224 //static if (ODBCVER >= 0x0351) { | |
1225 const SQL_ATTR_ANSI_APP=115; | |
1226 const SQL_AA_TRUE=1L; | |
1227 const SQL_AA_FALSE=0L; | |
1228 //}//[Yes] #endif | |
1229 | |
1230 const TRACE_VERSION=1000; | |
1231 const TRACE_ON=1; | |
1232 | |
1233 const char [] SQL_ODBC_KEYWORDS = | |
1234 "ABSOLUTE, ACTION, ADA, ADD, ALL, ALLOCATE, ALTER, AND, ANY, ARE, AS, " | |
1235 ~ "ASC, ASSERTION, AT, AUTHORIZATION, AVG, " | |
1236 ~ "BEGIN, BETWEEN, BIT, BIT_LENGTH, BOTH, BY, CASCADE, CASCADED, CASE, CAST, CATALOG, " | |
1237 ~ "CHAR, CHAR_LENGTH, CHARACTER, CHARACTER_LENGTH, CHECK, CLOSE, COALESCE, " | |
1238 ~ "COLLATE, COLLATION, COLUMN, COMMIT, CONNECT, CONNECTION, CONSTRAINT, " | |
1239 ~ "CONSTRAINTS, CONTINUE, CONVERT, CORRESPONDING, COUNT, CREATE, CROSS, CURRENT, " | |
1240 ~ "CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, CURRENT_USER, CURSOR, " | |
1241 ~ "DATE, DAY, DEALLOCATE, DEC, DECIMAL, DECLARE, DEFAULT, DEFERRABLE, " | |
1242 ~ "DEFERRED, DELETE, DESC, DESCRIBE, DESCRIPTOR, DIAGNOSTICS, DISCONNECT, " | |
1243 ~ "DISTINCT, DOMAIN, DOUBLE, DROP, " | |
1244 ~ "ELSE, END, END-EXEC, ESCAPE, EXCEPT, EXCEPTION, EXEC, EXECUTE, " | |
1245 ~ "EXISTS, EXTERNAL, EXTRACT, " | |
1246 ~ "FALSE, FETCH, FIRST, FLOAT, FOR, FOREIGN, FORTRAN, FOUND, FROM, FULL, " | |
1247 ~ "GET, GLOBAL, GO, GOTO, GRANT, GROUP, HAVING, HOUR, " | |
1248 ~ "IDENTITY, IMMEDIATE, IN, INCLUDE, INDEX, INDICATOR, INITIALLY, INNER, " | |
1249 ~ "INPUT, INSENSITIVE, INSERT, INT, INTEGER, INTERSECT, INTERVAL, INTO, IS, ISOLATION, " | |
1250 ~ "JOIN, KEY, LANGUAGE, LAST, LEADING, LEFT, LEVEL, LIKE, LOCAL, LOWER, " | |
1251 ~ "MATCH, MAX, MIN, MINUTE, MODULE, MONTH, " | |
1252 ~ "NAMES, NATIONAL, NATURAL, NCHAR, NEXT, NO, NONE, NOT, NULL, NULLIF, NUMERIC, " | |
1253 ~ "OCTET_LENGTH, OF, ON, ONLY, OPEN, OPTION, OR, ORDER, OUTER, OUTPUT, OVERLAPS, " | |
1254 ~ "PAD, PARTIAL, PASCAL, PLI, POSITION, PRECISION, PREPARE, PRESERVE, " | |
1255 ~ "PRIMARY, PRIOR, PRIVILEGES, PROCEDURE, PUBLIC, " | |
1256 ~ "READ, REAL, REFERENCES, RELATIVE, RESTRICT, REVOKE, RIGHT, ROLLBACK, ROWS" | |
1257 ~ "SCHEMA, SCROLL, SECOND, SECTION, SELECT, SESSION, SESSION_USER, SET, SIZE, " | |
1258 ~ "SMALLINT, SOME, SPACE, SQL, SQLCA, SQLCODE, SQLERROR, SQLSTATE, SQLWARNING, " | |
1259 ~ "SUBSTRING, SUM, SYSTEM_USER, " | |
1260 ~ "TABLE, TEMPORARY, THEN, TIME, TIMESTAMP, TIMEZONE_HOUR, TIMEZONE_MINUTE, " | |
1261 ~ "TO, TRAILING, TRANSACTION, TRANSLATE, TRANSLATION, TRIM, TRUE, " | |
1262 ~ "UNION, UNIQUE, UNKNOWN, UPDATE, UPPER, USAGE, USER, USING, " | |
1263 ~ "VALUE, VALUES, VARCHAR, VARYING, VIEW, WHEN, WHENEVER, WHERE, WITH, WORK, WRITE, " | |
1264 ~ "YEAR, ZONE"; | |
1265 extern (Windows) { | |
1266 SQLRETURN SQLDriverConnect(SQLHDBC, SQLHWND, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT, SQLSMALLINT*, SQLUSMALLINT); | |
1267 SQLRETURN SQLBrowseConnect(SQLHDBC, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT, SQLSMALLINT*); | |
1268 SQLRETURN SQLColumnPrivileges(SQLHSTMT, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT); | |
1269 SQLRETURN SQLColAttributes(SQLHSTMT, SQLUSMALLINT, SQLUSMALLINT, SQLPOINTER, SQLSMALLINT, SQLSMALLINT*, SQLLEN*); | |
1270 SQLRETURN SQLDescribeParam(SQLHSTMT, SQLUSMALLINT, SQLSMALLINT*, SQLULEN*, SQLSMALLINT*, SQLSMALLINT*); | |
1271 SQLRETURN SQLExtendedFetch(SQLHSTMT, SQLUSMALLINT, SQLINTEGER, SQLUINTEGER*, SQLUSMALLINT*); | |
1272 SQLRETURN SQLForeignKeys(SQLHSTMT, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT); | |
1273 SQLRETURN SQLMoreResults(SQLHSTMT); | |
1274 SQLRETURN SQLNativeSql(SQLHDBC, SQLCHAR*, SQLINTEGER, SQLCHAR*, SQLINTEGER, SQLINTEGER*); | |
1275 SQLRETURN SQLNumParams(SQLHSTMT, SQLSMALLINT*); | |
1276 SQLRETURN SQLParamOptions(SQLHSTMT, SQLUINTEGER, SQLUINTEGER*); | |
1277 SQLRETURN SQLPrimaryKeys(SQLHSTMT, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT); | |
1278 SQLRETURN SQLProcedureColumns(SQLHSTMT, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT); | |
1279 SQLRETURN SQLProcedures(SQLHSTMT, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT); | |
1280 SQLRETURN SQLSetPos(SQLHSTMT, SQLUSMALLINT, SQLUSMALLINT, SQLUSMALLINT); | |
1281 SQLRETURN SQLTablePrivileges(SQLHSTMT, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT); | |
1282 SQLRETURN SQLDrivers(SQLHENV, SQLUSMALLINT, SQLCHAR*, SQLSMALLINT, SQLSMALLINT*, SQLCHAR*, SQLSMALLINT, SQLSMALLINT*); | |
1283 SQLRETURN SQLBindParameter(SQLHSTMT, SQLUSMALLINT, SQLSMALLINT, SQLSMALLINT, SQLSMALLINT, SQLULEN, SQLSMALLINT, SQLPOINTER, SQLLEN, SQLLEN*); | |
1284 SQLRETURN SQLSetScrollOptions(SQLHSTMT, SQLUSMALLINT, SQLLEN, SQLUSMALLINT);/* deprecated */ | |
1285 DWORD ODBCGetTryWaitValue(); | |
1286 BOOL ODBCSetTryWaitValue(DWORD); | |
1287 RETCODE TraceOpenLogFile(LPWSTR, LPWSTR, DWORD); | |
1288 RETCODE TraceCloseLogFile(); | |
1289 VOID TraceReturn(RETCODE, RETCODE); | |
1290 DWORD TraceVersion(); | |
1291 //static if (ODBCVER >= 0x0300) { | |
1292 SQLRETURN SQLBulkOperations(SQLHSTMT, SQLSMALLINT); | |
1293 SQLRETURN SQLAllocHandleStd( SQLSMALLINT, SQLHANDLE, SQLHANDLE*); | |
1294 //} | |
1295 } |