From: Paul D B on
No I don't and why are you repeating what I said?
Read my reply at the bottom of the thread.

Paul

Geoff Schaller wrote:
> You misunderstand.
>
> The index is in the child because this is where the seek occurs. You
> are confirming this.
>
> But the fields and the name does not have to be identical and the
> parent does not have to be indexed or even in the same order as the
> child. The only requirements are that the data type of the linked
> parent field and value has to match the index expression in the
> child. The child seek is triggered by a record movement in the parent.
>
> Don't forget you can relate on more than one field.
>
> Geoff
>
>
>
> "Paul D B" <polleke(a)NOMORESPAMhnt.be> wrote in message
> news:4b055f3e$0$2853$ba620e4c(a)news.skynet.be:
>
>> Stephen Quinn wrote:
>>
>>> }aul
>>>
>>
>>>>> The field doesn't have to be in the index expression (of the chld)
>>
>>>> of the master, you mean... ?
>>
>>> No - the child
>>>
>>> Matter of fact it doesn't have to be in the expression of any index
>>> for the relationship to work.
>>> The only requirementa are that it's in both DBFs and the child has
>>> an index
>>> CYA
>>> Steve
>>
>>
>> Are you sure Steve? I thought that the underlying mecanism was a
>> seek. So the eacht time the master moves a record - a seek is
>> performed in the child . I don't see how you can seek on a common
>> field when it is not incuded in the index expression of the child.
>>
>> See VO help for Setrelation::
>> As always, the child work area should have a controlling index that
>> matches the expression."
>>
>>
>> --
>> Paul



--
Paul


From: Paul D B on
Stephen Quinn wrote:
> Paul
>
> Yeah - I'm wrong again, no idea what I'm typing these days<g>
> - glad I've given programming away, seems like it's time for me to
> retire from the ng.
>
> Sorry for the misinformation.
>
> CYA
> Steve

Oh no don't retire from this NG Steve; you have very often given me/us very
useful information.

--
Paul


From: Dave Francis on
Nah Steve,

It's just all you Aussies are letting the rugby (beaten by Scotland - Who?
[Richard - hear that?]) and the temporay ( I'm sure :), loss of the Ashes,
get to you. I myself, humble pom, have lived with failure all my life and
contnue to revel in it! As you should know, it is in our blood! Hardly a day
goes by without a major goof adorning my life.
You are surely not prepared to lower yourself to my level. No! Soldier on
Sunshine. Us Poms need You :o)

Dave Francis

"Paul D B" <polleke(a)NOMORESPAMhnt.be> wrote in message
news:4b0a9049$0$2860$ba620e4c(a)news.skynet.be...
> Stephen Quinn wrote:
>> Paul
>>
>> Yeah - I'm wrong again, no idea what I'm typing these days<g>
>> - glad I've given programming away, seems like it's time for me to
>> retire from the ng.
>>
>> Sorry for the misinformation.
>>
>> CYA
>> Steve
>
> Oh no don't retire from this NG Steve; you have very often given me/us
> very useful information.
>
> --
> Paul
>


First  |  Prev  | 
Pages: 1 2 3 4
Prev: Help with C# Source
Next: VO2Ado Parameterized Query