| Subject | Re: [firebird-support] Numeric Calculation Error ? |
|---|---|
| Author | Ivan Prenosil |
| Post date | 2005-01-14T07:25:20Z |
> select 0.00 - (13060.45*9.031631) - (13060.45*8.65) from RDB$DATABASEBoth results are wrong. Probably wrong formatting in your application.
>
> 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
Did you try ISQL ?
Ivan