Calls the Record.ResetToExisting method for all records in the resultset.


This method is inherited from the RecordsetData class.


public void ResetAllToUnmodifiedExisting()


Examples

Records are added to the recordset and then the records are reset to DataRecordStatus.Existing:


customers.Append();

customers.ID = 100;

customers.Firstname = "John";

customers.Lastname = "Smith";


customers.Append();

customers.ID = 101;

customers.Firstname = "Paula";

customers.Lastname = "Jones";


customers.ResetAllToExisting();


When Recordset.SaveChanges() is called, an UPDATE statement will be generated for the two records.