[wxWidgets.git] / src / iodbc / isql.h

/*
 *  isql.h
 *
 *  $Id$
 *
 *  iODBC defines
 *
 *  The iODBC driver manager.
 *
 *  Copyright (C) 1995 by Ke Jin <kejin@empress.com>
 *
 *  This library is free software; you can redistribute it and/or
 *  modify it under the terms of the GNU Library General Public
 *  License as published by the Free Software Foundation; either
 *  version 2 of the License, or (at your option) any later version.
 *
 *  This library is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 *  Library General Public License for more details.
 *
 *  You should have received a copy of the GNU Library General Public
 *  License along with this library; if not, write to the Free
 *  Software Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
 */
#ifndef _ISQL_H
#define _ISQL_H

#ifndef WIN16
#ifdef WIN32
#define SQL_API				__stdcall
#else
#define FAR
#define EXPORT
#define CALLBACK
#define SQL_API				EXPORT CALLBACK
#ifndef __EMX__
typedef void *HWND;
#endif
#endif
#endif

typedef void *SQLHWND;

typedef unsigned char UCHAR;
typedef long int SDWORD;
typedef short int SWORD;
typedef unsigned long int UDWORD;
typedef unsigned short int UWORD;
typedef long SQLINTEGER;
typedef UDWORD SQLUINTEGER;

typedef void FAR *PTR;
typedef void FAR *HENV;
typedef void FAR *HDBC;
typedef void FAR *HSTMT;

typedef signed short RETCODE;
#define SQLRETURN	RETCODE


#define ODBCVER				0x0250

#define SQL_MAX_MESSAGE_LENGTH		512
#define SQL_MAX_DSN_LENGTH		32

/*
 *  Function return codes
 */
#define SQL_INVALID_HANDLE		(-2)
#define SQL_ERROR			(-1)
#define SQL_SUCCESS 			0
#define SQL_SUCCESS_WITH_INFO		1
#define SQL_NO_DATA_FOUND		100

/*
 *  Standard SQL datatypes, using ANSI type numbering
 */
#define SQL_CHAR			1
#define SQL_NUMERIC 			2
#define SQL_DECIMAL 			3
#define SQL_INTEGER 			4
#define SQL_SMALLINT			5
#define SQL_FLOAT			6
#define SQL_REAL			7
#define SQL_DOUBLE			8
#define SQL_VARCHAR 			12

#define SQL_TYPE_MIN			SQL_CHAR
#define SQL_TYPE_NULL			0
#define SQL_TYPE_MAX			SQL_VARCHAR

/*
 *  C datatype to SQL datatype mapping
 */
#define SQL_C_CHAR			SQL_CHAR
#define SQL_C_LONG			SQL_INTEGER
#define SQL_C_SHORT			SQL_SMALLINT
#define SQL_C_FLOAT			SQL_REAL
#define SQL_C_DOUBLE			SQL_DOUBLE
#define SQL_C_DEFAULT 			99

/*
 *  NULL status constants.
 */
#define SQL_NO_NULLS			0
#define SQL_NULLABLE			1
#define SQL_NULLABLE_UNKNOWN		2

/*
 *  Special length values
 */
#define SQL_NULL_DATA			(-1)
#define SQL_DATA_AT_EXEC		(-2)
#define SQL_NTS 			(-3)

/*
 *  SQLFreeStmt
 */
#define SQL_CLOSE			0
#define SQL_DROP			1
#define SQL_UNBIND			2
#define SQL_RESET_PARAMS		3

/*
 *  SQLTransact
 */
#define SQL_COMMIT			0
#define SQL_ROLLBACK			1

/*
 *  SQLColAttributes
 */
