]> git.saurik.com Git - wxWidgets.git/blob - include/wx/isql.h
Added simplistic makefile/project files for wxWinCE.
[wxWidgets.git] / include / wx / isql.h
1 /*
2 * isql.h
3 *
4 * $Id$
5 *
6 * iODBC defines
7 *
8 * The iODBC driver manager.
9 *
10 * Copyright (C) 1995 by Ke Jin <kejin@empress.com>
11 *
12 * This library is free software; you can redistribute it and/or
13 * modify it under the terms of the GNU Library General Public
14 * License as published by the Free Software Foundation; either
15 * version 2 of the License, or (at your option) any later version.
16 *
17 * This library is distributed in the hope that it will be useful,
18 * but WITHOUT ANY WARRANTY; without even the implied warranty of
19 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
20 * Library General Public License for more details.
21 *
22 * You should have received a copy of the GNU Library General Public
23 * License along with this library; if not, write to the Free
24 * Software Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
25 */
26 #ifndef _ISQL_H
27 #define _ISQL_H
28
29 #if defined(__WIN16__)
30
31 #define SQL_API EXPORT CALLBACK
32 #ifndef EXPORT
33 #define EXPORT _export
34 #endif
35
36 #elif defined(WIN32)
37 #define SQL_API __stdcall
38
39 #ifndef FAR
40 #define FAR
41 #endif
42
43 #elif defined(__OS2__)
44 #define SQL_API _Optlink
45
46 #ifndef FAR
47 #define FAR
48 #define EXPORT
49 #define CALLBACK
50 #endif
51
52 #else
53 #define FAR
54 #define EXPORT
55 #define CALLBACK
56 #define SQL_API EXPORT CALLBACK
57
58 #ifndef __EMX__
59 typedef void *HWND;
60 #endif
61 #endif
62
63 typedef void *SQLHWND;
64
65 typedef unsigned char UCHAR;
66 typedef long int SDWORD;
67 typedef short int SWORD;
68 typedef unsigned long int UDWORD;
69 typedef unsigned short int UWORD;
70
71 typedef void FAR *PTR;
72 typedef void FAR *HENV;
73 typedef void FAR *HDBC;
74 typedef void FAR *HSTMT;
75
76 typedef signed short RETCODE;
77 #define SQLRETURN RETCODE
78
79
80 #define ODBCVER 0x0250
81
82 #define SQL_MAX_MESSAGE_LENGTH 512
83 #define SQL_MAX_DSN_LENGTH 32
84
85 /*
86 * Function return codes
87 */
88 #define SQL_INVALID_HANDLE (-2)
89 #define SQL_ERROR (-1)
90 #define SQL_SUCCESS 0
91 #define SQL_SUCCESS_WITH_INFO 1
92 #define SQL_NO_DATA_FOUND 100
93
94 /*
95 * Standard SQL datatypes, using ANSI type numbering
96 */
97 #define SQL_CHAR 1
98 #define SQL_NUMERIC 2
99 #define SQL_DECIMAL 3
100 #define SQL_INTEGER 4
101 #define SQL_SMALLINT 5
102 #define SQL_FLOAT 6
103 #define SQL_REAL 7
104 #define SQL_DOUBLE 8
105 #define SQL_VARCHAR 12
106
107 #define SQL_TYPE_MIN SQL_CHAR
108 #define SQL_TYPE_NULL 0
109 #define SQL_TYPE_MAX SQL_VARCHAR
110
111 /*
112 * C datatype to SQL datatype mapping
113 */
114 #define SQL_C_CHAR SQL_CHAR
115 #define SQL_C_LONG SQL_INTEGER
116 #define SQL_C_SHORT SQL_SMALLINT
117 #define SQL_C_FLOAT SQL_REAL
118 #define SQL_C_DOUBLE SQL_DOUBLE
119 #define SQL_C_DEFAULT 99
120
121 /*
122 * NULL status constants.
123 */
124 #define SQL_NO_NULLS 0
125 #define SQL_NULLABLE 1
126 #define SQL_NULLABLE_UNKNOWN 2
127
128 /*
129 * Special length values
130 */
131 #define SQL_NULL_DATA (-1)
132 #define SQL_DATA_AT_EXEC (-2)
133 #define SQL_NTS (-3)
134
135 /*
136 * SQLFreeStmt
137 */
138 #define SQL_CLOSE 0
139 #define SQL_DROP 1
140 #define SQL_UNBIND 2
141 #define SQL_RESET_PARAMS 3
142
143 /*
144 * SQLTransact
145 */
146 #define SQL_COMMIT 0
147 #define SQL_ROLLBACK 1
148
149 /*
150 * SQLColAttributes
151 */
152 #define SQL_COLUMN_COUNT 0
153 #define SQL_COLUMN_NAME 1
154 #define SQL_COLUMN_TYPE 2
155 #define SQL_COLUMN_LENGTH 3
156 #define SQL_COLUMN_PRECISION 4
157 #define SQL_COLUMN_SCALE 5
158 #define SQL_COLUMN_DISPLAY_SIZE 6
159 #define SQL_COLUMN_NULLABLE 7
160 #define SQL_COLUMN_UNSIGNED 8
161 #define SQL_COLUMN_MONEY 9
162 #define SQL_COLUMN_UPDATABLE 10
163 #define SQL_COLUMN_AUTO_INCREMENT 11
164 #define SQL_COLUMN_CASE_SENSITIVE 12
165 #define SQL_COLUMN_SEARCHABLE 13
166 #define SQL_COLUMN_TYPE_NAME 14
167 #define SQL_COLUMN_TABLE_NAME 15
168 #define SQL_COLUMN_OWNER_NAME 16
169 #define SQL_COLUMN_QUALIFIER_NAME 17
170 #define SQL_COLUMN_LABEL 18
171
172 #define SQL_COLATT_OPT_MAX SQL_COLUMN_LABEL
173 #define SQL_COLATT_OPT_MIN SQL_COLUMN_COUNT
174 #define SQL_COLUMN_DRIVER_START 1000
175
176 /*
177 * SQLColAttributes : SQL_COLUMN_UPDATABLE
178 */
179 #define SQL_ATTR_READONLY 0
180 #define SQL_ATTR_WRITE 1
181 #define SQL_ATTR_READWRITE_UNKNOWN 2
182
183 /*
184 * SQLColAttributes : SQL_COLUMN_SEARCHABLE
185 */
186 #define SQL_UNSEARCHABLE 0
187 #define SQL_LIKE_ONLY 1
188 #define SQL_ALL_EXCEPT_LIKE 2
189 #define SQL_SEARCHABLE 3
190
191 /*
192 * NULL Handles
193 */
194 #define SQL_NULL_HENV 0
195 #define SQL_NULL_HDBC 0
196 #define SQL_NULL_HSTMT 0
197
198
199 /*
200 * Function Prototypes
201 */
202 #ifdef __cplusplus
203 extern "C"
204 {
205 #endif
206
207 RETCODE SQL_API SQLAllocConnect (HENV henv, HDBC FAR * phdbc);
208 RETCODE SQL_API SQLAllocEnv (HENV FAR * phenv);
209 RETCODE SQL_API SQLAllocStmt (HDBC hdbc, HSTMT FAR * phstmt);
210 RETCODE SQL_API SQLBindCol (HSTMT hstmt, UWORD icol, SWORD fCType,
211 PTR rgbValue, SDWORD cbValueMax, SDWORD FAR * pcbValue);
212 RETCODE SQL_API SQLCancel (HSTMT hstmt);
213 RETCODE SQL_API SQLColAttributes (HSTMT hstmt, UWORD icol, UWORD fDescType,
214 PTR rgbDesc, SWORD cbDescMax, SWORD FAR * pcbDesc, SDWORD FAR * pfDesc);
215 RETCODE SQL_API SQLConnect (HDBC hdbc, UCHAR FAR * szDSN, SWORD cbDSN,
216 UCHAR FAR * szUID, SWORD cbUID, UCHAR FAR * szAuthStr, SWORD cbAuthStr);
217 RETCODE SQL_API SQLDescribeCol (HSTMT hstmt, UWORD icol,
218 UCHAR FAR * szColName, SWORD cbColNameMax, SWORD FAR * pcbColName,
219 SWORD FAR * pfSqlType, UDWORD FAR * pcbColDef, SWORD FAR * pibScale,
220 SWORD FAR * pfNullable);
221 RETCODE SQL_API SQLDisconnect (HDBC hdbc);
222 RETCODE SQL_API SQLError (HENV henv, HDBC hdbc, HSTMT hstmt,
223 UCHAR FAR * szSqlState, SDWORD FAR * pfNativeError, UCHAR FAR * szErrorMsg,
224 SWORD cbErrorMsgMax, SWORD FAR * pcbErrorMsg);
225 RETCODE SQL_API SQLExecDirect (HSTMT hstmt, UCHAR FAR * szSqlStr,
226 SDWORD cbSqlStr);
227 RETCODE SQL_API SQLExecute (HSTMT hstmt);
228 RETCODE SQL_API SQLFetch (HSTMT hstmt);
229 RETCODE SQL_API SQLFreeConnect (HDBC hdbc);
230 RETCODE SQL_API SQLFreeEnv (HENV henv);
231 RETCODE SQL_API SQLFreeStmt (HSTMT hstmt, UWORD fOption);
232 RETCODE SQL_API SQLGetCursorName (HSTMT hstmt, UCHAR FAR * szCursor,
233 SWORD cbCursorMax, SWORD FAR * pcbCursor);
234 RETCODE SQL_API SQLNumResultCols (HSTMT hstmt, SWORD FAR * pccol);
235 RETCODE SQL_API SQLPrepare (HSTMT hstmt, UCHAR FAR * szSqlStr,
236 SDWORD cbSqlStr);
237 RETCODE SQL_API SQLRowCount (HSTMT hstmt, SDWORD FAR * pcrow);
238 RETCODE SQL_API SQLSetCursorName (HSTMT hstmt, UCHAR FAR * szCursor,
239 SWORD cbCursor);
240 RETCODE SQL_API SQLTransact (HENV henv, HDBC hdbc, UWORD fType);
241
242 /*
243 * Depreciated ODBC 1.0 function - Use SQLBindParameter
244 */
245 RETCODE SQL_API SQLSetParam (HSTMT hstmt, UWORD ipar, SWORD fCType,
246 SWORD fSqlType, UDWORD cbColDef, SWORD ibScale, PTR rgbValue,
247 SDWORD FAR * pcbValue);
248
249 #ifdef __cplusplus
250 }
251 #endif
252
253 #endif