The QueryResultSet class provides for querying a result set from the dynamic query API. QueryResultSet is returned as a result of executing a query.
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 = SUP101DB.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")); }