Subject | Re-Query: Currency Problem |
---|---|
Author | chemicalreaction |
Post date | 2003-11-24T08:53:33Z |
Hi, has anyone ever used a DECIMAL (or NUMERIC) field (size 18, base
4) for representing a currency field? If yes, has anyone succeded in
retrieving the correct value using ADO on the free ODBC
interbase/firebird driver? Let me explain. I converted an Access DB
to a FB DB using one of the free tools. I can handle all the field
types but the currency one converted in DECIMAL (18,4)): altough the
fields contain different values, when looping through the recordset I
always get back a 0 value for that field.
Any suggestion?
Thanks and regards,
DT.
4) for representing a currency field? If yes, has anyone succeded in
retrieving the correct value using ADO on the free ODBC
interbase/firebird driver? Let me explain. I converted an Access DB
to a FB DB using one of the free tools. I can handle all the field
types but the currency one converted in DECIMAL (18,4)): altough the
fields contain different values, when looping through the recordset I
always get back a 0 value for that field.
Any suggestion?
Thanks and regards,
DT.