Versions Compared

Old Version 2

changes.mady.by.user Alex Roytman

Saved on

compared with

New Version Current

changes.mady.by.user Jessica Tomkins

Saved on

Key

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

...

Code Block
languagejavascript
titleLoad all records at once
pjs.defineDisplay("display", "mydisplay.json");
 
var records = pjs.query("SELECT * FROM ORDERS");
display.grid1.replaceRecords(records);

...

Code Block
languagejavascript
titleLoad one record at a time using primitive objects
pjs.defineDisplay("display", "mydisplay.json");
 
display.grid1.clear();
 
var c1 = pjs.allocStmt();
c1.executeDirect("SELECT * FROM ORDERS");
 
var record = c1.fetch();
while (c1.hasMoreRows()) {
  // custom processing before record is added can go here
  display.grid1.push(record);
  record = c1.fetch();
}


Code Block
languagejavascript
titleLoad one record at a time using a data structure with global fields
pjs.defineDisplay("display", "mydisplay.json");
 
pjs.define("ordersDS", { type: 'data structure', extName: "ORDERS"});

display.grid1.clear();
 
var c1 = pjs.allocStmt();
c1.executeDirect("SELECT * FROM ORDERS");
 
pjs.fetch(c1, ordersDS);
while (c1.hasMoreRows()) {
  // custom processing before record is added can go here
  display.grid1.write();
  pjs.fetch(c1, ordersDS);
}