Think you mean QSELECT. QSELECT LOOKUP.TABLE "XYZ" SAVING 10
Select multivlaues in field 10.....you still need another select to make unqiue. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: 23 January 2008 09:58 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Selection help Doesn't UV have something like BSELECT? So the commands would be: :BSELECT LOOKUP.TABLE "XYZ" CODE {n} records selected to list 0. :SELECT SomeFile SAVING UNIQUE @ID Just a thought. Bill >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of >Boydell, Stuart >Sent: Wednesday, January 23, 2008 5:57 PM >To: u2-users@listserver.u2ug.org >Subject: [U2] [UV] Selection help > >I have a table which contains an MV list of codes. What I want to do is >get a unique list of codes in the table for a lookup list... > >Table XYZ >@ID = XYZ >LINE = 1]2]3]4]5]6]7... >CODE = AAA]BBB]BBB]CCC]AAA]AAA]BBB... > >The list I'd like returned is: AAA]BBB]CCC... >The semantic I think I'd like is: SELECT LOOKUP.TABLE "XYZ" SAVING >UNIQUE CODE > >However, this doesn't work. Is there a simple select statement to do >this I'm overlooking? > >Cheers, >Stuart > > > >********************************************************************** >This email message and any files transmitted with it are confidential >and intended solely for the use of addressed recipient(s). If you have >received this communication in error, please reply to this e-mail to >notify the sender of its incorrect delivery and then delete it and your >reply. It is your responsibility to check this email and any >attachments for viruses and defects before opening or sending them on. >Spotless collects information about you to provide and market our >services. For information about use, disclosure and access, see our >privacy policy at http://www.spotless.com.au Please consider our >environment before printing this email. >********************************************************************** >------- >u2-users mailing list >u2-users@listserver.u2ug.org >To unsubscribe please visit http://listserver.u2ug.org/ >------- >u2-users mailing list >u2-users@listserver.u2ug.org >To unsubscribe please visit http://listserver.u2ug.org/ > >Legal Disclaimer: >The information contained in this message may be privileged >and confidential. It is intended to be read only by the >individual or entity to whom it is addressed or by their >designee. If the reader of this message is not the intended >recipient, you are on notice that any distribution of this >message, in any form, is strictly prohibited. If you have >received this message in error, please immediately notify the >sender and delete or destroy any copy of this message >------- >u2-users mailing list >u2-users@listserver.u2ug.org >To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ Legal Disclaimer: The information contained in this message may be privileged and confidential. It is intended to be read only by the individual or entity to whom it is addressed or by their designee. If the reader of this message is not the intended recipient, you are on notice that any distribution of this message, in any form, is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete or destroy any copy of this message ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