#define SQL_COLUMN_COUNT		0
#define SQL_COLUMN_NAME			1
#define SQL_COLUMN_TYPE			2
#define SQL_COLUMN_LENGTH		3
#define SQL_COLUMN_PRECISION		4
#define SQL_COLUMN_SCALE		5
#define SQL_COLUMN_DISPLAY_SIZE		6
#define SQL_COLUMN_NULLABLE		7
#define SQL_COLUMN_UNSIGNED		8
#define SQL_COLUMN_MONEY		9
#define SQL_COLUMN_UPDATABLE		10
#define SQL_COLUMN_AUTO_INCREMENT	11
#define SQL_COLUMN_CASE_SENSITIVE	12
#define SQL_COLUMN_SEARCHABLE		13
#define SQL_COLUMN_TYPE_NAME		14
#define SQL_COLUMN_TABLE_NAME		15
#define SQL_COLUMN_OWNER_NAME		16
#define SQL_COLUMN_QUALIFIER_NAME	17
#define SQL_COLUMN_LABEL		18

#define SQL_COLATT_OPT_MAX		SQL_COLUMN_LABEL
#define	SQL_COLATT_OPT_MIN		SQL_COLUMN_COUNT
#define SQL_COLUMN_DRIVER_START		1000

/*
 *  SQLColAttributes : SQL_COLUMN_UPDATABLE
 */
#define SQL_ATTR_READONLY		0
#define SQL_ATTR_WRITE			1
#define SQL_ATTR_READWRITE_UNKNOWN	2

/*
 *  SQLColAttributes : SQL_COLUMN_SEARCHABLE
 */
#define SQL_UNSEARCHABLE		0
#define SQL_LIKE_ONLY			1
#define SQL_ALL_EXCEPT_LIKE 		2
#define SQL_SEARCHABLE			3

/*
 *  NULL Handles
 */
#define SQL_NULL_HENV			0
#define SQL_NULL_HDBC			0
#define SQL_NULL_HSTMT			0


/*
 *  Function Prototypes
 */
#ifdef __cplusplus
extern "C"
{
#endif

  RETCODE SQL_API SQLAllocConnect (HENV henv, HDBC FAR * phdbc);
  RETCODE SQL_API SQLAllocEnv (HENV FAR * phenv);
  RETCODE SQL_API SQLAllocStmt (HDBC hdbc, HSTMT FAR * phstmt);
  RETCODE SQL_API SQLBindCol (HSTMT hstmt, UWORD icol, SWORD fCType,
      PTR rgbValue, SDWORD cbValueMax, SDWORD FAR * pcbValue);
  RETCODE SQL_API SQLCancel (HSTMT hstmt);
  RETCODE SQL_API SQLColAttributes (HSTMT hstmt, UWORD icol, UWORD fDescType,
      PTR rgbDesc, SWORD cbDescMax, SWORD FAR * pcbDesc, SDWORD FAR * pfDesc);
  RETCODE SQL_API SQLConnect (HDBC hdbc, UCHAR FAR * szDSN, SWORD cbDSN,
      UCHAR FAR * szUID, SWORD cbUID, UCHAR FAR * szAuthStr, SWORD cbAuthStr);
  RETCODE SQL_API SQLDescribeCol (HSTMT hstmt, UWORD icol,
      UCHAR FAR * szColName, SWORD cbColNameMax, SWORD FAR * pcbColName,
      SWORD FAR * pfSqlType, UDWORD FAR * pcbColDef, SWORD FAR * pibScale,
      SWORD FAR * pfNullable);
  RETCODE SQL_API SQLDisconnect (HDBC hdbc);
  RETCODE SQL_API SQLError (HENV henv, HDBC hdbc, HSTMT hstmt,
      UCHAR FAR * szSqlState, SDWORD FAR * pfNativeError, UCHAR FAR * szErrorMsg,
      SWORD cbErrorMsgMax, SWORD FAR * pcbErrorMsg);
  RETCODE SQL_API SQLExecDirect (HSTMT hstmt, UCHAR FAR * szSqlStr,
      SDWORD cbSqlStr);
  RETCODE SQL_API SQLExecute (HSTMT hstmt);
  RETCODE SQL_API SQLFetch (HSTMT hstmt);
  RETCODE SQL_API SQLFreeConnect (HDBC hdbc);
  RETCODE SQL_API SQLFreeEnv (HENV henv);
  RETCODE SQL_API SQLFreeStmt (HSTMT hstmt, UWORD fOption);
  RETCODE SQL_API SQLGetCursorName (HSTMT hstmt, UCHAR FAR * szCursor,
      SWORD cbCursorMax, SWORD FAR * pcbCursor);
  RETCODE SQL_API SQLNumResultCols (HSTMT hstmt, SWORD FAR * pccol);
  RETCODE SQL_API SQLPrepare (HSTMT hstmt, UCHAR FAR * szSqlStr,
      SDWORD cbSqlStr);
  RETCODE SQL_API SQLRowCount (HSTMT hstmt, SDWORD FAR * pcrow);
  RETCODE SQL_API SQLSetCursorName (HSTMT hstmt, UCHAR FAR * szCursor,
      SWORD cbCursor);
  RETCODE SQL_API SQLTransact (HENV henv, HDBC hdbc, UWORD fType);

/*
 *  Deprecated ODBC 1.0 function - Use SQLBindParameter
 */
  RETCODE SQL_API SQLSetParam (HSTMT hstmt, UWORD ipar, SWORD fCType,
      SWORD fSqlType, UDWORD cbColDef, SWORD ibScale, PTR rgbValue,
      SDWORD FAR * pcbValue);

#ifdef __cplusplus
}
#endif

