SUPAttributeTest

For example, the Objective-C code shown below is equivalent to this SQL query:

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];

When using EXISTS and NOT_EXISTS, the attribute name is not required in the AttributeTest. The query can reference an attribute value via its alias in the outer scope. The Objective-C code shown below is equivalent to this SQL query:

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);