Ventura Tools Documentation Center

Saving changes is a process:

• Run the validator;
• Send modified updateable column values to the database;
• Reset all records to unmodified and existing status.

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.