Re: predicate for a Core Data fetch request rejected by SQL

2010-03-07 Thread Jeffrey Oleander
On Sat, 2010/03/06, Joanna Carter cocoa...@carterconsulting.org.uk wrote: This quote from the Core Data Programming Guide: There are some interactions between fetching and the type of store. In the XML, binary, and in-memory stores, evaluation of the predicate and sort

Re: predicate for a Core Data fetch request rejected by SQL

2010-03-06 Thread Joanna Carter
Hi Mark Thanks all for the sharing of thoughts. Glad someone could confirm that what I was attempting did not make sense from the SQL perspective (which I am a newbie to). But, like Sean wrote, Core Data seems to be presented as an abstraction ABOVE the layer which implements the actual

Re: predicate for a Core Data fetch request rejected by SQL

2010-03-06 Thread Sean McBride
On 3/5/10 5:52 PM, Mark Sanvitale said: However, my experience seems to demonstrates that the statement We (the system) cannot necessarily translate arbitrary predicates into SQL queries is also true, It definitely is. and I believe this concept should be expanded to spell out exactly what

predicate for a Core Data fetch request rejected by SQL

2010-03-05 Thread Mark Sanvitale
RANT AGAINST DOCUMENTATION: I have searched (a lot) and found various other pleas for help of the form, I am trying to do a Core Date fetch on an SQL-backed store and it is failing because something is wrong with my predicate. I thought some investigate could promote my plea beyond this basic

Re: predicate for a Core Data fetch request rejected by SQL

2010-03-05 Thread Joanna Carter
Hi Mark So, here is my plea for help. I have a predicate of the form: character string BEGINSWITH path. In other words, I am searching entities that possess a (string) property path to look for one whose path is a prefix of some string (which is inserted into the predicate via the

Re: predicate for a Core Data fetch request rejected by SQL

2010-03-05 Thread Sean McBride
On 3/5/10 10:18 PM, Joanna Carter said: So, here is my plea for help. I have a predicate of the form: character string BEGINSWITH path. In other words, I am searching entities that possess a (string) property path to look for one whose path is a prefix of some string (which is inserted into

Re: predicate for a Core Data fetch request rejected by SQL

2010-03-05 Thread Joanna Carter
Hi Sean But you shouldn't have to... Core Data is not a database and its use of SQL is an implementation detail. One shouldn't have to know anything about SQL to use Core Data. Of course, in practice, such knowledge is helpful, as you say. You have a point but, in theory, predicates

Re: predicate for a Core Data fetch request rejected by SQL

2010-03-05 Thread Mark Sanvitale
Thanks all for the sharing of thoughts. Glad someone could confirm that what I was attempting did not make sense from the SQL perspective (which I am a newbie to). But, like Sean wrote, Core Data seems to be presented as an abstraction ABOVE the layer which implements the actual