Subject Re: [firebird-support] Re: Numeric Calculation Error ?
Author Ivan Prenosil
What result do you expect ?
Because the resulting datatype has scale 8, both the ...0041
and ...00006 at the end of your results are wrong.

Ivan

> 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