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

Reply via email to