Devart Forums

Posted: **Wed 12 May 2010 12:09**

Hello
I am using Delphi 7. Sdac version 4.80.0.57

I have a Sql like

Select D.Quantity,O.OrderID,O.ShipCity from [Orders] O
Left Outer Join [Order Details] D on O.OrderID=D.OrderID

in this situation Field ShipCity is ReadOnly and is not to able to editing

But when i changed sql like this

Select O.OrderID,O.ShipCity,D.Quantity from [Orders] O
Left Outer Join [Order Details] D on O.OrderID=D.OrderID

Field ShipCity is not ReadOnly and editable.

It causes exception when using updating data while using CachedUpdates mode

Posted: **Wed 12 May 2010 13:25**

To solve the problem set the TMSQuery.UpdatingTable property to Details.
You can find more detailed information about UpdatingTable in the SDAC help.

Field ReadOnly problem