Prev: Help with C# Source
Next: VO2Ado Parameterized Query
From: Paul D B on 23 Nov 2009 08:37 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 23 Nov 2009 08:38 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 23 Nov 2009 15:09
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 > |