An SUPAttributeTest defines a filter condition using an MBO attribute, and supports multiple conditions.
SELECT * from A where id in [1,2,3]
SUPQuery *query = [SUPQuery getInstance]; SUPAttributeTest *test = [SUPAttributeTest getInstance]; test.attribute = @"id"; SUPObjectList *v = [SUPObjectList getInstance]; [v add:@"1"]; [v add:@"2"]; [v add:@"3"]; test.testValue = v; test.operator = SUPAttributeTest_IN; [query where:test];
SELECT a.id from AllType a where exists (select b.id from AllType b where b.id = a.id)
Sybase.Persistence.Query query = new Sybase.Persistence.Query(); query.Select("a.id"); query.From("AllType", "a"); Sybase.Persistence.AttributeTest test = new Sybase.Persistence.AttributeTest(); Sybase.Persistence.Query existQuery = new Sybase.Persistence.Query(); existQuery.Select("b.id"); existQuery.From("AllType", "b"); Sybase.Persistence.Column cl = new Sybase.Persistence.Column(); cl.Alias = "a"; cl.Attribute = "id"; Sybase.Persistence.AttributeTest test1 = new Sybase.Persistence.AttributeTest(); test1.Attribute = "b.id"; test1.Value = cl; test1.SetOperator(Sybase.Persistence.AttributeTest.EQUAL); existQuery.Where(test1); test.Value = existQuery; test.SetOperator(Sybase.Persistence.AttributeTest.EXISTS); query.Where(test); Sybase.Persistence.QueryResultSet qs = SUP101DB.ExecuteQuery(query);