--- In IBObjects@yahoogroups.com, "Jack Cane, PhD" <canejack@e...>
wrote:

>
> My application needs to to construct sql queries on the fly. I

would like to

> populate listboxes with field names from different FireBird

tables. I would

> like to run a query to recover DDL information, particularly the

field

> names. Would appreciate reference to sample code, help file or

other

> documentation that gives the syntax, methods, etc. Have looked

around in IBO

> as well as other references, so far without success.
>
> Tks,
>
> jwc

SELECT FIELD_NAME FROM RDB$RELATION_FIELDS
WHERE RELATION_NAME=:yourtable

Should do the trick.

RGDS
Steffen Nyeland