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