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:

Sybase.Persistence.Query query = new 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.Attribute = "lname";
  at.TestValue = "Devlin";
  query.TestCriteria = at;
  QueryResultSet qrs = SMP101DB.ExecuteQuery(query);
  while(qrs.Next())
  {
    Console.Write(qrs.GetString(1));
    Console.Write(",");
    Console.WriteLine(qrs.GetStringByName("c.fname"));

    Console.Write(qrs.GetString(2));
    Console.Write(",");
    Console.WriteLine(qrs.GetStringByName("c.lname"));

    Console.Write(qrs.GetString(3));
    Console.Write(",");
    Console.WriteLine(qrs.GetStringByName("s.order_date"));

    Console.Write(qrs.GetString(4));
    Console.Write(",");
    Console.WriteLine(qrs.GetStringByName("s.region"));
  }