...
Code Block | ||||
---|---|---|---|---|
| ||||
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 | ||||
---|---|---|---|---|
| ||||
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); } |