[Gambas-user] ODBC and NUMERIC problem

[Andrea Bortolan]

Hi,
can you please provide me also the SQL trace taken running the query in isql and  a second trace running the same query from the  Gambas  program? 
You can enable it using the ODBCConfig tool, in the Advance tab flag the trace.
What DB are you connecting to  ? 

Thanks, Andrea.

----- Messaggio originale -----
Da: esucno esucno <esucno at ...626...>
A: gambas-user at lists.sourceforge.net
Inviato: Mercoledì 5 dicembre 2007, 0:29:24
Oggetto: [Gambas-user] ODBC and NUMERIC problem

Hi everybody,

i have a problem with gambas2 and odbc:

when a use isql (from unixodbc), I get this result:

*select  product, price from products
- banana ~ 5.00
- orange ~ 7.00
- apple ~ 5.00

but, when a use gambas (from the example), I get this result:

*select  product, price from products
- banana ~ 234235
- orange ~ 234238
- apple ~ 234241

i'm doing something wrong or its a bug?

___________
Gambas 1.9.91
os: Opensuse 10.3
odbc: unixODBC 2.2.12
driver odbc: libOdbcFb32.so V2.0 (Beta 02.00.00.0144)
format of "PRICE": NUMERIC(8,2)
*
*
Thanks in advance

-- 
Edward Sucno Quiroz
-------------------------------------------------------------------------
SF.Net email is sponsored by: The Future of Linux Business White Paper
from Novell.  From the desktop to the data center, Linux is going
mainstream.  Let it simplify your IT future.
http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
_______________________________________________
Gambas-user mailing list
Gambas-user at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user






      ___________________________________ 
L'email della prossima generazione? Puoi averla con la nuova Yahoo! Mail: http://it.docs.yahoo.com/nowyoucan.html