Andrew:
I believe I meant BSELECT. QSELECT is used to build a list of all attributes
in a
record.
In UniData, to get a select list of the contents of an attribute you would:
:BSELECT LOOKUP.TABLE "XYZ" CODE
In D3 you'd simply:
:SELECT LOOKUP.TABLE 'XYZ' CODE
Then you'd have to mess around with saving a list then getting a list with the
"(u"
option to remove redundant codes.
According to the UV documentation, and a couple of tests, you can:
:SELECT LOOKUP.TABLE 'XYZ' CODE
{n} record(s) selected to SELECT list #0.
:SELECT SomeFile SAVING UNIQUE @ID
An example looks like:
3260 Dtademo (0)-> LIST PAYSAL 04:21:07am 23 Jan 2008 PAGE 1
PAYSAL.. EMPLOYEE NAME................. %HRS ACCT. AMOUNT.. CLNT TYP CY
AK*115 SMITH, THOMAS J 90 2010 1,525.00 770 REG M
10 2030 1,525.00 770 REG
1 records listed.
3260 Dtademo (0)-> SELECT PAYSAL 'AK*115' CLIENTNO
2 record(s) selected to SELECT list #0.
3260 Dtademo (0)>> SELECT MASTER SAVING UNIQUE CLIENTNO
1 record(s) selected to SELECT list #0.
3260 Dtademo (0)>> LIST MASTER
LIST MASTER 04:24:43am 23 Jan 2008 PAGE 1
MASTER.... NAME.......................... #UNITS
770 308 114
1 records listed.
Sorry that this won't do any good if the codes (or a I-descriptor contatenation
of
them) don't exist as @IDs in another file. I don't know what to do then. Hope
this
helps.
Bill
>-----Original Message-----
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED] On Behalf Of
>Andrew Lakeland
>Sent: Wednesday, January 23, 2008 1:39 AM
>To: u2-users@listserver.u2ug.org
>Subject: RE: [U2] [UV] Selection help
>
>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
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
