Thsnks, will try that as well; cannot get much simpler than that.

BTW, I did have to make a couple of changes to Steffen's query, which I
should have mentioned, in case others try it. The query that works is:

SELECT RDB$FIELD_NAME
FROM RDB$RELATION_FIELDS
WHERE RDB$RELATION_NAME ='CONTRIBUTORS'

tks,

jwc
-----Original Message-----
From: Lucas Franzen [mailto:luc@...]
Sent: Thursday, April 08, 2004 7:14 AM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Re: DDL Query for Field Names


somehow a lot of my mails get lost in space (as well in IBO as in
fbsupport...)

Okay, once again:

Jack,


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.






___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
Yahoo! Groups Links