At 10:25 AM 18-11-02 +0000, you wrote:

>--- In ib-support@y..., "Arno Brinkman" <firebird@a...> wrote:
> > When looking at your query i don't see something wierd that can
>cause an
> > ambigous error. Can you post the exact error-message you get ?
>Which version
> > of Firebird 1.0 do you use ?
> >
>
>I downloaded Firebird recently from IBPhoenix. I don't know the exact
>version but the exe is dated 8 march 2002.
>
>This is the error message:
>Dynamic SQL Error
>SQL errorcode = -204
>Ambiguous fieldname between table PANEELART and table ARTIKEL
>BESLAGNR
>
>Because it is a (simple) Interbase application I use IBX.

Do you have an SQL Monitor running in your application, that you can use to
inspect the parsed SQL that IBX is passing to the server?

It may be that you will need to use fully-qualified column names with IBX
for this query in order to persuade it to behave properly... IBConsole
(which is built with IBX) also causes ambiguity errors with Firebird...

heLen