QueryResultSet

Example

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 = SampleAppDB.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"));
            }