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 (as of version 9444)
for (SolutionRecord sr : rs.list()) {
  String text = "Value DataID " + sr.getDataID() " = " + sr.getValue("MYVALUE");
  System.out.println(text);
}
// or (as of version 11230)
SolutionRecord sr;
while ((sr = rs.next()) != null) {
  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.

Up until version 11198 SolutionQueryResultSet wasn't memory optimized, storing all loaded SolutionRecods in memory.
Using rs.list() still loads all SolutionRecods into memory, and thus is the least optimized way to iterate over the ResultSet.