Hi, the problem was killed...

I only remove the old TIBOQuery and place new one, setting again.

Thanks.

---------------------------------------------------------------
Edson Luis Gonçalez - Ribeirão Preto / SP / Brasil
Membro da Comunidade Firebird de Língua Portuguesa
(Portuguese Language Firebird Comunity Member)
"Onde o Firebird fala Português !"
(Here, the Firebird speak Portuguese ;-)

----- Original Message -----
From: "svein_erling" <svein.erling.tysvaer@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, August 14, 2002 9:33 AM
Subject: [IBO] Re: Ambiguous field name between tables ...


> Hello Edson!
>
> > Hello, i have one TIBO_Query like this,
>
> No, you do not - TIBO_Query does not exist, it could be TÌBOQuery or
> TIB_Query.
>
> > Ambiguous field name between table EMPR_USU and table CORR
> > CORR_ID
>
> Strange, your query seems OK. Are you certain that it is this query
> it complains about? Anyway, just try changing to explicit join and
> see if that make any difference:
>
> SELECT CO.CD
> , CO.NOME
> , EU.EMPRUSU_ID
> , EU.CORR_ID
> FROM EMPR_USU EU
> JOIN CORR CO
> ON CO.CORR_ID = EU.CORR_ID
> WHERE CO.CD = :CD
> AND EXISTS ( SELECT 1
> FROM PJ
> WHERE PJ.CORR_ID = CO.CORR_ID )
>
> If this does not help, try to check your properties to see if you
> reference a field that can be ambiguous, because this query is simple
> and should work.
>
> HTH,
> Set
>
>
>
>
___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
> without the need for BDE, ODBC or any other layer.
>
___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.381 / Virus Database: 214 - Release Date: 02/08/2002