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
