property EditMode: string;
By default, the AstaClientDataSets are read only. To enable editing of an AstaClientDataSet using client side SQL, you must set the EditMode property at design time or run time. At run time you can enable a dataset for editing with the SetEditMode method. When using TAstaProviders the EditMode property is not required as the SQLGenerateLocation when set to gsServer automatically puts the AstaClientDataSet into Cached EditMode.
At design time, click on the EditMode property's ellipse button to bring up the EditMode Property Editor. You must select the Update Method, the Prime Key/s (there can be more than one field in the prime key, which correlates to your database), and the UpdateTable (specify the table that you wish to update). The dataset's status will change to "Editable" when you have filled in all three of the required subproperties.
ASTA SQL Generation