I like it! Once improvement: if the 2nd select fails, you should clear select list #1. Something like this:
CMD = "" CMD<-1> = "PA" CMD<-1> = "SELECT REGISTRATION WITH EID = '1' SAVING UNIQUE PID TO 1" CMD<-1> = "IF @SYSTEM.RETURN.CODE < 1 THEN GO THE.END" CMD<-1> = "SELECT PEOPLE TO 2" CMD<-1> = "IF @SYSTEM.RETURN.CODE < 1 THEN GO JUMP1" CMD<-1> = "MERGE.LIST 2 DIFF 1" CMD<-1> = "GO THE.END" CMD<-1> = "JUMP1:" CMD<-1> = "CLEARSELECT 1" CMD<-1> = "THE.END:" EXECUTE CMD Even so, very cool! Thanks for sharing. JRI -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dianne Ackerman Sent: Wednesday, October 17, 2012 3:02 PM To: U2 Users List Subject: Re: [U2] Selection Suggestions for using UV instead of SQL That's a neat trick, I always assumed that you would have to write the paragraph out to the VOC and then execute it. I like this! Thanks. -Dianne On 10/17/2012 2:45 PM, David A. Green wrote: > And to do this from UniBasic: > > CMD = "" > CMD<-1> = "PA" > CMD<-1> = "SELECT REGISTRATION WITH EID = '1' SAVING UNIQUE PID TO 1" > CMD<-1> = "IF @SYSTEM.RETURN.CODE < 1 THEN GO THE.END" > CMD<-1> = "SELECT PEOPLE TO 2" > CMD<-1> = "IF @SYSTEM.RETURN.CODE < 1 THEN GO THE.END" > CMD<-1> = "MERGE.LIST 2 DIFF 1" > CMD<-1> = "THE.END:" > EXECUTE CMD > > David A. Green > (480) 813-1725 > DAG Consulting > > > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry > Hiscock > Sent: Wednesday, October 17, 2012 10:54 AM > To: 'U2 Users List' > Subject: Re: [U2] Selection Suggestions for using UV instead of SQL > > select registration with EID = '1' saving unique PID to 1 select > people to 2 merge.list 2 diff 1 > > Larry Hiscock > Western Computer Services > > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George > Gallen > Sent: Wednesday, October 17, 2012 6:59 AM > To: U2 Users > Subject: [U2] Selection Suggestions for using UV instead of SQL > > Ok. > > I have file1 - "people" that has @ID of PID I have file2 - "registration" > that has @ID of PID+EID+RID (EID = event id, RID = registration id) > > I want to select people who are not in the registration file with an > EID of "1". > > With an SQL statement - I could join the two, then do the select or > use a subquery (I'm on UV 10.0.2 - not sure if sub querys work) Just > curious how this could be done with UV Native, and without involving a > program. > > I first tried "SELECT REGISTRATION WITH EID = '1' SAVING UNIQUE PID" > -> "NSELECT PEOPLE" > > But that returned 0 - since the NSELECT only works off the current > select list, not the whole file > > Yes, I could create a temporary file, then select off that Yes, I > could read each people record, then loop through registration to see > if it doesn't exist. > Both of the above require programming > I guess I could create a subroutine that does the looping through > registration, and put that into an I descriptor - looking for another > option. > > George > > _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users