Subject | Re: Numeric Calculation Error ? |
---|---|
Author | kamen_lai |
Post date | 2005-01-14T07:42:18Z |
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:
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