Saving changes is a process:


Saving changes includes:

  • Sending modified record data to the database (UPDATE statement);
  • Creating new rows (INSERT statement);
  • Deleting existing rows (DELETE statement).


To save changes for a single recordset, call the Recordset.SaveChanges method.


var customers = new CustomersRecordset();

customers.ExecSql(100);


Call the Transactional.SaveChanges method to bundle the SaveChanges for multiple recordsets into a single HTTP request and a single database transaction.


var customers = new CustomersRecordset();

var patients = new PatientsRecordset();


customers.Append();

customers.Name = "Joanna";


patients.Append();

patients.Name = "Pete";

           

Transactional.SaveChanges(customers, patients);


See topic Transactions.