X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=interfaces%2Faodbc%2Faodbc-sql.cl;h=e6244d18b3170f9447887b2b658b78157c5c8461;hb=421ef23a5a01534ac4c4d7594d182023ed31b376;hp=c1a74c9f90c80f4d52d2432660b9bb44b594d91a;hpb=8213ff48f5362c3d4792444c929f50bd128bd044;p=clsql.git diff --git a/interfaces/aodbc/aodbc-sql.cl b/interfaces/aodbc/aodbc-sql.cl index c1a74c9..e6244d1 100644 --- a/interfaces/aodbc/aodbc-sql.cl +++ b/interfaces/aodbc/aodbc-sql.cl @@ -7,7 +7,7 @@ ;;;; Programmer: Kevin M. Rosenberg ;;;; Date Started: Feb 2002 ;;;; -;;;; $Id: aodbc-sql.cl,v 1.1 2002/03/23 14:04:52 kevin Exp $ +;;;; $Id: aodbc-sql.cl,v 1.5 2002/03/25 06:07:06 kevin Exp $ ;;;; ;;;; This file, part of CLSQL, is Copyright (c) 2002 by Kevin M. Rosenberg ;;;; @@ -20,6 +20,11 @@ (in-package :clsql-aodbc) +(defmethod database-type-library-loaded ((database-type (eql :aodbc))) + "T if foreign library was able to be loaded successfully. " + (when (find-package :dbi) ;; finds Allegro's DBI (AODBC) package + t)) + (defmethod database-initialize-database-type ((database-type (eql :aodbc))) t) @@ -55,9 +60,10 @@ (setf (database-aodbc-conn database) nil) t) -(defmethod database-query (query-expression (database aodbc-database)) +(defmethod database-query (query-expression (database aodbc-database) field-types) (handler-case - (dbi:sql query-expression :db (database-aodbc-conn database)) + (dbi:sql query-expression :db (database-aodbc-conn database) + :types field-types) (error () (error 'clsql-sql-error :database database @@ -78,11 +84,11 @@ (defstruct aodbc-result-set (query nil) - (full-set nil)) + (field-types nil :type cons) + (full-set nil :type boolean)) -(defmethod database-query-result-set (query-expression - (database aodbc-database) - &optional full-set) +(defmethod database-query-result-set (query-expression (database aodbc-database) + &key full-set field-types) (handler-case (multiple-value-bind (query column-names) (dbi:sql query-expression @@ -90,9 +96,11 @@ :row-count nil :column-names t :query t + :types field-types ) (values - (make-aodbc-result-set :query query :full-set full-set) + (make-aodbc-result-set :query query :full-set full-set + :field-types field-types) (length column-names) nil ;; not able to return number of rows with aodbc ))