That's how to do a unique field, if it's a record which has to be unique, you can fake it by creating an I-Desc using @RECORD, the do the SELECT SAVING UNIQUE as mentioned.
Beware, if the records are anything but very small, this is a very bad idea and you should solve it programmatically. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pingilley, Ron Sent: Thursday, August 12, 2004 10: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/
