Hmm it never occurred to me that you can BASIC EXECUTE a paragraph which 
doesn't actually exist in the VOC but is just created on-the-fly like this.  I 
wonder if I should try this on Universe 11.
 

 

 

-----Original Message-----
From: David A. Green <dgr...@dagconsulting.com>
To: 'U2 Users List' <u2-users@listserver.u2ug.org>
Sent: Wed, Oct 17, 2012 11:45 am
Subject: Re: [U2] Selection Suggestions for using UV instead of SQL


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

_______________________________________________
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

Reply via email to