Allen: For an F correlative:
First value (a number of ways but this will work): 002 9 008 F;9R Last value: 002 9 008 F;9;P;S;_ Hope this helps. Bill > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Allen E. Elwood > (CA) > Sent: Wednesday, September 01, 2004 12:05 PM > To: [EMAIL PROTECTED] > Subject: RE: [U2] Correlative referencing multi-value field in another > file > > > Hi Rod, > > I too have had the 'pleasure' of F and A correlatives. > > Once upon a time, a nice man named Dick Pick, who created Pick > basic, issued > a challenge. He said that there was no way in native Pick to access the > last value of a multivalued field and challenged anyone to find a way. > Enter Me. 'A' correlatives were new at that time and I created a > three step > dict. Dict "step1" converted value marks into "1" 's. Dict > "step2" summed > those 1's into a number, and Dict "step3" used that sum as an > index for the > value and BINGO last value of a multivalued field in native Pick! > > I did the 'victory dance' big time while singing "feeling > stronger" from the > "Rocky" movies :-D !!! And then proceeded to pack up my solution and send > the results to Dick. > > Dick replied to me that the challenge was only for F correlatives (ahh, > shucks......) but that he would publish my solution since nobody else had > ever done so yet. "Publish" as in "paper" before the internet became > widely used. So, that was my 15 seconds of fame!!!! > > Today, I prefer SUBR type dicts over all else if it takes me more than a > couple of seconds to try to figure out what to do. > > However, I'm currently working for a client with a..........Legacy Pick > system without SUBR's. gaaaaaa....... > > Allen ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
