RE: [Firebird-test] Calculate fields. Please Help

[Gerhardus G. <ger...@se...>]

Hi
The more appropiate place to post would be ib-...@ya...
for support questions.

I suspect your problem has to do with mixing Numeric and Integer. Try
to cast everything to either integer or numeric. I am not sure which is
bigger but that would be the right one. eg cast(myvariable as integer)

Groete
Gerhardus

>
> 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
>
> Thanks in advance
>
> Agostinho Sousa
> ago...@cl...