--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...>
wrote:

>
> At 07:51 PM 3/11/2008, you wrote:
> >If anyone has done any Interbase to Firebird conversions, here is

a

> >question for you..please help!
> >
> >I converted from Interbase 6 to Firebird Embedded
> >I kept the original ibx components and everything seemed to work

fine

> >until I got
> >
> >Dynamic SQL Error
> >
> >SQL error code = -206
> >
> >Column unknown
> >
> >SKAAP.FAMILIE_ID
> >
> >At line 1, column 86.
> >
> >I get this on a number of queries and it worked fine on Interbase.
> >The fields are in the table, I checked the queries too. The weird
> >thing is that some fields are found and others not. All in the

same

> >table! No quotes were used.
>
> The most likely thing is that your problem queries are using a mix

of table identifiers and relation aliases to qualify the column names
(or some qualified and some not). From Fb 2-forward, this is
invalid. Use either all table identifiers or all aliases and don't
omit any.

>
> ./heLen
>

Thanx heLen!
I checked quickly, but there aren't any aliases. Could I provide the
code that I'm using, maybe you see something I don't?