]>
Commit | Line | Data |
---|---|---|
108106cf | 1 | /////////////////////////////////////////////////////////////////////////////// |
2b5f62a0 | 2 | // Name: wx/db.h |
f6bcfd97 BP |
3 | // Purpose: Header file wxDb class. The wxDb class represents a connection |
4 | // to an ODBC data source. The wxDb class allows operations on the data | |
108106cf JS |
5 | // source such as opening and closing the data source. |
6 | // Author: Doug Card | |
30a6d2d2 | 7 | // Modified by: George Tasker |
3ca6a5f0 | 8 | // Bart Jourquin |
a9f4558f | 9 | // Mark Johnson, wxWindows@mj10777.de |
ad2522ad | 10 | // Mods: Dec, 1998: |
a2115c88 | 11 | // -Added support for SQL statement logging and database cataloging |
95ca6a20 GT |
12 | // April, 1999 |
13 | // -Added QUERY_ONLY mode support to reduce default number of cursors | |
14 | // -Added additional SQL logging code | |
a2115c88 | 15 | // -Added DEBUG-ONLY tracking of Ctable objects to detect orphaned DB connections |
95ca6a20 GT |
16 | // -Set ODBC option to only read committed writes to the DB so all |
17 | // databases operate the same in that respect | |
a2115c88 | 18 | // |
108106cf JS |
19 | // Created: 9.96 |
20 | // RCS-ID: $Id$ | |
21 | // Copyright: (c) 1996 Remstar International, Inc. | |
22 | // Licence: wxWindows licence, plus: | |
95ca6a20 | 23 | // Notice: This class library and its intellectual design are free of charge for use, |
108106cf JS |
24 | // modification, enhancement, debugging under the following conditions: |
25 | // 1) These classes may only be used as part of the implementation of a | |
26 | // wxWindows-based application | |
27 | // 2) All enhancements and bug fixes are to be submitted back to the wxWindows | |
28 | // user groups free of all charges for use with the wxWindows library. | |
29 | // 3) These classes may not be distributed as part of any other class library, | |
30 | // DLL, text (written or electronic), other than a complete distribution of | |
31 | // the wxWindows GUI development toolkit. | |
1fc5dd6f | 32 | // |
108106cf JS |
33 | /////////////////////////////////////////////////////////////////////////////// |
34 | ||
2b5f62a0 VZ |
35 | #ifndef _WX_DB_H_ |
36 | #define _WX_DB_H_ | |
a2115c88 | 37 | |
f6bcfd97 BP |
38 | |
39 | // BJO 20000503: introduce new GetColumns members which are more database independant and | |
40 | // return columns in the order they were created | |
41 | #define OLD_GETCOLUMNS 1 | |
e2f4e132 | 42 | #define EXPERIMENTAL_WXDB_FUNCTIONS 1 |
f6bcfd97 | 43 | |
a2115c88 GT |
44 | #include "wx/version.h" |
45 | ||
af49c4b8 | 46 | #if defined(__GNUG__) && !defined(__APPLE__) |
20987580 | 47 | #pragma interface "db.h" |
108106cf JS |
48 | #endif |
49 | ||
16b52fa1 RR |
50 | #include "wx/setup.h" |
51 | ||
d4af841d GT |
52 | #include "wx/defs.h" |
53 | #include "wx/string.h" | |
54 | ||
190869b2 | 55 | #if defined(__VISUALC__) |
2b5f62a0 VZ |
56 | // we need to include standard Windows headers but we can't include |
57 | // <windows.h> directly when using MFC because it includes it itself in a | |
58 | // different manner | |
59 | #if wxUSE_MFC | |
60 | #include <afxwin.h> | |
61 | #else // !wxUSE_MFC | |
62 | #ifndef STRICT | |
63 | #define STRICT 1 | |
64 | #endif | |
65 | ||
66 | #include <windows.h> | |
67 | #include "wx/msw/winundef.h" | |
68 | #endif // wxUSE_MFC/!wxUSE_MFC | |
69 | ||
70 | // If you use the wxDbCreateDataSource() function with MSW/VC6, | |
71 | // you cannot use the iODBC headers, you must use the VC headers, | |
72 | // plus the odbcinst.h header - gt Nov 2 2000 | |
73 | // | |
74 | // Must add "odbccp32.lib" in \wx2\wxWindows\src\makevc.env to the WINLIBS= line | |
75 | // | |
e2f4e132 GT |
76 | #include "sql.h" |
77 | #include "sqlext.h" | |
78 | #include "odbcinst.h" | |
f7556ff0 | 79 | #else |
190869b2 VS |
80 | #if defined(__WINDOWS__) && defined(HAVE_W32API_H) |
81 | #include <windows.h> | |
82 | #include "wx/msw/winundef.h" | |
83 | #endif | |
f7556ff0 | 84 | // Use the ones from the library |
2b5f62a0 | 85 | extern "C" { |
f7556ff0 JS |
86 | #include <sql.h> |
87 | #include <sqlext.h> | |
2b5f62a0 | 88 | } |
aecca2c8 MB |
89 | #endif |
90 | ||
30a6d2d2 | 91 | |
595b5c4e MJ |
92 | typedef float SFLOAT; |
93 | typedef double SDOUBLE; | |
95ca6a20 GT |
94 | typedef unsigned int UINT; |
95 | #define ULONG UDWORD | |
30a6d2d2 GT |
96 | |
97 | #ifndef wxODBC_FWD_ONLY_CURSORS | |
98 | #define wxODBC_FWD_ONLY_CURSORS 1 | |
99 | #endif | |
100 | ||
95ca6a20 | 101 | enum enumDummy {enumDum1}; |
7e616b10 | 102 | |
b742792c | 103 | #ifndef SQL_C_BOOLEAN |
a2115c88 | 104 | #define SQL_C_BOOLEAN(datatype) (sizeof(datatype) == 1 ? SQL_C_UTINYINT : (sizeof(datatype) == 2 ? SQL_C_USHORT : SQL_C_ULONG)) |
20987580 | 105 | //# define SQL_C_BOOLEAN (sizeof(int) == 2 ? SQL_C_USHORT : SQL_C_ULONG) |
b742792c | 106 | #endif |
20987580 | 107 | |
b742792c | 108 | #ifndef SQL_C_ENUM |
a2115c88 | 109 | #define SQL_C_ENUM (sizeof(enumDummy) == 2 ? SQL_C_USHORT : SQL_C_ULONG) |
b742792c | 110 | #endif |
20987580 | 111 | |
b742792c GT |
112 | #ifndef SQL_C_BLOB |
113 | #ifdef SQL_LONGVARBINARY | |
114 | #define SQL_C_BLOB SQL_LONGVARBINARY | |
115 | #elif SQL_VARBINARY | |
116 | #define SQL_C_BLOB SQL_VARBINARY | |
117 | #endif | |
118 | #endif | |
a144affe | 119 | /* |
a2115c88 | 120 | #ifndef TRUE |
20987580 | 121 | #define TRUE true |
7e616b10 RR |
122 | #endif |
123 | ||
a2115c88 | 124 | #ifndef FALSE |
20987580 | 125 | #define FALSE false |
a2115c88 | 126 | #endif |
a144affe | 127 | */ |
f6bcfd97 | 128 | const int wxDB_PATH_MAX = 254; |
95ca6a20 | 129 | |
bb41dcbe VS |
130 | WXDLLIMPEXP_DATA_ODBC(extern wxChar const *) SQL_LOG_FILENAME; |
131 | WXDLLIMPEXP_DATA_ODBC(extern wxChar const *) SQL_CATALOG_FILENAME; | |
108106cf | 132 | |
108106cf | 133 | // Database Globals |
95ca6a20 | 134 | const int DB_TYPE_NAME_LEN = 40; |
eb3b9dda GT |
135 | const int DB_MAX_STATEMENT_LEN = 4096; |
136 | const int DB_MAX_WHERE_CLAUSE_LEN = 2048; | |
95ca6a20 GT |
137 | const int DB_MAX_ERROR_MSG_LEN = 512; |
138 | const int DB_MAX_ERROR_HISTORY = 5; | |
139 | const int DB_MAX_TABLE_NAME_LEN = 128; | |
140 | const int DB_MAX_COLUMN_NAME_LEN = 128; | |
141 | ||
142 | const int DB_DATA_TYPE_VARCHAR = 1; | |
143 | const int DB_DATA_TYPE_INTEGER = 2; | |
144 | const int DB_DATA_TYPE_FLOAT = 3; | |
145 | const int DB_DATA_TYPE_DATE = 4; | |
b742792c | 146 | const int DB_DATA_TYPE_BLOB = 5; |
95ca6a20 GT |
147 | |
148 | const int DB_SELECT_KEYFIELDS = 1; | |
149 | const int DB_SELECT_WHERE = 2; | |
150 | const int DB_SELECT_MATCHING = 3; | |
151 | const int DB_SELECT_STATEMENT = 4; | |
152 | ||
153 | const int DB_UPD_KEYFIELDS = 1; | |
154 | const int DB_UPD_WHERE = 2; | |
155 | ||
156 | const int DB_DEL_KEYFIELDS = 1; | |
157 | const int DB_DEL_WHERE = 2; | |
158 | const int DB_DEL_MATCHING = 3; | |
159 | ||
160 | const int DB_WHERE_KEYFIELDS = 1; | |
161 | const int DB_WHERE_MATCHING = 2; | |
162 | ||
163 | const int DB_GRANT_SELECT = 1; | |
164 | const int DB_GRANT_INSERT = 2; | |
165 | const int DB_GRANT_UPDATE = 4; | |
166 | const int DB_GRANT_DELETE = 8; | |
167 | const int DB_GRANT_ALL = DB_GRANT_SELECT | DB_GRANT_INSERT | DB_GRANT_UPDATE | DB_GRANT_DELETE; | |
108106cf JS |
168 | |
169 | // ODBC Error codes (derived from ODBC SqlState codes) | |
fdc03678 | 170 | enum wxODBC_ERRORS |
108106cf | 171 | { |
95ca6a20 GT |
172 | DB_FAILURE = 0, |
173 | DB_SUCCESS = 1, | |
174 | DB_ERR_NOT_IN_USE, | |
175 | DB_ERR_GENERAL_WARNING, // SqlState = '01000' | |
176 | DB_ERR_DISCONNECT_ERROR, // SqlState = '01002' | |
177 | DB_ERR_DATA_TRUNCATED, // SqlState = '01004' | |
178 | DB_ERR_PRIV_NOT_REVOKED, // SqlState = '01006' | |
179 | DB_ERR_INVALID_CONN_STR_ATTR, // SqlState = '01S00' | |
180 | DB_ERR_ERROR_IN_ROW, // SqlState = '01S01' | |
181 | DB_ERR_OPTION_VALUE_CHANGED, // SqlState = '01S02' | |
182 | DB_ERR_NO_ROWS_UPD_OR_DEL, // SqlState = '01S03' | |
183 | DB_ERR_MULTI_ROWS_UPD_OR_DEL, // SqlState = '01S04' | |
184 | DB_ERR_WRONG_NO_OF_PARAMS, // SqlState = '07001' | |
185 | DB_ERR_DATA_TYPE_ATTR_VIOL, // SqlState = '07006' | |
186 | DB_ERR_UNABLE_TO_CONNECT, // SqlState = '08001' | |
187 | DB_ERR_CONNECTION_IN_USE, // SqlState = '08002' | |
188 | DB_ERR_CONNECTION_NOT_OPEN, // SqlState = '08003' | |
189 | DB_ERR_REJECTED_CONNECTION, // SqlState = '08004' | |
190 | DB_ERR_CONN_FAIL_IN_TRANS, // SqlState = '08007' | |
191 | DB_ERR_COMM_LINK_FAILURE, // SqlState = '08S01' | |
192 | DB_ERR_INSERT_VALUE_LIST_MISMATCH, // SqlState = '21S01' | |
193 | DB_ERR_DERIVED_TABLE_MISMATCH, // SqlState = '21S02' | |
194 | DB_ERR_STRING_RIGHT_TRUNC, // SqlState = '22001' | |
195 | DB_ERR_NUMERIC_VALUE_OUT_OF_RNG, // SqlState = '22003' | |
196 | DB_ERR_ERROR_IN_ASSIGNMENT, // SqlState = '22005' | |
197 | DB_ERR_DATETIME_FLD_OVERFLOW, // SqlState = '22008' | |
198 | DB_ERR_DIVIDE_BY_ZERO, // SqlState = '22012' | |
199 | DB_ERR_STR_DATA_LENGTH_MISMATCH, // SqlState = '22026' | |
200 | DB_ERR_INTEGRITY_CONSTRAINT_VIOL, // SqlState = '23000' | |
201 | DB_ERR_INVALID_CURSOR_STATE, // SqlState = '24000' | |
202 | DB_ERR_INVALID_TRANS_STATE, // SqlState = '25000' | |
203 | DB_ERR_INVALID_AUTH_SPEC, // SqlState = '28000' | |
204 | DB_ERR_INVALID_CURSOR_NAME, // SqlState = '34000' | |
205 | DB_ERR_SYNTAX_ERROR_OR_ACCESS_VIOL, // SqlState = '37000' | |
206 | DB_ERR_DUPLICATE_CURSOR_NAME, // SqlState = '3C000' | |
207 | DB_ERR_SERIALIZATION_FAILURE, // SqlState = '40001' | |
208 | DB_ERR_SYNTAX_ERROR_OR_ACCESS_VIOL2, // SqlState = '42000' | |
209 | DB_ERR_OPERATION_ABORTED, // SqlState = '70100' | |
210 | DB_ERR_UNSUPPORTED_FUNCTION, // SqlState = 'IM001' | |
211 | DB_ERR_NO_DATA_SOURCE, // SqlState = 'IM002' | |
212 | DB_ERR_DRIVER_LOAD_ERROR, // SqlState = 'IM003' | |
213 | DB_ERR_SQLALLOCENV_FAILED, // SqlState = 'IM004' | |
214 | DB_ERR_SQLALLOCCONNECT_FAILED, // SqlState = 'IM005' | |
215 | DB_ERR_SQLSETCONNECTOPTION_FAILED, // SqlState = 'IM006' | |
216 | DB_ERR_NO_DATA_SOURCE_DLG_PROHIB, // SqlState = 'IM007' | |
217 | DB_ERR_DIALOG_FAILED, // SqlState = 'IM008' | |
218 | DB_ERR_UNABLE_TO_LOAD_TRANSLATION_DLL, // SqlState = 'IM009' | |
219 | DB_ERR_DATA_SOURCE_NAME_TOO_LONG, // SqlState = 'IM010' | |
220 | DB_ERR_DRIVER_NAME_TOO_LONG, // SqlState = 'IM011' | |
221 | DB_ERR_DRIVER_KEYWORD_SYNTAX_ERROR, // SqlState = 'IM012' | |
222 | DB_ERR_TRACE_FILE_ERROR, // SqlState = 'IM013' | |
223 | DB_ERR_TABLE_OR_VIEW_ALREADY_EXISTS, // SqlState = 'S0001' | |
224 | DB_ERR_TABLE_NOT_FOUND, // SqlState = 'S0002' | |
225 | DB_ERR_INDEX_ALREADY_EXISTS, // SqlState = 'S0011' | |
226 | DB_ERR_INDEX_NOT_FOUND, // SqlState = 'S0012' | |
227 | DB_ERR_COLUMN_ALREADY_EXISTS, // SqlState = 'S0021' | |
228 | DB_ERR_COLUMN_NOT_FOUND, // SqlState = 'S0022' | |
229 | DB_ERR_NO_DEFAULT_FOR_COLUMN, // SqlState = 'S0023' | |
230 | DB_ERR_GENERAL_ERROR, // SqlState = 'S1000' | |
231 | DB_ERR_MEMORY_ALLOCATION_FAILURE, // SqlState = 'S1001' | |
232 | DB_ERR_INVALID_COLUMN_NUMBER, // SqlState = 'S1002' | |
233 | DB_ERR_PROGRAM_TYPE_OUT_OF_RANGE, // SqlState = 'S1003' | |
234 | DB_ERR_SQL_DATA_TYPE_OUT_OF_RANGE, // SqlState = 'S1004' | |
235 | DB_ERR_OPERATION_CANCELLED, // SqlState = 'S1008' | |
236 | DB_ERR_INVALID_ARGUMENT_VALUE, // SqlState = 'S1009' | |
237 | DB_ERR_FUNCTION_SEQUENCE_ERROR, // SqlState = 'S1010' | |
238 | DB_ERR_OPERATION_INVALID_AT_THIS_TIME, // SqlState = 'S1011' | |
239 | DB_ERR_INVALID_TRANS_OPERATION_CODE, // SqlState = 'S1012' | |
240 | DB_ERR_NO_CURSOR_NAME_AVAIL, // SqlState = 'S1015' | |
241 | DB_ERR_INVALID_STR_OR_BUF_LEN, // SqlState = 'S1090' | |
242 | DB_ERR_DESCRIPTOR_TYPE_OUT_OF_RANGE, // SqlState = 'S1091' | |
243 | DB_ERR_OPTION_TYPE_OUT_OF_RANGE, // SqlState = 'S1092' | |
244 | DB_ERR_INVALID_PARAM_NO, // SqlState = 'S1093' | |
245 | DB_ERR_INVALID_SCALE_VALUE, // SqlState = 'S1094' | |
246 | DB_ERR_FUNCTION_TYPE_OUT_OF_RANGE, // SqlState = 'S1095' | |
247 | DB_ERR_INF_TYPE_OUT_OF_RANGE, // SqlState = 'S1096' | |
248 | DB_ERR_COLUMN_TYPE_OUT_OF_RANGE, // SqlState = 'S1097' | |
249 | DB_ERR_SCOPE_TYPE_OUT_OF_RANGE, // SqlState = 'S1098' | |
250 | DB_ERR_NULLABLE_TYPE_OUT_OF_RANGE, // SqlState = 'S1099' | |
251 | DB_ERR_UNIQUENESS_OPTION_TYPE_OUT_OF_RANGE, // SqlState = 'S1100' | |
252 | DB_ERR_ACCURACY_OPTION_TYPE_OUT_OF_RANGE, // SqlState = 'S1101' | |
253 | DB_ERR_DIRECTION_OPTION_OUT_OF_RANGE, // SqlState = 'S1103' | |
254 | DB_ERR_INVALID_PRECISION_VALUE, // SqlState = 'S1104' | |
255 | DB_ERR_INVALID_PARAM_TYPE, // SqlState = 'S1105' | |
256 | DB_ERR_FETCH_TYPE_OUT_OF_RANGE, // SqlState = 'S1106' | |
257 | DB_ERR_ROW_VALUE_OUT_OF_RANGE, // SqlState = 'S1107' | |
258 | DB_ERR_CONCURRENCY_OPTION_OUT_OF_RANGE, // SqlState = 'S1108' | |
259 | DB_ERR_INVALID_CURSOR_POSITION, // SqlState = 'S1109' | |
260 | DB_ERR_INVALID_DRIVER_COMPLETION, // SqlState = 'S1110' | |
261 | DB_ERR_INVALID_BOOKMARK_VALUE, // SqlState = 'S1111' | |
262 | DB_ERR_DRIVER_NOT_CAPABLE, // SqlState = 'S1C00' | |
263 | DB_ERR_TIMEOUT_EXPIRED // SqlState = 'S1T00' | |
108106cf JS |
264 | }; |
265 | ||
5cf34cf0 GT |
266 | #ifndef MAXNAME |
267 | #define MAXNAME 31 | |
268 | #endif | |
269 | ||
270 | #ifndef SQL_MAX_AUTHSTR_LEN | |
271 | // There does not seem to be a standard for this, so I am | |
272 | // defaulting to the value that MS uses | |
273 | #define SQL_MAX_AUTHSTR_LEN MAXNAME | |
274 | #endif | |
95ca6a20 | 275 | |
bb41dcbe | 276 | class WXDLLIMPEXP_ODBC wxDbConnectInf |
108106cf | 277 | { |
5cf34cf0 GT |
278 | private: |
279 | bool freeHenvOnDestroy; | |
a2115c88 | 280 | |
5cf34cf0 | 281 | public: |
2f971924 GT |
282 | HENV Henv; |
283 | wxChar Dsn[SQL_MAX_DSN_LENGTH+1]; // Data Source Name | |
284 | wxChar Uid[SQL_MAX_USER_NAME_LEN+1]; // User ID | |
285 | wxChar AuthStr[SQL_MAX_AUTHSTR_LEN+1]; // Authorization string (password) | |
5cf34cf0 GT |
286 | |
287 | wxString Description; // Not sure what the max length is | |
288 | wxString FileType; // Not sure what the max length is | |
289 | ||
290 | // Optionals needed for some databases like dBase | |
291 | wxString DefaultDir; // Directory that db file resides in | |
292 | ||
293 | public: | |
294 | ||
295 | wxDbConnectInf(); | |
da99271d GT |
296 | wxDbConnectInf(HENV henv, const wxString &dsn, const wxString &userID=wxEmptyString, |
297 | const wxString &password=wxEmptyString, const wxString &defaultDir=wxEmptyString, | |
298 | const wxString &description=wxEmptyString, const wxString &fileType=wxEmptyString); | |
5cf34cf0 GT |
299 | |
300 | ~wxDbConnectInf(); | |
301 | ||
302 | bool Initialize(); | |
303 | ||
304 | bool AllocHenv(); | |
305 | void FreeHenv(); | |
306 | ||
307 | // Accessors | |
6a71ee86 | 308 | const HENV &GetHenv() { return Henv; }; |
5cf34cf0 GT |
309 | |
310 | const wxChar *GetDsn() { return Dsn; }; | |
311 | ||
312 | const wxChar *GetUid() { return Uid; }; | |
313 | const wxChar *GetUserID() { return Uid; }; | |
314 | ||
315 | const wxChar *GetAuthStr() { return AuthStr; }; | |
316 | const wxChar *GetPassword() { return AuthStr; }; | |
317 | ||
318 | const wxChar *GetDescription() { return Description; }; | |
319 | const wxChar *GetFileType() { return FileType; }; | |
320 | const wxChar *GetDefaultDir() { return DefaultDir; }; | |
321 | ||
322 | void SetHenv(const HENV henv) { Henv = henv; }; | |
323 | ||
324 | void SetDsn(const wxString &dsn); | |
325 | ||
326 | void SetUserID(const wxString &userID); | |
327 | void SetUid(const wxString &uid) { SetUserID(uid); }; | |
328 | ||
329 | void SetPassword(const wxString &password); | |
330 | void SetAuthStr(const wxString &authstr) { SetPassword(authstr); }; | |
331 | ||
332 | void SetDescription(const wxString &desc) { Description = desc; }; | |
333 | void SetFileType(const wxString &fileType) { FileType = fileType; }; | |
334 | void SetDefaultDir(const wxString &defDir) { DefaultDir = defDir; }; | |
335 | }; // class wxDbConnectInf | |
a2115c88 | 336 | |
108106cf | 337 | |
bb41dcbe | 338 | struct WXDLLIMPEXP_ODBC wxDbSqlTypeInfo |
108106cf | 339 | { |
4fdae997 | 340 | wxString TypeName; |
02cf6fdd | 341 | SWORD FsqlType; |
4fdae997 GT |
342 | long Precision; |
343 | short CaseSensitive; | |
344 | // short MinimumScale; | |
345 | short MaximumScale; | |
fdc03678 | 346 | }; |
108106cf | 347 | |
95ca6a20 | 348 | |
bb41dcbe | 349 | class WXDLLIMPEXP_ODBC wxDbColFor |
30a6d2d2 | 350 | { |
95ca6a20 | 351 | public: |
5cf34cf0 GT |
352 | wxString s_Field; // Formated String for Output |
353 | wxString s_Format[7]; // Formated Objects - TIMESTAMP has the biggest (7) | |
3ca6a5f0 BP |
354 | wxString s_Amount[7]; // Formated Objects - amount of things that can be formatted |
355 | int i_Amount[7]; // Formated Objects - TT MM YYYY HH MM SS m | |
5cf34cf0 GT |
356 | int i_Nation; // 0 = timestamp , 1=EU, 2=UK, 3=International, 4=US |
357 | int i_dbDataType; // conversion of the 'sqlDataType' to the generic data type used by these classes | |
95ca6a20 GT |
358 | SWORD i_sqlDataType; |
359 | ||
f6bcfd97 BP |
360 | wxDbColFor(); |
361 | ~wxDbColFor(); | |
595b5c4e | 362 | |
6a71ee86 | 363 | void Initialize(); |
95ca6a20 | 364 | int Format(int Nation, int dbDataType, SWORD sqlDataType, short columnSize, short decimalDigits); |
30a6d2d2 GT |
365 | }; |
366 | ||
95ca6a20 | 367 | |
bb41dcbe | 368 | class WXDLLIMPEXP_ODBC wxDbColInf |
108106cf JS |
369 | { |
370 | public: | |
4fdae997 GT |
371 | wxChar catalog[128+1]; |
372 | wxChar schema[128+1]; | |
373 | wxChar tableName[DB_MAX_TABLE_NAME_LEN+1]; | |
374 | wxChar colName[DB_MAX_COLUMN_NAME_LEN+1]; | |
95ca6a20 | 375 | SWORD sqlDataType; |
4fdae997 | 376 | wxChar typeName[128+1]; |
95ca6a20 GT |
377 | SWORD columnSize; |
378 | SWORD bufferLength; | |
379 | short decimalDigits; | |
380 | short numPrecRadix; | |
381 | short nullable; | |
4fdae997 | 382 | wxChar remarks[254+1]; |
95ca6a20 | 383 | int dbDataType; // conversion of the 'sqlDataType' to the generic data type used by these classes |
30a6d2d2 GT |
384 | // mj10777.19991224 : new |
385 | int PkCol; // Primary key column 0=No; 1= First Key, 2 = Second Key etc. | |
4fdae997 | 386 | wxChar PkTableName[DB_MAX_TABLE_NAME_LEN+1]; // Tables that use this PKey as a FKey |
30a6d2d2 | 387 | int FkCol; // Foreign key column 0=No; 1= First Key, 2 = Second Key etc. |
4fdae997 | 388 | wxChar FkTableName[DB_MAX_TABLE_NAME_LEN+1]; // Foreign key table name |
f6bcfd97 | 389 | wxDbColFor *pColFor; // How should this columns be formatted |
3ca6a5f0 BP |
390 | |
391 | wxDbColInf(); | |
392 | ~wxDbColInf(); | |
da99271d GT |
393 | |
394 | bool Initialize(); | |
30a6d2d2 GT |
395 | }; |
396 | ||
95ca6a20 | 397 | |
bb41dcbe | 398 | class WXDLLIMPEXP_ODBC wxDbTableInf // Description of a Table |
95ca6a20 | 399 | { |
30a6d2d2 | 400 | public: |
4fdae997 GT |
401 | wxChar tableName[DB_MAX_TABLE_NAME_LEN+1]; |
402 | wxChar tableType[254+1]; // "TABLE" or "SYSTEM TABLE" etc. | |
403 | wxChar tableRemarks[254+1]; | |
02cf6fdd | 404 | UWORD numCols; // How many Columns does this Table have: GetColumnCount(..); |
f6bcfd97 | 405 | wxDbColInf *pColInf; // pColInf = NULL ; User can later call GetColumns(..); |
da99271d | 406 | |
3ca6a5f0 BP |
407 | wxDbTableInf(); |
408 | ~wxDbTableInf(); | |
da99271d GT |
409 | |
410 | bool Initialize(); | |
30a6d2d2 GT |
411 | }; |
412 | ||
95ca6a20 | 413 | |
bb41dcbe | 414 | class WXDLLIMPEXP_ODBC wxDbInf // Description of a Database |
95ca6a20 | 415 | { |
30a6d2d2 | 416 | public: |
4fdae997 GT |
417 | wxChar catalog[128+1]; |
418 | wxChar schema[128+1]; | |
f6bcfd97 BP |
419 | int numTables; // How many tables does this database have |
420 | wxDbTableInf *pTableInf; // pTableInf = new wxDbTableInf[numTables]; | |
3ca6a5f0 BP |
421 | |
422 | wxDbInf(); | |
423 | ~wxDbInf(); | |
6a71ee86 | 424 | |
da99271d | 425 | bool Initialize(); |
108106cf JS |
426 | }; |
427 | ||
95ca6a20 | 428 | |
f6bcfd97 | 429 | enum wxDbSqlLogState |
1fc5dd6f | 430 | { |
95ca6a20 GT |
431 | sqlLogOFF, |
432 | sqlLogON | |
1fc5dd6f JS |
433 | }; |
434 | ||
95ca6a20 | 435 | // These are the databases currently tested and working with these classes |
f6bcfd97 | 436 | // See the comments in wxDb::Dbms() for exceptions/issues with |
95ca6a20 | 437 | // each of these database engines |
fdc03678 | 438 | enum wxDBMS |
a2115c88 | 439 | { |
95ca6a20 GT |
440 | dbmsUNIDENTIFIED, |
441 | dbmsORACLE, | |
442 | dbmsSYBASE_ASA, // Adaptive Server Anywhere | |
443 | dbmsSYBASE_ASE, // Adaptive Server Enterprise | |
444 | dbmsMS_SQL_SERVER, | |
445 | dbmsMY_SQL, | |
446 | dbmsPOSTGRES, | |
447 | dbmsACCESS, | |
448 | dbmsDBASE, | |
f6bcfd97 | 449 | dbmsINFORMIX, |
e2f4e132 | 450 | dbmsVIRTUOSO, |
d8a0a1c9 | 451 | dbmsDB2, |
1b12ab16 | 452 | dbmsINTERBASE, |
9f4de2dc JS |
453 | dbmsPERVASIVE_SQL, |
454 | dbmsXBASE_SEQUITER | |
a2115c88 GT |
455 | }; |
456 | ||
95ca6a20 | 457 | |
f6bcfd97 | 458 | // The wxDb::errorList is copied to this variable when the wxDb object |
a2115c88 | 459 | // is closed. This way, the error list is still available after the |
595b5c4e | 460 | // database object is closed. This is necessary if the database |
a2115c88 | 461 | // connection fails so the calling application can show the operator |
f6bcfd97 BP |
462 | // why the connection failed. Note: as each wxDb object is closed, it |
463 | // will overwrite the errors of the previously destroyed wxDb object in | |
a2115c88 | 464 | // this variable. |
8a77c0d7 | 465 | |
bddd7a8d | 466 | WXDLLIMPEXP_DATA_BASE(extern wxChar) |
886dd7d2 | 467 | DBerrorList[DB_MAX_ERROR_HISTORY][DB_MAX_ERROR_MSG_LEN]; |
a2115c88 | 468 | |
95ca6a20 | 469 | |
bb41dcbe | 470 | class WXDLLIMPEXP_ODBC wxDb |
108106cf JS |
471 | { |
472 | private: | |
95ca6a20 | 473 | bool dbIsOpen; |
20987580 | 474 | bool dbIsCached; // Was connection created by caching functions |
4fdae997 GT |
475 | wxString dsn; // Data source name |
476 | wxString uid; // User ID | |
477 | wxString authStr; // Authorization string (password) | |
95ca6a20 | 478 | FILE *fpSqlLog; // Sql Log file pointer |
f6bcfd97 | 479 | wxDbSqlLogState sqlLogState; // On or Off |
95ca6a20 | 480 | bool fwdOnlyCursors; |
e2f4e132 | 481 | wxDBMS dbmsType; // Type of datasource - i.e. Oracle, dBase, SQLServer, etc |
95ca6a20 GT |
482 | |
483 | // Private member functions | |
484 | bool getDbInfo(void); | |
f6bcfd97 | 485 | bool getDataTypeInfo(SWORD fSqlType, wxDbSqlTypeInfo &structSQLTypeInfo); |
95ca6a20 | 486 | bool setConnectionOptions(void); |
4fdae997 | 487 | void logError(const wxString &errMsg, const wxString &SQLState); |
4fdae997 | 488 | const wxChar *convertUserID(const wxChar *userID, wxString &UserID); |
da99271d | 489 | void initialize(); |
4fdae997 | 490 | |
f6bcfd97 BP |
491 | #if !wxODBC_BACKWARD_COMPATABILITY |
492 | // ODBC handles | |
493 | HENV henv; // ODBC Environment handle | |
494 | HDBC hdbc; // ODBC DB Connection handle | |
495 | HSTMT hstmt; // ODBC Statement handle | |
496 | ||
497 | //Error reporting mode | |
498 | bool silent; | |
499 | ||
500 | // Number of Ctable objects connected to this db object. FOR INTERNAL USE ONLY!!! | |
501 | unsigned int nTables; | |
502 | ||
503 | // Information about logical data types VARCHAR, INTEGER, FLOAT and DATE. | |
3ca6a5f0 | 504 | // |
f6bcfd97 BP |
505 | // This information is obtained from the ODBC driver by use of the |
506 | // SQLGetTypeInfo() function. The key piece of information is the | |
507 | // type name the data source uses for each logical data type. | |
508 | // e.g. VARCHAR; Oracle calls it VARCHAR2. | |
509 | wxDbSqlTypeInfo typeInfVarchar; | |
510 | wxDbSqlTypeInfo typeInfInteger; | |
511 | wxDbSqlTypeInfo typeInfFloat; | |
512 | wxDbSqlTypeInfo typeInfDate; | |
b742792c | 513 | wxDbSqlTypeInfo typeInfBlob; |
f6bcfd97 | 514 | #endif |
a3439c7d | 515 | |
108106cf | 516 | public: |
b742792c | 517 | |
20987580 GT |
518 | void setCached(bool cached) { dbIsCached = cached; }; // This function must only be called by wxDbGetConnection() and wxDbCloseConnections!!! |
519 | bool IsCached() { return dbIsCached; }; | |
520 | ||
b742792c GT |
521 | bool GetDataTypeInfo(SWORD fSqlType, wxDbSqlTypeInfo &structSQLTypeInfo) |
522 | { return getDataTypeInfo(fSqlType, structSQLTypeInfo); } | |
523 | ||
f6bcfd97 BP |
524 | #if wxODBC_BACKWARD_COMPATABILITY |
525 | // ODBC handles | |
526 | HENV henv; // ODBC Environment handle | |
527 | HDBC hdbc; // ODBC DB Connection handle | |
528 | HSTMT hstmt; // ODBC Statement handle | |
529 | ||
530 | //Error reporting mode | |
531 | bool silent; | |
532 | ||
533 | // Number of Ctable objects connected to this db object. FOR INTERNAL USE ONLY!!! | |
534 | unsigned int nTables; | |
535 | #endif | |
536 | ||
95ca6a20 GT |
537 | // The following structure contains database information gathered from the |
538 | // datasource when the datasource is first opened. | |
539 | struct | |
540 | { | |
4fdae997 GT |
541 | wxChar dbmsName[40]; // Name of the dbms product |
542 | wxChar dbmsVer[64]; // Version # of the dbms product | |
543 | wxChar driverName[40]; // Driver name | |
544 | wxChar odbcVer[60]; // ODBC version of the driver | |
545 | wxChar drvMgrOdbcVer[60]; // ODBC version of the driver manager | |
546 | wxChar driverVer[60]; // Driver version | |
547 | wxChar serverName[80]; // Server Name, typically a connect string | |
548 | wxChar databaseName[128]; // Database filename | |
549 | wxChar outerJoins[2]; // Indicates whether the data source supports outer joins | |
550 | wxChar procedureSupport[2]; // Indicates whether the data source supports stored procedures | |
551 | wxChar accessibleTables[2]; // Indicates whether the data source only reports accessible tables in SQLTables. | |
95ca6a20 GT |
552 | UWORD maxConnections; // Maximum # of connections the data source supports |
553 | UWORD maxStmts; // Maximum # of HSTMTs per HDBC | |
554 | UWORD apiConfLvl; // ODBC API conformance level | |
555 | UWORD cliConfLvl; // Indicates whether the data source is SAG compliant | |
556 | UWORD sqlConfLvl; // SQL conformance level | |
557 | UWORD cursorCommitBehavior; // Indicates how cursors are affected by a db commit | |
558 | UWORD cursorRollbackBehavior; // Indicates how cursors are affected by a db rollback | |
559 | UWORD supportNotNullClause; // Indicates if data source supports NOT NULL clause | |
4fdae997 | 560 | wxChar supportIEF[2]; // Integrity Enhancement Facility (Referential Integrity) |
95ca6a20 GT |
561 | UDWORD txnIsolation; // Default transaction isolation level supported by the driver |
562 | UDWORD txnIsolationOptions; // Transaction isolation level options available | |
563 | UDWORD fetchDirections; // Fetch directions supported | |
564 | UDWORD lockTypes; // Lock types supported in SQLSetPos | |
565 | UDWORD posOperations; // Position operations supported in SQLSetPos | |
566 | UDWORD posStmts; // Position statements supported | |
567 | UDWORD scrollConcurrency; // Concurrency control options supported for scrollable cursors | |
568 | UDWORD scrollOptions; // Scroll Options supported for scrollable cursors | |
569 | UDWORD staticSensitivity; // Indicates if additions, deletions and updates can be detected | |
570 | UWORD txnCapable; // Indicates if the data source supports transactions | |
571 | UDWORD loginTimeout; // Number seconds to wait for a login request | |
572 | } dbInf; | |
573 | ||
95ca6a20 | 574 | // ODBC Error Inf. |
95ca6a20 | 575 | SWORD cbErrorMsg; |
95ca6a20 | 576 | int DB_STATUS; |
f6bcfd97 BP |
577 | wxChar errorList[DB_MAX_ERROR_HISTORY][DB_MAX_ERROR_MSG_LEN]; |
578 | wxChar errorMsg[SQL_MAX_MESSAGE_LENGTH]; | |
579 | SDWORD nativeError; | |
580 | wxChar sqlState[20]; | |
95ca6a20 | 581 | |
f6bcfd97 BP |
582 | #if wxODBC_BACKWARD_COMPATABILITY |
583 | // Information about logical data types VARCHAR, INTEGER, FLOAT and DATE. | |
3ca6a5f0 | 584 | // |
f6bcfd97 BP |
585 | // This information is obtained from the ODBC driver by use of the |
586 | // SQLGetTypeInfo() function. The key piece of information is the | |
95ca6a20 GT |
587 | // type name the data source uses for each logical data type. |
588 | // e.g. VARCHAR; Oracle calls it VARCHAR2. | |
f6bcfd97 BP |
589 | wxDbSqlTypeInfo typeInfVarchar; |
590 | wxDbSqlTypeInfo typeInfInteger; | |
591 | wxDbSqlTypeInfo typeInfFloat; | |
592 | wxDbSqlTypeInfo typeInfDate; | |
b742792c | 593 | wxDbSqlTypeInfo typeInfBlob; |
f6bcfd97 | 594 | #endif |
595b5c4e | 595 | |
95ca6a20 | 596 | // Public member functions |
6a71ee86 | 597 | wxDb(const HENV &aHenv, bool FwdOnlyCursors=(bool)wxODBC_FWD_ONLY_CURSORS); |
20987580 | 598 | ~wxDb(); |
5cf34cf0 | 599 | |
e25cdb86 GT |
600 | // Data Source Name, User ID, Password and whether open should fail on data type not supported |
601 | bool Open(const wxString &Dsn, const wxString &Uid, const wxString &AuthStr, bool failOnDataTypeUnsupported=TRUE); | |
6a71ee86 | 602 | bool Open(wxDbConnectInf *dbConnectInf); |
e2f4e132 | 603 | bool Open(wxDb *copyDb); // pointer to a wxDb whose connection info should be copied rather than re-queried |
95ca6a20 GT |
604 | void Close(void); |
605 | bool CommitTrans(void); | |
606 | bool RollbackTrans(void); | |
607 | bool DispAllErrors(HENV aHenv, HDBC aHdbc = SQL_NULL_HDBC, HSTMT aHstmt = SQL_NULL_HSTMT); | |
608 | bool GetNextError(HENV aHenv, HDBC aHdbc = SQL_NULL_HDBC, HSTMT aHstmt = SQL_NULL_HSTMT); | |
609 | void DispNextError(void); | |
a144affe | 610 | bool CreateView(const wxString &viewName, const wxString &colList, const wxString &pSqlStmt, bool attemptDrop=TRUE); |
4fdae997 GT |
611 | bool DropView(const wxString &viewName); |
612 | bool ExecSql(const wxString &pSqlStmt); | |
95ca6a20 GT |
613 | bool GetNext(void); |
614 | bool GetData(UWORD colNo, SWORD cType, PTR pData, SDWORD maxLen, SDWORD FAR *cbReturned); | |
4fdae997 GT |
615 | bool Grant(int privileges, const wxString &tableName, const wxString &userList = wxT("PUBLIC")); |
616 | int TranslateSqlState(const wxString &SQLState); | |
617 | wxDbInf *GetCatalog(const wxChar *userID=NULL); | |
618 | bool Catalog(const wxChar *userID=NULL, const wxString &fileName=SQL_CATALOG_FILENAME); | |
02cf6fdd | 619 | int GetKeyFields(const wxString &tableName, wxDbColInf* colInf, UWORD noCols); |
4fdae997 GT |
620 | |
621 | wxDbColInf *GetColumns(wxChar *tableName[], const wxChar *userID=NULL); | |
02cf6fdd | 622 | wxDbColInf *GetColumns(const wxString &tableName, UWORD *numCols, const wxChar *userID=NULL); |
4fdae997 | 623 | |
dba2120c | 624 | int GetColumnCount(const wxString &tableName, const wxChar *userID=NULL); |
b742792c | 625 | const wxChar *GetDatabaseName(void) {return dbInf.dbmsName;} |
4fdae997 GT |
626 | const wxString &GetDataSource(void) {return dsn;} |
627 | const wxString &GetDatasourceName(void){return dsn;} | |
628 | const wxString &GetUsername(void) {return uid;} | |
629 | const wxString &GetPassword(void) {return authStr;} | |
b742792c GT |
630 | bool IsOpen(void) {return dbIsOpen;} |
631 | HENV GetHENV(void) {return henv;} | |
632 | HDBC GetHDBC(void) {return hdbc;} | |
633 | HSTMT GetHSTMT(void) {return hstmt;} | |
634 | int GetTableCount() {return nTables;} // number of tables using this connection | |
635 | wxDbSqlTypeInfo GetTypeInfVarchar() {return typeInfVarchar;} | |
636 | wxDbSqlTypeInfo GetTypeInfInteger() {return typeInfInteger;} | |
637 | wxDbSqlTypeInfo GetTypeInfFloat() {return typeInfFloat;} | |
638 | wxDbSqlTypeInfo GetTypeInfDate() {return typeInfDate;} | |
639 | wxDbSqlTypeInfo GetTypeInfBlob() {return typeInfBlob;} | |
640 | ||
641 | // tableName can refer to a table, view, alias or synonym | |
642 | bool TableExists(const wxString &tableName, const wxChar *userID=NULL, | |
643 | const wxString &tablePath=wxEmptyString); | |
644 | bool TablePrivileges(const wxString &tableName, const wxString &priv, | |
645 | const wxChar *userID=NULL, const wxChar *schema=NULL, | |
646 | const wxString &path=wxEmptyString); | |
647 | ||
243d4b36 GT |
648 | // These two functions return the table name or column name in a form ready |
649 | // for use in SQL statements. For example, if the datasource allows spaces | |
650 | // in the table name or column name, the returned string will have the | |
651 | // correct enclosing marks around the name to allow it to be properly | |
652 | // included in a SQL statement | |
5bdad317 GT |
653 | const wxString SQLTableName(const wxChar *tableName); |
654 | const wxString SQLColumnName(const wxChar *colName); | |
243d4b36 | 655 | |
b742792c GT |
656 | void LogError(const wxString &errMsg, const wxString &SQLState = wxEmptyString) |
657 | { logError(errMsg, SQLState); } | |
f6bcfd97 | 658 | void SetDebugErrorMessages(bool state) { silent = !state; } |
b742792c | 659 | bool SetSqlLogging(wxDbSqlLogState state, const wxString &filename = SQL_LOG_FILENAME, |
a144affe | 660 | bool append = FALSE); |
4fdae997 | 661 | bool WriteSqlLog(const wxString &logMsg); |
b742792c | 662 | |
fdc03678 | 663 | wxDBMS Dbms(void); |
4fdae997 GT |
664 | bool ModifyColumn(const wxString &tableName, const wxString &columnName, |
665 | int dataType, ULONG columnLength=0, | |
da99271d | 666 | const wxString &optionalParam=wxEmptyString); |
4fdae997 | 667 | |
f6bcfd97 BP |
668 | bool FwdOnlyCursors(void) {return fwdOnlyCursors;} |
669 | ||
670 | // These two functions are provided strictly for use by wxDbTable. | |
671 | // DO NOT USE THESE FUNCTIONS, OR MEMORY LEAKS MAY OCCUR | |
672 | void incrementTableCount() { nTables++; return; } | |
673 | void decrementTableCount() { nTables--; return; } | |
674 | ||
675 | }; // wxDb | |
108106cf | 676 | |
fdc03678 | 677 | |
108106cf JS |
678 | // This structure forms a node in a linked list. The linked list of "DbList" objects |
679 | // keeps track of allocated database connections. This allows the application to | |
680 | // open more than one database connection through ODBC for multiple transaction support | |
681 | // or for multiple database support. | |
fdc03678 | 682 | struct wxDbList |
108106cf | 683 | { |
4fdae997 GT |
684 | wxDbList *PtrPrev; // Pointer to previous item in the list |
685 | wxString Dsn; // Data Source Name | |
686 | wxString Uid; // User ID | |
687 | wxString AuthStr; // Authorization string (password) | |
688 | wxDb *PtrDb; // Pointer to the wxDb object | |
689 | bool Free; // Is item free or in use? | |
690 | wxDbList *PtrNext; // Pointer to next item in the list | |
108106cf JS |
691 | }; |
692 | ||
5cf34cf0 | 693 | |
154f22b3 | 694 | #ifdef __WXDEBUG__ |
e115e771 | 695 | #include "wx/object.h" |
fdc03678 | 696 | class wxTablesInUse : public wxObject |
a2115c88 | 697 | { |
95ca6a20 | 698 | public: |
4fdae997 | 699 | const wxChar *tableName; |
95ca6a20 | 700 | ULONG tableID; |
f6bcfd97 | 701 | class wxDb *pDb; |
fdc03678 | 702 | }; // wxTablesInUse |
a2115c88 GT |
703 | #endif |
704 | ||
fdc03678 | 705 | |
108106cf JS |
706 | // The following routines allow a user to get new database connections, free them |
707 | // for other code segments to use, or close all of them when the application has | |
708 | // completed. | |
bb41dcbe VS |
709 | wxDb WXDLLIMPEXP_ODBC *wxDbGetConnection(wxDbConnectInf *pDbConfig, bool FwdOnlyCursors=(bool)wxODBC_FWD_ONLY_CURSORS); |
710 | bool WXDLLIMPEXP_ODBC wxDbFreeConnection(wxDb *pDb); | |
711 | void WXDLLIMPEXP_ODBC wxDbCloseConnections(void); | |
712 | int WXDLLIMPEXP_ODBC wxDbConnectionsInUse(void); | |
95ca6a20 | 713 | |
108106cf | 714 | |
20987580 GT |
715 | // Writes a message to the wxLog window (stdout usually) when an internal error |
716 | // situation occurs. This function only works in DEBUG builds | |
f157ad08 | 717 | const wxChar WXDLLIMPEXP_ODBC * |
886dd7d2 VZ |
718 | wxDbLogExtendedErrorMsg(const wxChar *userText, |
719 | wxDb *pDb, | |
720 | const wxChar *ErrFile, | |
721 | int ErrLine); | |
5bdad317 | 722 | |
20987580 | 723 | |
f6bcfd97 | 724 | // This function sets the sql log state for all open wxDb objects |
bb41dcbe | 725 | bool WXDLLIMPEXP_ODBC |
886dd7d2 | 726 | wxDbSqlLog(wxDbSqlLogState state, const wxString &filename = SQL_LOG_FILENAME); |
fdc03678 | 727 | |
95ca6a20 | 728 | |
fdc03678 GT |
729 | #if 0 |
730 | // MSW/VC6 ONLY!!! Experimental | |
da99271d | 731 | int WXDLLEXPORT wxDbCreateDataSource(const wxString &driverName, const wxString &dsn, const wxString &description=wxEmptyString, |
a144affe | 732 | bool sysDSN=FALSE, const wxString &defDir=wxEmptyString, wxWindow *parent=NULL); |
fdc03678 | 733 | #endif |
a2115c88 | 734 | |
108106cf JS |
735 | // This routine allows you to query a driver manager |
736 | // for a list of available datasources. Call this routine | |
737 | // the first time using SQL_FETCH_FIRST. Continue to call it | |
738 | // using SQL_FETCH_NEXT until you've exhausted the list. | |
bb41dcbe | 739 | bool WXDLLIMPEXP_ODBC |
886dd7d2 VZ |
740 | wxDbGetDataSource(HENV henv, wxChar *Dsn, SWORD DsnMax, wxChar *DsDesc, |
741 | SWORD DsDescMax, UWORD direction = SQL_FETCH_NEXT); | |
fdc03678 GT |
742 | |
743 | ||
744 | // Change this to 0 to remove use of all deprecated functions | |
f6bcfd97 | 745 | #if wxODBC_BACKWARD_COMPATABILITY |
fdc03678 GT |
746 | //################################################################################# |
747 | //############### DEPRECATED functions for backward compatability ################# | |
748 | //################################################################################# | |
749 | ||
750 | // Backward compability structures/classes. This will eventually go away | |
f6bcfd97 BP |
751 | const int DB_PATH_MAX = wxDB_PATH_MAX; |
752 | ||
753 | typedef wxDb wxDB; | |
754 | typedef wxDbTableInf wxTableInf; | |
755 | typedef wxDbColInf wxColInf; | |
756 | typedef wxDbColInf CcolInf; | |
757 | typedef wxDbColFor wxColFor; | |
758 | typedef wxDbSqlTypeInfo SqlTypeInfo; | |
759 | typedef wxDbSqlTypeInfo wxSqlTypeInfo; | |
760 | typedef enum wxDbSqlLogState sqlLog; | |
761 | typedef enum wxDbSqlLogState wxSqlLogState; | |
762 | typedef enum wxDBMS dbms; | |
763 | typedef enum wxDBMS DBMS; | |
764 | typedef wxODBC_ERRORS ODBC_ERRORS; | |
765 | typedef wxDbConnectInf DbStuff; | |
766 | typedef wxDbList DbList; | |
27508856 | 767 | #ifdef __WXDEBUG__ |
f6bcfd97 | 768 | typedef wxTablesInUse CstructTablesInUse; |
27508856 | 769 | #endif |
fdc03678 GT |
770 | |
771 | // Deprecated function names that are replaced by the function names listed above | |
bb41dcbe | 772 | wxDB WXDLLIMPEXP_ODBC |
886dd7d2 | 773 | *GetDbConnection(DbStuff *pDbStuff, bool FwdOnlyCursors=(bool)wxODBC_FWD_ONLY_CURSORS); |
bb41dcbe VS |
774 | bool WXDLLIMPEXP_ODBC FreeDbConnection(wxDB *pDb); |
775 | void WXDLLIMPEXP_ODBC CloseDbConnections(void); | |
776 | int WXDLLIMPEXP_ODBC NumberDbConnectionsInUse(void); | |
fdc03678 | 777 | |
2b5f62a0 | 778 | bool SqlLog(sqlLog state, const wxChar *filename = SQL_LOG_FILENAME); |
fdc03678 | 779 | |
bb41dcbe | 780 | bool WXDLLIMPEXP_ODBC |
886dd7d2 VZ |
781 | GetDataSource(HENV henv, char *Dsn, SWORD DsnMax, char *DsDesc, SWORD DsDescMax, |
782 | UWORD direction = SQL_FETCH_NEXT); | |
783 | ||
fdc03678 | 784 | #endif // Deprecated structures/classes/functions |
108106cf | 785 | |
2b5f62a0 VZ |
786 | #endif // _WX_DB_H_ |
787 |