Not to start a deviated thread, but the value of '9' on 002 begs some opinions. Technically, the '9' on 002 contributes nothing to 008 as 008 gets all of its info by itself. Therefore what's on 002 is ambiguous.
I've seen systems where *all* multi-field correlatives (this example excluded) have 002=0. I've also seen others where they are some high number like 99. I tend to favor slotting it in the attribute of the predominant value. For example if attr 9 is the COST and 10 is the on-hand and 11 is the on-order, EXT-COST-OH and EXT-COST-OO would have 002=9. It could be 10 or 11 and perhaps either of these 3 is far more acceptable than 0 or 99. Of course this is my opinion after travelling through dozens of systems and seeing hundreds of examples. I'd like to get some pros or cons. Thanks in advance. Mark Johnson ----- Original Message ----- From: "Bill H." <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, September 03, 2004 6:33 PM Subject: RE: [U2] Correlative referencing multi-value field > 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/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
