I don't know UD. I guess it's a UV thing only. George
> -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of bradley.sch...@usbank.com > Sent: Wednesday, July 20, 2011 5:08 PM > To: U2 Users List > Subject: Re: [U2] SELECT question, paginated select. > > I've seen this technique described before but it doesn't work for me on > UD7.1. Is there a way of doing this in UniData? > > Thx, > Brad. > > > > From: George Gallen <ggal...@wyanokegroup.com> > To: U2 Users List <u2-users@listserver.u2ug.org> > Date: 07/20/2011 03:23 PM > Subject: Re: [U2] SELECT question, paginated select. > Sent by: u2-users-boun...@listserver.u2ug.org > > > > OK. Try this.... > > ED DICT CLIENT ROW > 0001: I > 0002: @1+1 > 0003: > 0004: ROW > 0005: 5R > > Now, you can SELECT CLIENT WITH ..... AND WITH ROW >=1 AND ROW <=20 > > As long as the selection stays the same, This "should" work. > > 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 1:15 PM > > To: u2-users@listserver.u2ug.org > > Subject: [U2] SELECT question, paginated select. > > > > > > I'm working on a screen in our webapp where we're using a dojo widjet > > to create a drop down with client names. The problem > > is that we have 1,000's of clients and when we do a SELECT on this > many > > clients it takes a while. I know we can index the field but > > I was wondering if you can do smart selecting in UniVerse. > > > > For example if I wanted to use this query: > > > > SELECT CLIENT WITH @ID = "A]" SAMPLE 10 (returns 10 clients > starting > > with the letter A). > > > > I want to paginate my drop down so the first query has the above > data. > > The problem I'm facing is that I don't know how to > > get the NEXT 10 clients? Is there a way to do this? > > > > For example if I wanted to return the next 10 CLIENTS, without > > including any of the first 10. > > > > Chris > > > > > > > > _______________________________________________ > > 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 > > > U.S. BANCORP made the following annotations > --------------------------------------------------------------------- > Electronic Privacy Notice. This e-mail, and any attachments, contains > information that is, or may be, covered by electronic communications > privacy laws, and is also confidential and proprietary in nature. If > you are not the intended recipient, please be advised that you are > legally prohibited from retaining, using, copying, distributing, or > otherwise disclosing this information in any manner. Instead, please > reply to the sender that you have received this communication in error, > and then immediately delete it. Thank you in advance for your > cooperation. > > > > --------------------------------------------------------------------- > > _______________________________________________ > 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