Subject Re: [ib-support] Please Help - Calculate fields(urgent)
Author Paul Reeves
news.clix.pt wrote:
> Hi people
>
> I have a big problem.
> I'm using FB-1.0.0.796-0.64IO.i386.rpm and when I define a calculate
field
> like
> NUMERIC(18,4)*NUMERIC(18,8)/INTEGER i got wrong values
>
> eg. 157809.0000*1.00000000/1077=14652.6462
> when the correct value is 146.5264
>

Well, it works for me with dialect 3.

What dialect are you using?


BTW, you do know that the Linux 64 bit file i/o is broken in that build,
don't you? You can carry on using it, as long as you don't try and grow
the database beyond the 4 Gb file limit.


Paul
--

Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird and InterBase