Field ReadOnly problem

[gurkal]

Hello
I am using Delphi 7. Sdac version 4.80.0.57

I have a Sql like

Code: Select all

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

Code: Select all

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

[Dimon]

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