From: Kevin M. Rosenberg <kevin@rosenberg.net>
Date: Thu, 15 Apr 2004 23:13:36 +0000 (+0000)
Subject: r9024: fix odbc on lww
X-Git-Tag: v3.8.6~621
X-Git-Url: http://git.kpe.io/?p=clsql.git;a=commitdiff_plain;h=d107be8f0cad113b96b6cfe443cc4d7c08126db4

r9024: fix odbc on lww
---

diff --git a/ChangeLog b/ChangeLog
index 95afac7..bd0530e 100644
--- a/ChangeLog
+++ b/ChangeLog
@@ -1,3 +1,6 @@
+15 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
+	* Version 2.7.2: Fix ODBC on Lispworks Windows
+
 15 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
 	* Version 2.7.1: Fix for new ODBC backend.
 	clsql-odbc now works on SBCL, CMUCL, OpenMCL
diff --git a/db-odbc/odbc-api.lisp b/db-odbc/odbc-api.lisp
index 1d82470..a15d628 100644
--- a/db-odbc/odbc-api.lisp
+++ b/db-odbc/odbc-api.lisp
@@ -31,6 +31,7 @@ May be locally bound to something else if a certain type is necessary.")
 as possible second argument) to the desired representation of date/time/timestamp.")
 
 (defvar +null-ptr+ (make-null-pointer :byte))
+(defparameter +null-handle-ptr+ (make-null-pointer :void))
 (defvar *info-output* nil
   "Stream to send SUCCESS_WITH_INFO messages.")
 
@@ -97,9 +98,9 @@ as possible second argument) to the desired representation of date/time/timestam
          (#.$SQL_SUCCESS_WITH_INFO
           (when ,print-info
             (multiple-value-bind (error-message sql-state)
-		(handle-error (or ,henv +null-ptr+)
-			      (or ,hdbc +null-ptr+)
-			      (or ,hstmt +null-ptr+))
+		(handle-error (or ,henv +null-handle-ptr+)
+			      (or ,hdbc +null-handle-ptr+)
+			      (or ,hstmt +null-handle-ptr+))
 	      (when *info-output*
 		(format *info-output* "[ODBC info ~A] ~A state: ~A"
 			,result-code error-message
@@ -115,9 +116,9 @@ as possible second argument) to the desired representation of date/time/timestam
 	   :odbc-message "Still executing"))
          (#.$SQL_ERROR
           (multiple-value-bind (error-message sql-state)
-	      (handle-error (or ,henv +null-ptr+)
-			    (or ,hdbc +null-ptr+)
-			    (or ,hstmt +null-ptr+))
+	      (handle-error (or ,henv +null-handle-ptr+)
+			    (or ,hdbc +null-handle-ptr+)
+			    (or ,hstmt +null-handle-ptr+))
             (error
 	     'clsql-base-sys:clsql-odbc-error
 	     :odbc-message error-message
@@ -838,7 +839,7 @@ as possible second argument) to the desired representation of date/time/timestam
                                       data-length)))
                     (error "wrong type. preliminary."))
                while (and (= res $SQL_SUCCESS_WITH_INFO)
-                          (equal (sql-state +null-ptr+ +null-ptr+ hstmt)
+                          (equal (sql-state +null-handle-ptr+ +null-handle-ptr+ hstmt)
                                  "01004"))
                do (setf res (%sql-get-data hstmt column-nr c-type data-ptr 
                                            +max-precision+ out-len-ptr)))
@@ -857,9 +858,9 @@ as possible second argument) to the desired representation of date/time/timestam
                     (error "wrong type. preliminary."))
                while 
                (and (= res $SQL_SUCCESS_WITH_INFO)
-                    #+ingore(eq (sql-state +null-ptr+ +null-ptr+ hstmt)
+                    #+ingore(eq (sql-state +null-handle-ptr+ +null-handle-ptr+ hstmt)
                                 $sql-data-truncated)
-                    (equal (sql-state +null-ptr+ +null-ptr+ hstmt)
+                    (equal (sql-state +null-handle-ptr+ +null-handle-ptr+ hstmt)
                            "01004"))
                do (setf res (%sql-get-data hstmt column-nr c-type data-ptr 
                                            +max-precision+ out-len-ptr)
diff --git a/db-odbc/odbc-loader.lisp b/db-odbc/odbc-loader.lisp
index ef14d47..63e39d8 100644
--- a/db-odbc/odbc-loader.lisp
+++ b/db-odbc/odbc-loader.lisp
@@ -26,6 +26,7 @@
       "/sw/lib/"
       "/usr/local/lib/"
       "/home/kevin/debian/src/clsql/db-odbc/"
+      "/windows/system32/"
       "/odbc/lib/opt/")
    :drive-letters '("C")))
   
diff --git a/tests/test-basic.lisp b/tests/test-basic.lisp
index e57ee28..b4cec79 100644
--- a/tests/test-basic.lisp
+++ b/tests/test-basic.lisp
@@ -84,7 +84,7 @@
     (clsql:execute-command 
      "DROP TABLE test_clsql" :database db))
   (clsql:execute-command 
-   "CREATE TABLE test_clsql (t_int integer, t_float double, t_bigint BIGINT, t_str CHAR(30))" 
+   "CREATE TABLE test_clsql (t_int integer, t_float double precision, t_bigint BIGINT, t_str CHAR(30))" 
    :database db)
   (dotimes (i 11)
     (let* ((test-int (- i 5))