CMD1="SELECT1" EXECUTE CMD1 RTNLIST [VARNAME] CMD2="SELECT2" EXECUTE CMD1 PASSLIST [VARNAME] RTNLIST [VARNAME]
Where [VARNAME] is an optional variable name to hold the list in case you had multiple lists you were working on. I believe you can hold selectlist variables in a regular array ()'s, but not in a dynamic array <>'s IE. EXECUTE CMD1 RTNLIST LIST1 HOLDIT(1)=LIST1 .... .... .... LIST1=HOLDIT(1) EXECUTE CMD2 PASSLIST LIST1 RTNLIST LIST2 > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Chris Austin > Sent: Wednesday, July 20, 2011 6:15 PM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] SELECT question, paginated select. > > > OK cool, thanks. Just out of curiosity how would you do 2 selects using > a PASSLIST? > > Chris > > > > From: ggal...@wyanokegroup.com > > To: u2-users@listserver.u2ug.org > > Date: Wed, 20 Jul 2011 17:06:50 -0500 > > Subject: Re: [U2] SELECT question, paginated select. > > > > SORRY, My mistake. > > > > that should have been > > > > SELECT CLIENT WITH PAGE = <<I3,PAGENO>> > > > > That should clear up the error. > > > > > -----Original Message----- > > > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > > > boun...@listserver.u2ug.org] On Behalf Of Chris Austin > > > Sent: Wednesday, July 20, 2011 6:02 PM > > > To: u2-users@listserver.u2ug.org > > > Subject: Re: [U2] SELECT question, paginated select. > > > > > > > > > I setup my VOC as follows: > > > > > > PA > > > SELECT CLIENT BY NAME WITH NAME = "<<I2,SRCH>>]" > > > SELECT CLIENT WITH PAGE = <<I2,PAGNO>> > > > > > > I received an error though: > > > > > > CHRIS>GETCLIENTS A 4 > > > > > > 6000 record(s) selected to SELECT list #0. > > > RetrieVe: syntax error. Unexpected symbol. Token was "". > > > Scanned command was SELECT CLIENT WITH PAGE = A > > > > > > Without setting up a VOC entry is there an easy way to execute 2 > > > selects in a program (just like in telnet)? > > > > > > Chris > > > > > > > > > > From: ggal...@wyanokegroup.com > > > > To: u2-users@listserver.u2ug.org > > > > Date: Wed, 20 Jul 2011 16:50:08 -0500 > > > > Subject: Re: [U2] SELECT question, paginated select. > > > > > > > > oops forgot the bracket: > > > > > > > > Should read: SELECT CLIENT BY NAME WITH NAME = "<<I2,SRCH>>]" > > > > > > > > > -----Original Message----- > > > > > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > > > > > boun...@listserver.u2ug.org] On Behalf Of George Gallen > > > > > Sent: Wednesday, July 20, 2011 5:48 PM > > > > > To: U2 Users List > > > > > Subject: Re: [U2] SELECT question, paginated select. > > > > > > > > > > I'm not sure if this works on Pick flavor but... > > > > > > > > > > ED VOC GETCLIENTS > > > > > 001: PA > > > > > 002: SELECT CLIENT BY NAME WITH NAME = "<<I2,SRCH>>" > > > > > 003: SELECT CLIENT WITH PAGE = <<I2,PAGNO>> > > > > > > > > > > NOW, You can get your results with > > > > > > > > > > GETCLIENTS A 4 > > > > > GETCLIENTS ALEX 6 > > > > > > > > > > George > > > > > > > > > > > -----Original Message----- > > > > > > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > > > > > > boun...@listserver.u2ug.org] On Behalf Of Chris Austin > > > > > > Sent: Wednesday, July 20, 2011 5:26 PM > > > > > > To: u2-users@listserver.u2ug.org > > > > > > Subject: Re: [U2] SELECT question, paginated select. > > > > > > > > > > > > > > > > > > George, > > > > > > > > > > > > I must say, you the man! And thanks for everyone else's help > too. > > > > > That > > > > > > I-descriptor works beautifully and saved me a ton of time, > thanks > > > a > > > > > > bunch. > > > > > > To get my results in order I have to do the double select, > such > > > as: > > > > > > > > > > > > 03 SELECT CLIENT BY NAME WITH NAME = "A]" > > > > > > 02 SELECT CLIENT WITH PAGE = 4 > > > > > > 01 LIST CLIENT PAGE NAME > > > > > > > > > > > _______________________________________________ > > > > > 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 > > _______________________________________________ > 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