Can we save a unique combination of more than one fields, instead of just saving the unique @ID ie,
>SELECT ORDERS SAVING UNIQUE MFG.NO PART.NO Will this save records with unique combination of mfg.no and part.no? Savita. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pingilley, Ron Sent: Thursday, August 12, 2004 9:46 AM To: '[EMAIL PROTECTED]' Subject: RE: [U2] How do we get unique records from Universe file(Table) "tax in advance" -- sounds like the US Government! :) If you're doing a SELECT at tcl, try adding SAVING UNIQUE to your statement. Here's an example: > SELECT ORDERS WITH ORDER.DATE > "8/1" PART.NUMBER ...10456 items selected >> SELECT INVENTORY SAVING UNIQUE @ID ...395 items selected >> SAVE.LIST AUG.PARTS 1st step selected the PART.NUMBER field from the ORDERS file, with lots of duplicate part numbers showing up. The 2nd step pared that list down to just unique part numbers. --Ron P. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, August 12, 2004 9:05 AM To: [EMAIL PROTECTED] Subject: [U2] How do we get unique records from Universe file(Table) Hi, Can anybody help me in retriving the unique(distinct) records from Universe file tax in advance regards Reddy ------- 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/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
