Hi everybody,
 my problem is accessing MS-Access tables from Lisp, through Allegro ODBC,
and, in particular, I have problems with float numbers.
My tables looks like: (only Power is float)

  Number       Status    Power       Time
    1            1         0        2/8/98
    2            0        4.3       2/8/98

if I execute

  > (execute-sql "select Number, Status, Power,Time
                from FM_Pump_Status_DDG51")

I get

  ((1 1 0.0 "1998-02-08 00:00:00") (2 0 4.30000019073486 "1998-02-08 
00:00:00"))                                     ^^^^^^^^

So I'd like to know what is the junk at the end of 4.3; I'd like to 
mention that I do NOT have this problem when I write a float into the DB 
thruogh and Update SQL-statement.

 Moreover if I execute 

  > (execute-sql "select *
                from FM_Pump_Status_DDG51")

I get

  ((0) (0))

when instead I should get the same result of the previous query 
(if I don't remember wrong from my DB class).
Does anyone have an idea?
Thanks.
Luca          
----------------------------------------------------------------------------
Luca Faggioli                                  Perfection is achieved only
Knowledge-Based Systems Group                 on the point of the collapse
Beckman Institute                                          -C.N. Parkinson
Urbana, IL   USA                        
http://www.students.uiuc.edu/~faggioli