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

Reply via email to