private PreparedStatement buildSQLr()
{
PreparedStatement result;
JDBQuery query = new JDBQuery(Common.selectedHostID, Common.sessionID);
query.clear();
query.addText(JUtility.substSchemaName(schemaName, "select * from {schema}APP_PALLET"));
query.addParamtoSQL("MHN_Number=", masterHoldNoticeNumber);
query.appendSort(jComboBoxSortBy.getSelectedItem().toString(), jToggleButtonSequence.isSelected());
query.applyRestriction(false, "none", 0);
query.bindParams();