> > 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.
> >
>
> How about dialect? (should be 3 for true numeric datatype)
>
> Andrew

Yes and thanx for the reply. I switched to dialect 3 and it works OK.
This means though that I have to migrate all my databases to dialect 3 in
order to use the driver.
Anyway, thanx again Andrew.

Haris