At 21:24 05/04/2004 +0200, you wrote:

> > In this case FB should give an error right ????
> >
> > I just did another test...
> >
> > In ISQL I got an warning:
> > SQL warning code = 204
> > -Ambiguous field name between table TABLE1 and table TABLE2
> > -NUMBER
> >
> > In IBOConsole and IBConsole no warnings...
>
>So it isn't an error of the engine but of IB[O]Console, I'd say.
>
>Luc.
>

Hi Luc,

I think the engine reports the error back but the client applications is
ignoring it.

But I don't know how the query could be executed and a resultset returned
to me on IB[O]Console...

AFAIK query with ambiguous field should generate an exception, and should
not be executed.

thank you !


Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br

----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.631 / Virus Database: 404 - Release Date: 17/03/2004


[Non-text portions of this message have been removed]