Home All Groups Group Topic Archive Search About

Ingres II money value with ADO.net and ODBC

Author
7 Nov 2005 5:01 PM
PIEBALD
We're using a product that uses Ingres II for its database. I'm accessing the
data with ADO.net via the Ingres II ODBC driver V2.8

There are cases where Ingres II's query test tool reports particular MONEY
values as 5.2 (which is correct), but on some records I get 5.19 in my
DataTable instead.
If I got 5.199999999 I'd understand and be able to distinguish that from
5.19000000

I expect the test tool is doing some rounding, but shouldn't the ODBC driver
do that as well?

Any ideas how I can work around this?

(I've also asked CA and the third-party vendor. But if it's an ADO.net
problem this seems the right place to ask.)

<retorical>
When will people stop using floating point for money?
</retorical>

AddThis Social Bookmark Button