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)