> anyone knows to configure IB_Connection.fetSQLType ?

> I tried:
> -------
> IB_Connection.fetSQLType=TRUE
> IB_Connection.ColumnAttributes:SQL_VARYING=YESLIKE

> No Success !?

It works from IB_Column.SQLTypeSource - but removes anything following
the first bracket. So if you look at IBA_Column.IMP
TIB_Column.GetSQLTypeSource you will find that it is looking for
things like...

INTEGER
CHAR
VARCHAR
NUMERIC
DECIMAL
DOUBLE PRECISION
DATE
TIME
TIMESTAMP


Note that it is not possible to determine DECIMAL vs NUMERIC
accurately (due to limitations in the definitions stored by IB/FB).
IBO makes the following assumptions...

SQL_QUAD,
SQL_QUAD_,
SQL_INT64,
SQL_INT64_: Result := 'DECIMAL ...
SQL_DOUBLE,
SQL_DOUBLE_: Result := 'NUMERIC ...
SQL_FLOAT,
SQL_FLOAT_: Result := 'NUMERIC ...
SQL_LONG,
SQL_LONG_: Result := 'DECIMAL ...
SQL_SHORT,
SQL_SHORT_: Result := 'DECIMAL ...


This means that you need to be careful, since a declaration of
NUMERIC(18,0) will actually turn up as DECIMAL inside IBO.

hth

--
Geoff Worboys
Telesis Computing