#endif
Commit	Line	Data
cd5bf2a6 RR	1	/*
	2	* isql.h
	3	*
	4	* $Id$
	5	*
	6	* iODBC defines
	7	*
	8	* The iODBC driver manager.
c497d0b2 JS	9	*
c497d0b2 JS	10	* Copyright (C) 1995 by Ke Jin <kejin@empress.com>
cd5bf2a6 RR	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
0bd55cfa	29	#ifndef WIN16
cd5bf2a6 RR	30	#ifdef WIN32
	31	#define SQL_API __stdcall
	32	#else
	33	#define FAR
	34	#define EXPORT
	35	#define CALLBACK
	36	#define SQL_API EXPORT CALLBACK
50eb93aa	37	#ifndef __EMX__
cd5bf2a6	38	typedef void *HWND;
7e616b10	39	#endif
0bd55cfa	40	#endif
50eb93aa	41	#endif
7e616b10	42
5d3cc785 GT	43	typedef void *SQLHWND;
5d3cc785 GT	44
cd5bf2a6 RR	45	typedef unsigned char UCHAR;
	46	typedef long int SDWORD;
	47	typedef short int SWORD;
	48	typedef unsigned long int UDWORD;
	49	typedef unsigned short int UWORD;
c497d0b2	50	typedef long SQLINTEGER;
1d421f0c	51	typedef UDWORD SQLUINTEGER;
cd5bf2a6 RR	52
	53	typedef void FAR *PTR;
	54	typedef void FAR *HENV;
	55	typedef void FAR *HDBC;
	56	typedef void FAR *HSTMT;
	57
	58	typedef signed short RETCODE;
	59	#define SQLRETURN RETCODE
	60
	61
	62	#define ODBCVER 0x0250
	63
	64	#define SQL_MAX_MESSAGE_LENGTH 512
	65	#define SQL_MAX_DSN_LENGTH 32
	66
	67	/*
	68	* Function return codes
	69	*/
	70	#define SQL_INVALID_HANDLE (-2)
	71	#define SQL_ERROR (-1)
	72	#define SQL_SUCCESS 0
	73	#define SQL_SUCCESS_WITH_INFO 1
	74	#define SQL_NO_DATA_FOUND 100
	75
	76	/*
	77	* Standard SQL datatypes, using ANSI type numbering
	78	*/
	79	#define SQL_CHAR 1
	80	#define SQL_NUMERIC 2
	81	#define SQL_DECIMAL 3
	82	#define SQL_INTEGER 4
	83	#define SQL_SMALLINT 5
	84	#define SQL_FLOAT 6
	85	#define SQL_REAL 7
	86	#define SQL_DOUBLE 8
	87	#define SQL_VARCHAR 12
	88
	89	#define SQL_TYPE_MIN SQL_CHAR
	90	#define SQL_TYPE_NULL 0
	91	#define SQL_TYPE_MAX SQL_VARCHAR
	92
	93	/*
	94	* C datatype to SQL datatype mapping
	95	*/
	96	#define SQL_C_CHAR SQL_CHAR
	97	#define SQL_C_LONG SQL_INTEGER
	98	#define SQL_C_SHORT SQL_SMALLINT
	99	#define SQL_C_FLOAT SQL_REAL
	100	#define SQL_C_DOUBLE SQL_DOUBLE
	101	#define SQL_C_DEFAULT 99
	102
	103	/*
	104	* NULL status constants.
	105	*/
	106	#define SQL_NO_NULLS 0
	107	#define SQL_NULLABLE 1
	108	#define SQL_NULLABLE_UNKNOWN 2
	109
	110	/*
	111	* Special length values
	112	*/
	113	#define SQL_NULL_DATA (-1)
	114	#define SQL_DATA_AT_EXEC (-2)
	115	#define SQL_NTS (-3)
