Field ReadOnly problem

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 1
Joined: Wed 12 May 2010 11:44

Field ReadOnly problem

Post by gurkal » Wed 12 May 2010 12:09

I am using Delphi 7. Sdac version

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

Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » 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.

Post Reply