Use this to read data from Database, change data and write back to the Database in simple way

For reading data use SQLStatement object Method execute.

 

Example:

let r=SQLStatement.execute("select \"ItemCode\",\"ItemName\" from \"OITM\" where \"ItemCode\" = 'RM' "),
  {updateTable="OITM",primaryKey="ItemCode"});
// change field
r.ItemName[1]="My New Value";
// save back to database
if (r.update()=-1) alert("update not possible");