Subject Re: [firebird-support] Re: Mathematics problem
Author Milan Babuskov
Miki Avramovic wrote:
> I solved the problem. I send message only like comment for other
> programers.

I looks to me that the "other programmers" never had the problem ;)

> See this:
> Testing with Fb/1.5.2 SS [WI-V6.3.2.4731 Firebird 1.5] (dialect 3):
>
> 1.
> select (109.87 - 5*109.87/100) from rdb$database
> = 104.38
> 2a.
> select (109.87 - 5*(109.87/100)) from rdb$database
> = 104.42

Same thing. Either write 5.00 and 100.00 or CAST to appropriate type.

--
Milan Babuskov
http://www.flamerobin.org