> > I've just tried my application against FB2.
> > The first error I get when preparing a pretty vanilla query is
> >
> > ISC ERROR CODE:335544569
> > ISC ERROR MESSAGE:
> > Dynamic SQL Error
> > SQL error code = -206
> > Column unknown
> > RDB$INDEX_SEGMENTS.RDB$FIELD_NAME
> > unknown ISC error 336397208
> >
> > Now I can see in both the FB1.5 and FB2 databases, system tables that
> > RDB$INDEX_SEGMENTS has the field RDB$FIELD_NAME.
> > So where do I go to from here? Why on earthe would there be an error
> telling
> > me the column does not exist?
>
> This will happen if, for example, you do something like this:
>
> select i.rdb$field_name
> from rdb$index_segments i
> order by rdb$index_segments.rdb$field_name
>
> This works fine in Fb < 2, but not in Fb 2 (and it shouldn't).
>
>
> IBO doesn't work with Fb 2. Don't bother trying.
>
> Martijn Tonies

ok - so it's a matter of changing all these system queries to use aliases.
that's the first step?
Alan