You are right. I though I had checked all the queries for that...

Thanks

Herbert



|--------+------------------------>
| | lester@lsces.c|
| | o.uk |
| | |
| | 13.12.2001 |
| | 11:34 |
| | Please respond|
| | to ib-support |
| | |
|--------+------------------------>

>--------------------------------------------------------------------------------------------------------------------------------------------|

| |
| To: ib-support@yahoogroups.com |
| cc: |
| 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
> ORDER_TARGETS
> COMMENT

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


To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/