George, I put PAGE in my CLIENT DICT so it looks like the following:
PAGE 0001 I 0002 @1+1 ; INT((@1+1-2)/20)+1 0003 0004 PAGE 0005 6R 0006 S After I filed it I got a message stating an I-descriptor needs to be compiled but I didn't do that. When I do a LIST CLIENT PAGE I see the page #'s. To paginate in order using the 2 selects are you suggesting I do something like SELECT CLIENT WITH NAME = "A]" and then save that to a LIST where I use it in the 2nd SELECT with PAGE = 4? Thanks for the help so far, I believe I have the PAGE I-descriptor setup properly. Chris > From: ggal...@wyanokegroup.com > To: u2-users@listserver.u2ug.org > Date: Wed, 20 Jul 2011 15:38:39 -0500 > Subject: Re: [U2] SELECT question, paginated select. > > This works with UV, and not the SQL solution. > > However, I did find if you need to do a sorted select, you first have to do > the select > then a second select to pull the rows / pages > > SELECT CLIENT WITH NAME LIKE "A..." > SELECT CLIENT WITH PAGE = 4 > > SELECT CLIENT WITH NAME LIKE "A..." AND WITH PAGE = 4 WILL NOT WORK CORRECTLY > > I'm making the assumption that the @1 trick works in Pick flavor, as I'm > using Information flavor. > > 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 4:34 PM > > To: u2-users@listserver.u2ug.org > > Subject: Re: [U2] SELECT question, paginated select. > > > > > > George, > > > > Is the dictionary change below used for the SQL solution you mentioned? > > In other words, do I have to add this to use the SQL queries > > to paginate it based on row? Or is this a trick to use a UniVerse > > SELECT? > > > > Chris > > > > > > > From: ggal...@wyanokegroup.com > > > To: u2-users@listserver.u2ug.org > > > Date: Wed, 20 Jul 2011 15:22:44 -0500 > > > Subject: Re: [U2] SELECT question, paginated select. > > > > > > 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 > > > > _______________________________________________ > > 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