Can Modify

Wesley · Post by **Wesley** » Fri 25 Mar 2005 13:42

Hi,

How do I access the CanModify property in a dataset? I have been told that it is a public property that I should be able to set at runtime but can't seem to do it.

thx,
wes

Alex · Post by **Alex** » Mon 28 Mar 2005 12:44

You can't modify DataSet's CanModify property directly, to change its state to True you should set DataSet object ReadOnly property to False and define at least one field in KeyFields or include RowID in select SQL e.g.

Code: Select all

Select e.RowID, e.* from emp e

that is enough for TSmartQuery but if you use TOraQuery you also must define update SQLs properties.