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

Reply via email to