You don't need the "PA" in field one when you execute the stack.  You can 
create a multi-field record and execute it and UniVerse treats it as a 
paragraph.

Tom
RATEX Business Solutions

-----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

Reply via email to