Core Data, SQL stores, and predicate restrictions
Core Data, SQL stores, and predicate restrictions
- Subject: Core Data, SQL stores, and predicate restrictions
- From: "Sean McBride" <email@hidden>
- Date: Fri, 16 May 2008 17:50:02 -0400
- Organization: Rogue Research
Hi all,
After reading the docs and archives, it is clear to me now that with
Core Data's SQL store one is more limited in the types of predicates one
can use with fetches.
What I can't find is a list of what I can and can't do. The best I
found was "[the] SQL store, on the other hand, compiles the predicate
[...] to SQL and evaluates the result in the database itself. [...] it
means that evaluation happens in a non-Cocoa environment, and so sort
descriptors (or predicates) that rely on Cocoa cannot work". How do I
know if my predicate "relies on Cocoa"?
For example, given the Employees/Departments scenario: if I try to fetch
all employees that are in exactly 2 departments I use a fetch predicate
of "departments[SIZE] == 2" which works great everywhere except with the
SQL store. I learnt this the hard way.
Thanks,
--
____________________________________________________________
Sean McBride, B. Eng email@hidden
Rogue Research www.rogue-research.com
Mac Software Developer Montréal, Québec, Canada
_______________________________________________
Cocoa-dev mailing list (email@hidden)
Please do not post admin requests or moderator comments to the list.
Contact the moderators at cocoa-dev-admins(at)lists.apple.com
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden