If you have any lingering questions on this, there's a very detailed
exploration of floating numbers here:

http://community.borland.com/article/0,1410,15855,00.html

Regards,
Andrew Ferguson

--- In ib-support@y..., "Entrebytes S.L." <ebytes@t...> wrote:
> IB 5.6 + Mandrake Linux 7.2
>
> Hi gang.
>
> I'm getting very angry about a quirk of Interbase with double
precision
> values.
> I store in a Double precision field (Importe) , the value 8200.14
> Interbase holds 8200.13999999999999999
> Well... not inusual. I know about some glitches in the Delphi way
of storing
> double values , so i make a external function ,
>
> ndecimals(numero,decimales)
> where numero stands for a double precision and decimales for an
integer that
> gives the number of decimals required at most.
>
> The C functions looks like
> switch decimales {
> 2 : return rint(*numero*100)/100
> ......
>
> I compile , link , declare the external , etc...
>
> when in ISQL using the function in a select as
>
> select nombre , orden_carga , ndecimals(importe,2) from v_excel_oc
>
> (in fact , is a view , but it should'nt matter)
>
> i got a lot of perfectly suitable values (in fact , i know that
some of then
> has been corrected by the ndecimals fuction because if i do it
straight ,
> without the function , somes a large number of decimals) , except
the dammed
> 8200.1399999999999
>
> So , now , i know is interbase who is lying to me , not the bloody
Delphi 4
> and his wicked arithmetics.
>
> Any ideas to lower my blood presure?
>
>
> B.T.W. . Could someone tell me what system table i should query to
ascern
> the code for creation of the user tables ? Sort of a extract
database in
> isql , but by delphi code / sql query.
>
>
> Javi
> EntreBytes S.L.
> Ontenient , Spain
> ERP Development.