> And it seems to only occur with a scale higher than 4, from what I
> read in another post. Have to say it looks like a bug in InterBase's
> numeric handling. I assume that if you cast everything as
> NUMERIC(18,4), then everything works properly? i.e.:

I hoped the same, but in the meantime I have made some additional tests with
Numeric(18,2)-Fields. From a value of -10.000.000 IB calculates wrong. And that's a
really serious problem for, what should I say to my customer ? Sorry, IB cannot
calculate, but it's really fast.


Guido