Subject Live Result Set with Join?
Author Steve Harp
Hi All,

I'm using a TIBOQuery and requesting a live result set. My query is a very
simple join:

Select mc.MCatID, mi.MItemID, mc.MCatName, mi.MItemCode,
mi.MItemName, mi.Price, mi.Sales
From MCat mc, MItem mi
Where mc.MCatID = mi.MCatID
Order by mc.MCatName, mi.MItemCode

I'm then trying to edit the sales field and I get an error that I can't edit
this field. Is there a restriction on getting a live result set with a
join? Is there a way to structure my query to further reduce ambiguity if
this is the problem?

Steve Harp