Page Comparison

// Retrieve data into a record object by querying a table using product id
var record = pjs.query("SELECT * FROM productsp WHERE prid = ?", prid, 1);

// Set matching global declared fields, including any screen fields
pjs.setFields(record);
 
// Display the screen
display.myform.execute();
 
// Retrieve user input back into the record object
record = pjs.getFields(record);