I'm confused. My query doesn't have a WHERE clause in it. How can I fix
this? This is what I'm sending.

*************************************************
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)
and (mc.LocationID = 2)
and (mi.LocationID = 2)
ORDER BY mc.CategoryName, mi.ItemCode
*************************************************

Steve

-----Original Message-----
From: Daniel Rail [mailto:daniel@...]
Sent: Tuesday, November 05, 2002 1:25 PM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] Ambiguous field name?


At 05/11/2002 12:13 PM, you wrote:

>/*---
>PREPARE STATEMENT
>TR_HANDLE = 16342000
>STMT_HANDLE = 21905836
>
>Select mc.MenuCategoryID, mi.MenuItemID, mc.CategoryName, mi.ItemCode,
>mi.ItemName, mi.Price, mi.Sales
> , XMENUITEM.RDB$DB_KEY
> From xMenuCategory mc JOIN xMenuItem mi
>ON (mc.MenuCategoryID = mi.MenuCategoryID)
>and (mc.LocationID = 2)
>and (mi.LocationID = 2)
>WHERE (LocationID = 2)

Right here(line above) is your problem. Where is this query defined or
what are you doing when it is being generated?

>ORDER BY mc.CategoryName ASC
> , mi.ItemCode ASC

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/