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)