ACCEPT CHANGES

Commits all pending changes made in the specified DataTables of the DataSet.

Syntax:

>>--EXEC ADO-.--------------------.-ACCEPT CHANGES FOR--------->
             +-USING dataset_name-+

 >-------------.-ALL DATATABLES-.----END-EXEC------------------><
               | +------,-----+ |
               | V            | |
               +-datatable_name-+

Parameters:

dataset_name The DataSet reference to be used. If you do not specify dataset_name, the current DataSet is used.
datatable_name The DataTables where the changes are accepted.

Comments:

The row state of the added and modified DataRows is modified to unchanged and deleted DataRows are removed.

No changes are made to the underlying data source. Only the DataTables in the DataSet accept changes. Use UPDATE DATASOURCE to change the underlying data source.

DataTables can be changed directly with INSERT, DELETE (SEARCHED) and UPDATE and via a DataRows cursor with DELETE (POSITIONED) and UPDATE.

Example:

     EXEC ADO
        ACCEPT CHANGES FOR ALL DATATABLES
     END-EXEC