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/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
