Executing the SQL script in a recordset is process:

  1. The input parameters are set;
  2. The SQL script is executed;
  3. The resultset data is collected;
  4. The output parameter values are retrieved.

The SQL script can be executed by calling the Recordset.ExecSql method.

var customers = new CustomersRecordset();


With the Transactional.ExecSql method the ExecSQL for multiple recordsets is bundled into a single HTTP request and a single database transaction. 



invoices.SetExecSqlParams(1, 10022);

Transactional.ExecSql(customers, orders, invoices);

See topic Transactions.