George, The first example worked beautifully, thanks for all help! :)
Chris > From: ggal...@wyanokegroup.com > To: u2-users@listserver.u2ug.org > Date: Wed, 20 Jul 2011 16:58:38 -0500 > Subject: Re: [U2] SELECT question, paginated select. > > If your doing the selects from a Basic program, > > In order to avoid passlist and a second execute, you can pass a dynamic array > of the commands you want to execute. > > CMD1='SELECT CLIENT BY NAME WITH NAME = "A]"' > CMD1<-1>='SELECT CLIENT WITH PAGE = 4' > EXECUTE CMD1 [RTNLIST] [CAPTURING] > > OR > > CMD1='SELECT CLIENT BY NAME WITH NAME = "A]"':@AM:'SELECT CLIENT WITH PAGE = > 4' > EXECUTE CMD1 [RTNLIST] [CAPTURING] > > > -----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:46 PM > > To: u2-users@listserver.u2ug.org > > Subject: Re: [U2] SELECT question, paginated select. > > > > > > Thank you! We don't do a lot of double select statements in our > > programs, I assume you do the 1st SELECT and then do some sort of > > CAPTURED or PASSLIST command > > to pass the first selected values into the 2nd SELECT. > > > > Chris > > > > > > > > > > > From: ggal...@wyanokegroup.com > > > To: u2-users@listserver.u2ug.org > > > Date: Wed, 20 Jul 2011 16:32:54 -0500 > > > Subject: Re: [U2] SELECT question, paginated select. > > > > > > You understand that the value for PAGE is specific to the SELECT / > > LIST > > > which is why when you list the names, it displays as page 1, which is > > > based on that output. When you did the select, it pulled from the > > page > > > numbers from that selection. > > > > > > As to how it works. If I understand correctly myself.... > > > > > > @1 is the results of the first value in an I - descriptor, which > > > apparantly is not cleared from item to item in a listing, but is > > > zero'd at the beginning of a select/list. > > > > > > So...the first row, @1 = 0, and we do an @1+1, which adds 1 to the 0 > > > and now 1 becomes @1 (the first value), and the next row uses the > > > previously uncleared value, and so on. > > > > > > Now, I don't know if this is a bug (not clearing the value) or if > > it's > > > supposed to do that! So if it's a bug....it could stop working on a > > > later release of UV, if it's a feature, it's a cool one. > > > > > > 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