Subject Re: [IBO] Getting the fieldname
Author Geoff Worboys
> call me stupid, but I need to know the correct way to
> get the fieldname of a table.

TIB_Column has three field name related properties...

FieldName = the actual field name
eg: MyField

FullFieldName = the full table.field name
eg. TableA.MyField

BestFieldName = which returns FullFieldName if this is needed to
distinguish one column from another (if there are multiple tables in
the query). If the full name is not necessary it will return just the

In IB6 dialect 3, these values will all return the full dialect 3 name
including quotes if the table/field was defined that way.

If you wish to remove the quotes, use IB_Parse and call
Result := stLitCriteria( FieldName )


Geoff Worboys
Telesis Computing