--- 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?


ib_sql - table numtest
fields tab:

f_numeric numeric(4,2) null
f_decimal numeric(9,2) null

ibconsole - table numtest
Properties tab:

f_numeric numeric(4,2) allow nulls yes
f_decimal decimal(4,2) allow nulls yes

ib_sql - table numtest
source tab:

CREATE TABLE NUMTEST (
F_NUMERIC DECIMAL ( 4, 2 )
, F_DECIMAL DECIMAL ( 9, 2 )
)

ibconsole - table numtest
metadata tab:

CREATE TABLE "NUMTEST"
(
"F_NUMERIC" NUMERIC(4, 2),
"F_DECIMAL" DECIMAL(4, 2)
);


Regards,
Andrew Ferguson