QueryResultSet

The following example shows how to filter a result set and get values by taking data from two mobile business objects, creating a Query, filling in the criteria for the query, and filtering the query results:

com.sybase.persistence.Query query = new com.sybase.persistence.Query();
query.select("c.fname,c.lname,s.order_date,s.region");
query.from("Customer ", "c");
query.join("SalesOrder ", "s", " s.cust_id ", "c.id");
AttributeTest at = new AttributeTest();
at.setAttribute("lname");
at.setTestValue("Devlin");
query.setTestCriteria(at);
QueryResultSet qrs = SampleAppDB.executeQuery(query);
while(qrs.next())
{
  System.out.print(qrs.getString(1));
  System.out.print(",");
  System.out.println(qrs.getStringByName("c.fname"));

  System.out.print(qrs.getString(2));
  System.out.print(",");
  System.out.println(qrs.getStringByName("c.lname"));

  System.out.print(qrs.getString(3));
  System.out.print(",");
  System.out.println(qrs.getStringByName("s.order_date"));

  System.out.print(qrs.getString(4));
  System.out.print(",");
  System.out.println(qrs.getStringByName("s.region"));
}