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