Try select VENF16 "72988359" SAVING F21
-----Original Message----- From: Bill Haskett [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 23, 2008 1:46 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Selection help Thanks Andy. I didn't know about this added functionality of QSELECT, as SELECT has always worked in D3 and other PICK flavors. I understand UniData syntax would be: :QSELECT VENF16 "72988359" (21 Consequently, I figured SELECT was a much more portable verb. But then, I never use PI/OPEN flavor. Thanks again, Bill >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of >Andrew Lakeland >Sent: Wednesday, January 23, 2008 6:13 AM >To: u2-users@listserver.u2ug.org >Subject: RE: [U2] [UV] Selection help > >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 ------- 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/
