Subject Re: [IBO] IB_Connection.fetSQLType
Author Geoff Worboys
> If I set IB_Connection.FieldEntryTypes := [fetDomainName] , and then
> put an entry in IB_Connection.ColumnAttributes like VARCHAR=YESLIKE
> this works fine !

I would not have expected this to work, IB_Column.DomainName should
return the actual domain name, or blank if no domain was used, so the
entry above using the base datatype should not have worked. Still
I have not tested so I guess you could be right.

> I thought, it would work the same way if I set
> IB_Connection.FieldEntryTypes := [fetSQLType] and in
> IB_Connection.ColumnAttributes I put entry like

> Am I totally wrong ?

I just took a quick look at the code. All the ColumnAttribute
parameters are processed inside TIB_Column (and not inside
TIB_Statement - which is where most of the Fields* stuff is done).

As it turns out the ColumnAttributes processings in TIB_Column does
NOT check fetSQLType at all! It only checks fetDomainName.
I remember modifying some of this code a long time ago, but I cannot
remember if there was any reason for not including fetSQLType.

From the look of it, it should not be too difficult to update to also
check fetSQLType. Are you willing to give it a try?

Geoff Worboys
Telesis Computing