Re: EOQualifier for null relation

On 8 May 2006, at 11:12, WILLIAM GARNETT wrote:

>  Hello all;
>
> I have two tables which have a relationship established between  
> them. The
> realtionship is not obligatory, so the foreign key is allowed to be  
> null.
>
> My question is: Can I set up an EOQualifier to fetch only those  
> objects in
> which the foreign key is null?
>
> Cheers,
>
> Bill.

["not obligatory"?  Shouldn't that be "NOT MANDATORY"?  Is anybody  
besides me hearing the "Fruity Oaty Bars" jingle right now?]

As I recall, for qualifiers to be used against the database only and  
not against objects in memory, you are allowed to refer to non-class  
attributes.  A qualifier of '(foreignKeyAttr = nil)' might well work.


--
Patrick Middleton