| Subject | Numeric-BigDecimal problem??? |
|---|---|
| Author | Haris Papadopoulos |
| Post date | 2003-01-08T14:13:09Z |
Hi,
The problem has to do with the value of a column of
type Numeric(13,x) (where x=2 or 4 for me) fetched by a Select
statement.
I used:
---------
1) DbVisualizer 3.1
2) FirebirdSQL-RC2
3) Firebird SS-1.0.0 (Linux) or Interbase 6.0
Classic (Linux)
I executed:
----------------
1) update product set prdPrice=24.84 where
prdId='0047'
/* Statement executed OK */
2) select prdId, prdPrice from product where
prdId='0047'
/* Statement executed OK */
For column prdPrice I get the value:
24.839999999999999857891452847979962825775146484375
I 've checked that the value is updated correctly
but not fetched correctly by the driver.
I 've tested Interclient and the value is fetched
correctly.
Note that other values (eg. 24.75 or 24.00) are
fetched correctly.
Note also that the problem initially appeared in my
web-app.
Regards,
Haris Papadopoulos