Both tables involved have a field called LocationID but it isn't used in the
query. The query I posted is the entire query. There are no GeneratorLinks
or KeyLinks used by this query object.

-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: Monday, November 04, 2002 8:10 PM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Ambiguous field name?


At 05:32 PM 04-11-02 -0500, you wrote:

>Select mc.MenuCategoryID, mi.MenuItemID, mc.CategoryName, mi.ItemCode,
> mi.ItemName, mi.Price, mi.Sales
> >From xMenuCategory mc JOIN xMenuItem mi
>ON mc.MenuCategoryID = mi.MenuCategoryID
>Order by mc.CategoryName, mi.ItemCode
>
>The error is:
>***************************************************************************

*

>**
>Project xxxxx.exe raised exception class EIBO_ISCError with message 'ISC
>ERROR CODE:335544569
>
>ISC ERROR MESSAGE:
>Dynamic SQL Error
>SQL error code = -204
>Ambiguous field name between table XMENUCATEGORY and table XMENUITEM
>LOCATIONID
>
>STATEMENT:
>TIBOInternalDataset:"<TApplicatoin>.DM.qryManSales.IBOqrqryManSales.'.
>***************************************************************************

*

>**

Where does the field LOCATIONID come from? Is it part of your KeyLinks?

Could you post the actual SQL statement as seen in the monitor?

regards,
Helen



___________________________________________________________________________
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/