Hi Bill,
BSELECT does not exist on UV. (which was your original question)
QSELECT does select all attributes UNLESS you specify the field.
Check the example I sent Bill, "SAVING" !!!
Example
LIST VENF16 72988359 F21
VENF16.... F21.......
72988359 T13219224
T13219226
T13219227
QSELECT VENF16 72988359 SAVING 21
3 record(s) selected to SELECT list #0.
Only the 3 MV value are selected.
Regards
Andy
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
Sent: 23 January 2008 13:38
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UV] Selection help
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/
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/
