Alan,

> 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
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com