Collection Object

[Ruslan Zasukhin]

On 8/1/06 12:11 PM, "Philip Mötteli" <philip.moetteli at econophone.ch> wrote:

>> I have realize that this is VERY strange query:
>> 
>>     SELECT f3
>>     FROM NSSet
>>     WHERE RecID=1 AND f3.*.name='Ruslan'
>> 
>> Why?
>> 
>> Because here you make very weak assumption that all 3 tables T1 -
>> T3 have
>> field "name".
> 
> That's almost true.
> Almost, because Yes, I make that assumption. So why does Apple offer
> such a method to search for a value of an attribut? Because it is no
> problem, if there's no such IVar/accessor method. Apple first checks,
> if the attribute is there and only then accesses it. This strategy is
> called Key Value Coding (KVC: <http://developer.apple.com/
> documentation/Cocoa/Conceptual/KeyValueCoding/Concepts/
> BasicPrinciples.html>).
> 
> 
>> In general case as I see it, tables Ti will have totally different
>> structures. Right?
> 
> Mostly, yes.

Okay I see.

Well DBMS also can do

    if( Table.Field("name") != nil )
        then do search

So technically possible...

Even possible before loop check what tables have this field and in loop
iterate only them..


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]