Subject | Re: [firebird-support] Re: Numeric Calculation Error ? |
---|---|
Author | Ivan Prenosil |
Post date | 2005-01-14T07:56:23Z |
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
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