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/
