Retrieve data

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

for (int i = 0; i < resultSet.rs.size(); i++) {
  String text = "Value nr " + i " = " + resultSet.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 datatypesdatatypes, try using the auto-suggestions in your IDE.

public int getReference( int recordNr )
public Hashtable <String,String> getRecordValueList( int recordNr )
public String getRecordValue( int recordNr, String fieldName )
public int getRecordValueInteger( int recordNr, String fieldName )
private SolutionRecord getRecord(int recordNr, boolean isWrite)