This is the entire query. LocationID is a field in both tables but is not a
part of the query.

-----Original Message-----
From: Daniel Rail [mailto:daniel@...]
Sent: Monday, November 04, 2002 7:28 PM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Ambiguous field name?


At 04/11/2002 06:32 PM, you wrote:

>Hi All,
>
>I'm getting an error with the following query using IBO v4.21:
>
>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
>
>However, Marathon v2.0 (which uses IBO 3.4.Ca) executes it just fine.
>
>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

Where is LOCATIONID in your query? Did you post the whole query or just
part of it? The query that you posted shouldn't return that error.


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)



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