Subject Re: [ib-support] Re: decimal / numeric
Author Claudio Valderrama C.
""csswa"" <csswa@...> wrote in message
> --- In ib-support@y..., "Claudio Valderrama C." <cvalde@u...> wrote:
> > It seems that I got different results than you, Andrew.
> > :-)
> Claudio, we got the same results :-) Does IB_SQL assume all numerics
> are decimals?

It's a pure display issue. You see in one place NUMERIC (fields tab) and in
the other, DECIMAL (source tab). IB_SQL and IBO in general do nothing to
distinguish between the two types because the engine itself *currently*
doesn't apply different checks to them. Hence, for now, assuming all
numerics are decimals or vice-versa doens't have a practical effect.

Claudio Valderrama C. - -
Independent developer
Owner of the Interbase® WebRing