Thanks; it works perfectly.

jwc

-----Original Message-----
From: steffen_nyeland [mailto:sny@...]
Sent: Wednesday, April 07, 2004 12:50 PM
To: IBObjects@yahoogroups.com
Subject: [IBO] Re: DDL Query for Field Names

--- 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



___________________________________________________________________________
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