Questions tagged [supquery]

3 questions
2
votes
1 answer

Ordering a query using SUPQuery on iOS

I know there is a way to define the order we want things in a query, but although I know it, I am not able to use it. In my example I have the following: SUPQuery *query=[SUPQuery getInstance]; [query select:@"s.fname, s.lname"]; [query…
Rui Peres
  • 25,741
  • 9
  • 87
  • 137
1
vote
1 answer

Sybase SUPQuery testcriteria issue [iOS]

I'm developing an iPad app that shows activities in a calendar and I have 2 related MBOs with this activities. I am able to get the result set via query + join. But I am not able to get a "where" query using a testcriteria sentence. The query is OK…
javiazo
  • 1,892
  • 4
  • 26
  • 41
0
votes
1 answer

linq sub-query table cross reference

I want to conditionally exclude items from a query of tableA if an ID value for that query is NOT included at least once as a reference value in tableB... Something like this... Initial query: var jobs = from j in Jobs select j; // there's more,…
MalamuteMan
  • 151
  • 1
  • 1
  • 4