Unless you have a PARTID file that has it's ID as the MFGCODE and PARTCODE, then it would work.
If this is an invoice and your trying to pull off all the parts from the invoice, you will need to modify the EVAL statement to work with multivalued fields. SELECT INVOICE SAVING UNIQUE EVAL MFG:PART LIST PARTS DESC LISTPRICE George >-----Original Message----- >From: Gordon Glorfield [mailto:[EMAIL PROTECTED] >Sent: Thursday, August 12, 2004 2:22 PM >To: '[EMAIL PROTECTED]' >Subject: RE: [U2] How do we get unique records from Universe >file(Table) > > >Even if you do create the previously suggested I-descriptor in the >dictionary, you are not going to get a list of order IDs from >your select. >All you will get is a list of the unique combinations, not the >record IDs >from which they came. I'm thinking that what you are asking for will >require a program be written to come up with the information >you are looking >for. > >Gordon J. Glorfield >Sr. Applications Developer >MAMSI (A UnitedHealth Company) >301-360-8839 > > > >> -----Original Message----- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] On Behalf Of >> Chauhan, Savita >> Sent: Thursday, August 12, 2004 1:56 PM >> To: [EMAIL PROTECTED] >> Subject: RE: [U2] How do we get unique records from Universe >> file(Table) >> >> >> Can this (selecting only those order IDs which have unique >> combination of Mfg.No and Part.No) be done "without" having >> to create an intermediate dictionary item? >> >> Savita Chauhan, >> Programmer/Analyst >> x:1754 Central Texas College. >> ------------------------------------------- >> Change is the only Constant. >> >> >> -----Original Message----- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] On Behalf Of >George Gallen >> Sent: Thursday, August 12, 2004 10:31 AM >> To: [EMAIL PROTECTED] >> Subject: RE: [U2] How do we get unique records from Universe >> file(Table) >> >> You can setup a DICTIONARY ITEM that concatantes both values IE. >> >> ED DICT FILE MFGPARTNO >> >> MFGPARTNO >> 001: I >> 002: MFG.NO:PART.NO >> 003: >> 004: combo >> 005: 20L >> 006: S >> >> Assuming they are both single valued fields: >> >> Then >> >> SELECT ORDERS SAVING UNIQUE MFGPARTNO >> >> George >> >> >-----Original Message----- >> >From: Chauhan, Savita [mailto:[EMAIL PROTECTED] >> >Sent: Thursday, August 12, 2004 11:09 AM >> >To: [EMAIL PROTECTED] >> >Subject: RE: [U2] How do we get unique records from Universe >> >file(Table) >> > >> > >> >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/ >> ------- >> 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/ >> > > >This e-mail, including attachments, may include confidential and/or >proprietary information, and may be used only by the person or >entity to >which it is addressed. If the reader of this e-mail is not the >intended >recipient or his or her authorized agent, the reader is hereby >notified >that any dissemination, distribution or copying of this e-mail is >prohibited. If you have received this e-mail in error, please >notify the >sender by replying to this message and delete this e-mail immediately. >------- >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/
