Yep, I did make that [possibly invalid] assumption. -Keith
----Original Message---- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Womack, Adrian Sent: Tuesday, November 08, 2005 8:07 AM To: [email protected] Subject: RE: [U2] Sort help needed > The original question didn't specify that "PART.NBR" had to > be unique. Maybe > it's a list of orders and possibly contains two different > orders for the same part number. > > ________________________________ > > From: [EMAIL PROTECTED] on behalf of Keith W. > Roberts Sent: Tue 8/11/2005 11:24 PM To: [email protected] > Subject: RE: [U2] Sort help needed > > > > Your logic is wrong here; you are inserting whether PART.NBR > is found or > not. The INS should be inside the ELSE clause. > > -Keith > > ----Original Message---- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Womack, Adrian > Sent: Monday, November 07, 2005 4:49 PM > To: [email protected] > Subject: RE: [U2] Sort help needed > >> LOCATE PART.NBR IN RECORD<14,1> BY "AL" SETTING POS ELSE NULL >> >> INS PART.NBR BEFORE RECORD<14,POS> >> INS related.data BEFORE related.field<14,POS> >> >> No need to do the second locate. >> >> Note: I've used the PI/Open syntax for the LOCATE statement (that's >> the only one I relate to), you may have to alter the syntax > slightly. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
