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();

customers.ExecSql(100);


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


customers.SetExecSqlParams("m845");

orders.SetExecSqlParams("m845");

invoices.SetExecSqlParams(1, 10022);

Transactional.ExecSql(customers, orders, invoices);


See topic Transactions.