r9519: add prepared statements for postgresql

[clsql.git] / db-odbc / odbc-constants.lisp

diff --git a/db-odbc/odbc-constants.lisp b/db-odbc/odbc-constants.lisp
index 91b09c81f97fc0d9d82748e0aed1e33109fcd010..c16e2a76869201da13e5b15add9ea95147fdc129 100644 (file)
--- a/db-odbc/odbc-constants.lisp
+++ b/db-odbc/odbc-constants.lisp
@@ -4,9 +4,9 @@
 ;;;;
 ;;;; Name:     odbc-constants.lisp
 ;;;; Purpose:  Constants for UFFI interface to ODBC
-;;;; Authors:  Paul Meurer and Kevin M. Rosenberg
+;;;; Authors:  Kevin M. Rosenberg and Paul Meurer
 ;;;;
-;;;; $Id: odbc-package.lisp 7061 2003-09-07 06:34:45Z kevin $
+;;;; $Id$
 ;;;;
 ;;;; This file, part of CLSQL, is Copyright (c) 2004 by Kevin M. Rosenberg
 ;;;; and Copyright (C) Paul Meurer 1999 - 2001. All rights reserved.
@@ -18,12 +18,16 @@
 
 (in-package #:odbc)
 
-(defconstant $ODBCVER  #x0210)
+;; on SuSE AMD64 9.0, unixODBC is compiled with with SQLLEN being 4 bytes long
+(defconstant $ODBC-LONG-TYPE :int)
+(defconstant $ODBC-ULONG-TYPE :unsigned-int)
+
+;; (defconstant $ODBCVER       #x0210)
 
 ;; generally useful constants
 (defconstant $SQL_SPEC_MAJOR 2)                ;; Major version of specification 
 (defconstant $SQL_SPEC_MINOR 10)       ;; Minor version of specification 
-(defconstant $SQL_SPEC_STRING  "02.10") ;; String constant for version   
+(defvar $SQL_SPEC_STRING       "02.10") ;; String constant for version   
 (defconstant $SQL_SQLSTATE_SIZE 5)             ;; size of SQLSTATE                       
 (defconstant $SQL_MAX_MESSAGE_LENGTH 512)      ;; message buffer size                    
 (defconstant $SQL_MAX_DSN_LENGTH 32)           ;; maximum data source name size  
@@ -671,11 +675,7 @@
 (defconstant $SQL_USE_BOOKMARKS                        12)
 (defconstant $SQL_GET_BOOKMARK                 13      /*      GetStmtOption Only)
 (defconstant $SQL_ROW_NUMBER                           14      /*      GetStmtOption Only)
-; #if (ODBCVER >= #x0200))
 (defconstant $SQL_STMT_OPT_MAX                 SQL_ROW_NUMBER
-;; #else)
-(defconstant $SQL_STMT_OPT_MAX                 SQL_BIND_TYPE
-;; #endif      ;; ODBCVER >= #x0200
 )
 (defconstant $SQL_STMT_OPT_MIN                 SQL_QUERY_TIMEOUT
 
@@ -802,7 +802,6 @@
 
 (defconstant $SQL_POSITION 0) ;; 1.0 FALSE
 (defconstant $SQL_REFRESH 1)  ;; 1.0 TRUE
-; #if (ODBCVER >= #x0200))
 (defconstant $SQL_UPDATE 2)
 (defconstant $SQL_DELETE 3)
 (defconstant $SQL_ADD 4)
@@ -948,3 +947,14 @@
 (defconstant $SQL_FETCH_RELATIVE 6)
 (defconstant $SQL_FETCH_BOOKMARK 8)
 
+;;; ODBC v3 constants, added by KMR
+
+(defconstant $SQL_ATTR_ODBC_VERSION 200)
+(defconstant $SQL_OV_ODBC2 2)
+(defconstant $SQL_OV_ODBC3 3)
+(defconstant $SQL_INDEX_UNIQUE 0)
+(defconstant $SQL_INDEX_ALL 1)
+(defconstant $SQL_QUICK 0)
+(defconstant $SQL_ENSURE 1)
+
+