--- In IBObjects@yahoogroups.com, Thomas Steinmaurer <ts@...> wrote:

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

Yes I just tried it again: I created a complete new database file,
just with one table

create table test ( test integer default 0);

after using gfix with parameter -mode read_only I can't execute the
above statement.

When I change the table and don't use the "default 0"-part in it,
everything works fine.

Greatings

Dr. Seltsam

@Thomas: Hallo, wir waren uns wegen des Themas gestern schon im
Entwicklerforum begegnet, also bitte nicht wundern. Ich glaube nicht,
dass so wahnsinnig viele Leute auf read-only Firebird-Datenbanken
zugreifen, obwohl es in Verbindung mit dem Embedded-Server die
perfekte Lösung für Archiv-Funktionen ist...

Viele Grüße Patrick