|Subject||Re: [IBO] Read-Only Database with Firebird 2.1.1 and IBObjects 4.8.7|
> [snip]Btw, it's the where clause. For example, changing the where clause to
>> 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.
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.
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and