Jack Cane, PhD schrieb:

> Thanks; it works perfectly.

Or you can use the IB_Connection SchemaCache properties.

procedure GetFieldsForTable ( const aTablename: String;
const sl: TStrings );
begin
myIB_Connection.SchemaCache.GetTableFields ( atableName, sl );
// now the stringList is populted with all the fields for that table
// NOTE! it's qualified with the tablename,
// ie MYTABLE.MYCOLUMN1, MYTABLE.MYCOLUMN2 ...
end;

Luc.