Hi Christian,

> I am trying to query the field names of a relation with
> the following statement:
>
> SELECT Rdb$Field_Name
> FROM Rdb$Relation_Fields
> WHERE Rdb$Relation_Name = 'MyTable'
>
> For some tables, this works, but for some other tables,
> the query returns no rows.
>
> I would be very glad about hints what I am doing wrong.

Perhaps case-sensitive table names?



HTH,
Thomas Steinmaurer
LogManager Serie - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions
http://www.upscene.com