Hi,
I'm using dialect 3 character set WIN1252 with the server running on a
Win2k.

----- Original Message -----
From: "Daniel Rail" <daniel@...>
To: <ib-support@yahoogroups.com>
Sent: Sunday, May 04, 2003 6:47 AM
Subject: Re: [ib-support] Ambiguous field


> Hi,
>
> At May 2, 2003, 16:28, Valdir Stiebe Junior wrote:
>
> > Hi,
> > I'm using Firebird 1.0 and i'm not getting the exception that should be
> > raised about the ambiguous fields.
> > I'm doing this
>
> > select *
> > from
> > MY_PROCEDURE(params) MP left outer join
> > TEST_TABLE T1 on MP.ID_TT = T1.ID_TT left outer join
> > TEST_TABLE T2 on T2.ID_TT_MASTER = T1.ID_TT
> > where
> > ID_STATUS = 2 <<=== Should raise an exception!?
>
> > The problem here is that the person who wrote this SQL didn't used the
table
> > alias at the where, but it don't raised any exception.
>
> Which dialect that the database is using? The ambiguous field error
> occurs when using dialect 3, but not with dialect 1.
>
> --
> Best regards,
> Daniel Rail
> Senior System Engineer
> ACCRA Group Inc. (www.accra.ca)
> ACCRA Med Software Inc. (www.filopto.com)
>
>
>
> 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/
>