|Subject||Re: [IBO] IB_Connection.fetSQLType|
> anyone knows to configure IB_Connection.fetSQLType ?It works from IB_Column.SQLTypeSource - but removes anything following
> I tried:
> No Success !?
the first bracket. So if you look at IBA_Column.IMP
TIB_Column.GetSQLTypeSource you will find that it is looking for
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_INT64_: Result := 'DECIMAL ...
SQL_DOUBLE_: Result := 'NUMERIC ...
SQL_FLOAT_: Result := 'NUMERIC ...
SQL_LONG_: Result := 'DECIMAL ...
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.