Page 1 of 1

Can Modify

Posted: Fri 25 Mar 2005 13:42
by Wesley
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

Posted: Mon 28 Mar 2005 12:44
by Alex
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.