At 11:10 AM 7/04/2004 -0400, you 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.

Jack,
The metadata are all stored in ordinary Firebird objects (tables, views,
triggers, etc.). Grab IB_SQL and open its browser with the "System
objects" checked. For details about the data stored in them, refer to the
IB6 Language Reference.

Helen