Re: Core Data, SQL stores, and predicate restrictions
Re: Core Data, SQL stores, and predicate restrictions
- Subject: Re: Core Data, SQL stores, and predicate restrictions
- From: Bill Dudney <email@hidden>
- Date: Fri, 16 May 2008 16:33:07 -0600
HI Sean,
One example would be if you have a method that calculates a value.
That value would not be in the DB so the compiled predicate (if it
would even compile) would not work because there is not column
corresponding to your calc'd value.
I think this is worth filing a bug against the docs to clear that up.
HTH,
-bd-
http://bill.dudney.net/roller/objc
On May 16, 2008, at 3:50 PM, Sean McBride wrote:
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
_______________________________________________
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