Subject Re: [ib-support] Please Help - Calculate fields(urgent)
Author Paul Reeves wrote:
> Hi people
> I have a big problem.
> I'm using FB- and when I define a calculate
> 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 Reeves
Supporting users of Firebird and InterBase