Hi Aage,

> >>I'm trying to use IB_SQL with Fb/2-beta1. IB_SQL is built with ibo/4.5.B.
> >>Queries seem to be working all right, but trying to browse the metadata
> >>gives the following message:
> >>Column does not belong to referenced table
> >
> > I think something similar was reported awhile back. I don't know if
> > Jason has made, in the upcoming update, the necessary changes for FB2
> > that some did report and I think even gave a few potential fixes. Look
> > in the list, you might find some answers.
>
>
> [Looking in the list ... ... ... ...]
> Thomas Steinmaurer raised the issue in March (and again in April). In June
> Jason replied:
> --------------------------
> Changing a system query in IBO shouldn't be too difficult. While Firebird 2
> is in Alpha I more or less expect that whoever wants to play with IBO and
> Firebird 2 will be willing to roll up there sleeves a bit and make any
> necessary modifications to IBO as things go along. Once Firebird 2 hits a
> stable BETA is when I'll start taking heavy steps to having IBO ready for
> all those want to BETA test it via their IBO applications.
> --------------------------
>
> Which should mean that Jason will just need a reminder to start taking care
> of it(?).

AFAIK the necessary changes are already included in the current beta of
the next IBO sub-release.

If you don't want to upgrade IBO right now, then check out at least the
following procedures in IB_Schema.pas.

procedure SchemaIndexInfo
procedure SchemaIndexSegmentsInfo
procedure SchemaForeignKeyInfo


HTH,
Thomas