On 28/08/13 01:20, Wjhonson wrote: > Yes I think you could use an On The Fly statement like the EVAL to do the > trans if you can't actually mod the dictionary > OOPS!!!
I know this is UD, but in UV you couldn't do "on the fly" like EVAL if you couldn't mod the dictionary. Whether that was a security feature and thus is still true, or it just made temporary changes to the dictionary and may have changed, I don't know. But if UD is the same, if you can't mod the dictionary you can't do an EVAL. Cheers, Wol -- > > -----Original Message----- > From: Allen Elwood (TW) <aelw...@socal.rr.com> > To: U2 Users List <u2-users@listserver.u2ug.org> > Sent: Tue, Aug 27, 2013 5:13 pm > Subject: Re: [U2] Select from one file with save-list from another file > > > > forgot to mention, david green knows a way of doing this with some fancy > statements, i'm sure he'll chime in when he sees the thread, so don't > give up hope yet brandon! > > On 8/27/2013 5:06 PM, Allen Elwood (TW) wrote: >> that's basically what my program does on the fly, see fourth gosub >> >> GOSUB GET.OPTIONS >> GOSUB DETERMINE.TEMP.FILESIZE >> GOSUB LOAD.TEMP.FILE >> GOSUB CREATE.TEMP.DICT >> GOSUB BUILD.LIST2 >> GOSUB FINISH.UP >> >> On 8/27/2013 4:03 PM, Wjhonson wrote: >>> It seems to me that the easiest way to create a "list of orders where >>> the customers state is Arizona" >>> is to first create a translation FROM the Order file INTO the >>> Customer file which will return the customers state >>> and then just select on that new dictionary entry >>> >>> >>> >>> >>> >>> -----Original Message----- >>> From: Rick Nuckolls <r...@lynden.com> >>> To: 'U2 Users List' <u2-users@listserver.u2ug.org> >>> Sent: Tue, Aug 27, 2013 4:01 pm >>> Subject: Re: [U2] Select from one file with save-list from another file >>> >>> >>> Your response supposes that the ORDER.ID IS is in the CUSTOMERS >>> file/table, >>> which is not the criteria of the original problem. >>> >>> The problem presented is a bit difficult to work around in RETRIEVE, >>> and even >>> harder if you are restricted to not programming, as Brandon evidently >>> is. >>> >>> We wrote a utility that will take a preselected list and create a new >>> list based >>> on the values of an alternate key, which would functions as >>> >>> SELECT CUSTOMERS WITH STATE = 'AZ' >>> >>> SELECTINDEX ORDERS CUSTOMER.ID ## use the CUSTOMER.ID index of >>> ORDERS to >>> find those orders related to customers within the list; return a list >>> of ORDERS >>> ids. >>> >>> Alternately, in Brandon's example, it might work to create a >>> translate field >>> from the Y.INFO file to the Y.INFO status field, but that would >>> probably involve >>> a less efficient overall selection, and would not be practical if the >>> data >>> common to the two tables (packet.id), is the primary key to neither, >>> in which >>> case: >>> >>> SELECT X.INFO WITH status = 'ccc' SAVING [UNIQUE] packet.id >>> >>> SELECTINDEX Y.INFO packet.id >>> >>> Sorry that I am unable to send out the code for SELECTINDEX, but, a >>> simple >>> version is straightforward to program using the BASIC "SELECTINDEX" >>> function. >>> >>> -Rick >>> >>> -----Original Message----- >>> From: u2-users-boun...@listserver.u2ug.org >>> [mailto:u2-users-boun...@listserver.u2ug.org] >>> On Behalf Of Jo Lester >>> Sent: Tuesday, August 27, 2013 2:54 PM >>> To: u2-users@listserver.u2ug.org >>> Subject: Re: [U2] Select from one file with save-list from another file >>> >>> SELECT CUSTOMERS WITH STATE = 'AZ' SAVING ORDER.ID >>> >>> LIST ORDERS >>> >>>> From: r...@lynden.com >>>> To: u2-users@listserver.u2ug.org >>>> Date: Tue, 27 Aug 2013 14:42:34 -0700 >>>> Subject: Re: [U2] Select from one file with save-list from another file >>>> >>>> I found an old example on line that might get you started >>>> >>>> SELECT TO SLIST 0 FROM CUSTOMERS WHERE STATE = 'AZ'; >>>> SAVE.LIST CUSTOMER.LIST >>>> >>>> SELECT * FROM ORDERS WHERE CUSTOMER.ID IN (SELECT EVAL " <at> >>>> RECORD" FROM >>>> &SAVEDLISTS& 'CUSTOMER.LIST'); >>>> >>>> The extra syntax that might help is >>>> >>>> SELECT TO SLIST <savedlist #> FROM ORDERS .... >>>> >>>> If CUSTOMER.LIST is your X.INFO and ORDERS is your Y.INFO... >>>> >>>> Rick >>>> >>>> -----Original Message----- >>>> From: u2-users-boun...@listserver.u2ug.org >>>> [mailto:u2-users-boun...@listserver.u2ug.org] >>> On Behalf Of Hilk, Brandon >>>> Sent: Tuesday, August 27, 2013 1:24 PM >>>> To: u2-users@listserver.u2ug.org >>>> Subject: [U2] Select from one file with save-list from another file >>>> >>>> Hello! >>>> >>>> >>>> UniVerse 10.1, HP/UX, Pick. >>>> >>>> >>>> Is there a way I can build a save-list from a selection from one file >>>> X.INFO (where the record ID is an 8 digit number) and use that list to >>>> select from file Y.INFO (where that 8 digit number is not the record ID >>>> but does exist as a "foreign key" elsewhere in the file). In SQL this >>>> would be considered a join and would look something like this: >>>> >>>> >>>> select * >>>> >>>> from X.INFO, Y.INFO >>>> >>>> where X.INFO.packet.id=Y.INFO.packet.id >>>> >>>> and X.INFO.status='ccc'; >>>> >>>> >>>> I can run this in TCL and have it return the results I want but can't >>>> build a save-list from it because I don't know the UniVerse/SQL syntax >>>> to do so. >>>> >>>> >>>> So to summarize, is there a way to use a save-list built from X.INFO to >>>> make another save-list comprised of the record ID's from Y.INFO? >>>> >>>> >>>> Thanks for any advice you can give. >>>> > _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
