Subject Re: Numeric Calculation Error ?
Author kamen_lai
i think the last result 4984.2725939500006 is correct.

By the way , i use ibexpert , ib_sql by IBO & isql , both show same
results.



--- In firebird-support@yahoogroups.com, "Ivan Prenosil"
<Ivan.Prenosil@s...> wrote:
> > select 0.00 - (13060.45*9.031631) - (13060.45*8.65) from RDB$DATABASE
> >
> > the wrong result is -230930.057593950041
> >
> > but
> >
> > select 0.00 + (13060.45*9.031631) - (13060.45*8.65) from RDB$DATABASE
> >
> > get correct result is 4984.2725939500006
> >
> > in IB 6.01. & WI-V1.5.1.4481 Firebird 1.5
>
> Both results are wrong. Probably wrong formatting in your application.
> Did you try ISQL ?
>
> Ivan