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: [email protected]
>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
>[email protected]
>To unsubscribe please visit http://listserver.u2ug.org/
>-------
>u2-users mailing list
>[email protected]
>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
>[email protected]
>To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
