Retrieve data

Data are extracted from the query resultset using a relative reference to the record number

for (int i = 0; i < rs.size(); i++) {
  String text = "Value nr " + i " = " + rs.getRecordValue(i, "MYVALUE");
  System.out.println(text);
}
// or
for (int i = 0; i < rs.size(); i++) {
  SolutionRecord sr = rs.getRecord(i);
  String text = "Value nr " + i " = " + sr.getValue("MYVALUE");
  System.out.println(text);
}
// or
for (SolutionRecord sr : rs.list()) {
  String text = "Value DataID " + sr.getDataID() " = " + sr.getValue("MYVALUE");
  System.out.println(text);
}

Retriever methods exist for different datatypes, try using the auto-suggestions in your IDE.