> [snip]
>
>> SELECT RDB$RELATION_FIELDS.*
>> , RDB$RELATION_FIELDS.RDB$DB_KEY
>> from rdb$relation_fields
>> where rdb$default_source is not null
>
> The statement above fails and leads to the error message.
>
> I have no idea why, possibly it is related to using RDB$DB_KEY in the
> statement, although the above query works fine on the read-only database
> in isql.

Btw, it's the where clause. For example, changing the where clause to

WHERE RDB$DEFAULT_SOURCE IS NULL

allows me to execute the query with IBO and FB 2.1. Both statements work
fine with Firebird 2.0 and IBO. Weird.


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/