116
117	/*
118	* SQLFreeStmt
119	*/
120	#define SQL_CLOSE 0
121	#define SQL_DROP 1
122	#define SQL_UNBIND 2
123	#define SQL_RESET_PARAMS 3
124
125	/*
126	* SQLTransact
127	*/
128	#define SQL_COMMIT 0
129	#define SQL_ROLLBACK 1
130
131	/*
132	* SQLColAttributes
133	*/
134	#define SQL_COLUMN_COUNT 0
135	#define SQL_COLUMN_NAME 1
136	#define SQL_COLUMN_TYPE 2
137	#define SQL_COLUMN_LENGTH 3
138	#define SQL_COLUMN_PRECISION 4
139	#define SQL_COLUMN_SCALE 5
140	#define SQL_COLUMN_DISPLAY_SIZE 6
141	#define SQL_COLUMN_NULLABLE 7
142	#define SQL_COLUMN_UNSIGNED 8
143	#define SQL_COLUMN_MONEY 9
144	#define SQL_COLUMN_UPDATABLE 10
145	#define SQL_COLUMN_AUTO_INCREMENT 11
146	#define SQL_COLUMN_CASE_SENSITIVE 12
147	#define SQL_COLUMN_SEARCHABLE 13
148	#define SQL_COLUMN_TYPE_NAME 14
149	#define SQL_COLUMN_TABLE_NAME 15
150	#define SQL_COLUMN_OWNER_NAME 16
151	#define SQL_COLUMN_QUALIFIER_NAME 17
152	#define SQL_COLUMN_LABEL 18
153
154	#define SQL_COLATT_OPT_MAX SQL_COLUMN_LABEL
155	#define SQL_COLATT_OPT_MIN SQL_COLUMN_COUNT
156	#define SQL_COLUMN_DRIVER_START 1000
157
158	/*
159	* SQLColAttributes : SQL_COLUMN_UPDATABLE
160	*/
161	#define SQL_ATTR_READONLY 0
162	#define SQL_ATTR_WRITE 1
163	#define SQL_ATTR_READWRITE_UNKNOWN 2
164
165	/*
166	* SQLColAttributes : SQL_COLUMN_SEARCHABLE
167	*/
168	#define SQL_UNSEARCHABLE 0
169	#define SQL_LIKE_ONLY 1
170	#define SQL_ALL_EXCEPT_LIKE 2
171	#define SQL_SEARCHABLE 3
172
173	/*
174	* NULL Handles
175	*/
176	#define SQL_NULL_HENV 0
177	#define SQL_NULL_HDBC 0
178	#define SQL_NULL_HSTMT 0
179
180
181	/*
182	* Function Prototypes
183	*/
184	#ifdef __cplusplus
185	extern "C"
7e616b10	186	{
7e616b10 RR	187	#endif
7e616b10 RR	188
cd5bf2a6 RR	189	RETCODE SQL_API SQLAllocConnect (HENV henv, HDBC FAR * phdbc);
	190	RETCODE SQL_API SQLAllocEnv (HENV FAR * phenv);
	191	RETCODE SQL_API SQLAllocStmt (HDBC hdbc, HSTMT FAR * phstmt);
	192	RETCODE SQL_API SQLBindCol (HSTMT hstmt, UWORD icol, SWORD fCType,
	193	PTR rgbValue, SDWORD cbValueMax, SDWORD FAR * pcbValue);
	194	RETCODE SQL_API SQLCancel (HSTMT hstmt);
	195	RETCODE SQL_API SQLColAttributes (HSTMT hstmt, UWORD icol, UWORD fDescType,
	196	PTR rgbDesc, SWORD cbDescMax, SWORD FAR * pcbDesc, SDWORD FAR * pfDesc);
	197	RETCODE SQL_API SQLConnect (HDBC hdbc, UCHAR FAR * szDSN, SWORD cbDSN,
	198	UCHAR FAR * szUID, SWORD cbUID, UCHAR FAR * szAuthStr, SWORD cbAuthStr);
	199	RETCODE SQL_API SQLDescribeCol (HSTMT hstmt, UWORD icol,
	200	UCHAR FAR * szColName, SWORD cbColNameMax, SWORD FAR * pcbColName,
	201	SWORD FAR * pfSqlType, UDWORD FAR * pcbColDef, SWORD FAR * pibScale,
	202	SWORD FAR * pfNullable);
	203	RETCODE SQL_API SQLDisconnect (HDBC hdbc);
	204	RETCODE SQL_API SQLError (HENV henv, HDBC hdbc, HSTMT hstmt,
	205	UCHAR FAR * szSqlState, SDWORD FAR * pfNativeError, UCHAR FAR * szErrorMsg,
	206	SWORD cbErrorMsgMax, SWORD FAR * pcbErrorMsg);
	207	RETCODE SQL_API SQLExecDirect (HSTMT hstmt, UCHAR FAR * szSqlStr,
	208	SDWORD cbSqlStr);
	209	RETCODE SQL_API SQLExecute (HSTMT hstmt);
	210	RETCODE SQL_API SQLFetch (HSTMT hstmt);
	211	RETCODE SQL_API SQLFreeConnect (HDBC hdbc);
	212	RETCODE SQL_API SQLFreeEnv (HENV henv);
	213	RETCODE SQL_API SQLFreeStmt (HSTMT hstmt, UWORD fOption);
	214	RETCODE SQL_API SQLGetCursorName (HSTMT hstmt, UCHAR FAR * szCursor,
	215	SWORD cbCursorMax, SWORD FAR * pcbCursor);
	216	RETCODE SQL_API SQLNumResultCols (HSTMT hstmt, SWORD FAR * pccol);
	217	RETCODE SQL_API SQLPrepare (HSTMT hstmt, UCHAR FAR * szSqlStr,
	218	SDWORD cbSqlStr);
	219	RETCODE SQL_API SQLRowCount (HSTMT hstmt, SDWORD FAR * pcrow);
	220	RETCODE SQL_API SQLSetCursorName (HSTMT hstmt, UCHAR FAR * szCursor,
	221	SWORD cbCursor);
	222	RETCODE SQL_API SQLTransact (HENV henv, HDBC hdbc, UWORD fType);
	223
	224	/*
34621cc5	225	* Deprecated ODBC 1.0 function - Use SQLBindParameter
cd5bf2a6 RR	226	*/
	227	RETCODE SQL_API SQLSetParam (HSTMT hstmt, UWORD ipar, SWORD fCType,
	228	SWORD fSqlType, UDWORD cbColDef, SWORD ibScale, PTR rgbValue,
	229	SDWORD FAR * pcbValue);
	230
	231	#ifdef __cplusplus
	232	}
7e616b10	233	#endif
1a6944fd	234
cd5bf2a6	235	#endif