Subject Re: [ib-support] migrating from Firebird 0.9.4 to 1 RC1
> I was able to run all my DB scrips and also the UDF's work. But when I run
> my application I am getting a lot of errors like this:
> SQL error code = -204
> Ambiguous field name between table/view CUSTOMER_PARTS and table/view

This is something that has been 'complained about' on the
list. It is actually a 'new feature', but is telling you
that your SQL has a problem. It is caused when you assume
the table name for a field name. Depending on how the SQL is
parsed, the assumed field can change, and in the past has
resulted in different results between different versions of
the server.

If you look at your SQL, you will find that you need to add
'alias' to ensure that the correct table/field pair is used.

Some people have asked that the error is removed, but
personally I think NOW is the time to correct our queries
before random data causes more problems <g>

Lester Caine
L.S.Caine Electronic Services