Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • sqlstate - The error state.
  • sqlcode - The error code.
  • sqlMessage - The message text.


Code Block
languagejs
firstlinetitleExample
var newValues = {
  firstname: fname,
  dob: null
}

try {
  // This will result in only the firstname and dob columns being updated.
  let filter = pjs.data.createCondition("customerNumber", "=", "1");
  let result = pjs.data.update("customers", filter, newValues);
  console.log(result);

} catch(error) {
 console.error(error);
}

...