Hi Helen,

I still get the same message. I've modified my query to:

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
Where (mc.LocationID = mi.LocationID)
Order by mc.CategoryName, mi.ItemCode

Assuming that there is a problem with my query, why does this query work in
Marathon and not in my application? The only difference I can see is the
IBO version.

Steve

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


At 08:54 PM 04-11-02 -0500, you wrote:

>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.

This, then, is probably the source of the parsing error that is throwing
LOCATIONID into the equation. I did ask you to show the SQL that the
monitor was indicating, since it is almost certainly different to what you
think you are passing in the SQL property.

I can only guess, but I suspect you have a primary key in there that
involves LOCATIONID. There WILL be KeyLinks used by this query object (and
must be) unless you (erroneously) disabled KeyLinksAutoDefine AND failed to
enter your own KeyLinks.

I suggest you inspect the KeyLinksAutoDefine and KeyLinks
properties. Because it is a joined set, you should set KeyLinksAutoDefine
to False and enter your own KeyLinks, which will need to be a list of
columns coming from each table in the join (Table.ColumnName) that,
together, uniquely identify one row of the output set. If one or more of
those tables has LOCATIONID in its primary key, then you need to include
that column (unambiguously) in the KeyLinks for its role in the joining of
the tables; or, if required, modify your SQL (e.g. with a WHERE
X.LOCATIONID=X.LOCATIONID) to resolve the ambiguity. (That's not offering
a solution, only a pointer to where you could possibly go...)

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/