Curt, My problem is understanding how to traverse the query. Our dropdown is paginated, we can specify the # of results per paginated drop-down so it being super long or short isn't an issue. The problem is getting the SELECT statements/UniVerse to match what we want the dropdown to do.
For example if I query a table called CLIENT which has @ID indexed, I do the following: EXECUTE 'SELECT CLIENT BY @ID' My questions are: #1) How would I specify 10 results back from the query? #2) How would I 'pick up' where I left off for page 2 (values 11-20)? Doug mentioned using SAVE.LIST to do this, Bill says that you have to do a dance in UniVerse. I guess I'm curious what this dance is that I need to do? If it's not handled in the SELECT then what technique are you using in UniVerse? Chris > Date: Wed, 20 Jul 2011 13:59:48 -0500 > From: cstew...@tri-sysconsulting.com > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] SELECT question, paginated select. > > Chris, > I agree with Bill, using an index is your best solution. Are you able to > apply any kind of filter criteria to the names? If not here's one of your > dilemmas... If you make your drop down list too small nobody will use it > because it will take too long to get to anyone beyond the A's. If you make it > too long it will be cumbersome to find someone on the page and the build time > of the drop down list on the client side may be too slow. I strongly > recommend, from experience, using something other than a dropdown list, even > using a combo box list allows the user to provide some criteria to narrow the > search. > Hth > Curt Stewart > > Chris Austin <cjausti...@hotmail.com> wrote: > > > > >Bill, > > > >I was curious if you had a quick example? I'm just curious how you guys are > >suggesting to do this > > > >Chris > > > >> Date: Wed, 20 Jul 2011 11:13:04 -0700 > >> From: wphask...@advantos.net > >> To: u2-users@listserver.u2ug.org > >> Subject: Re: [U2] SELECT question, paginated select. > >> > >> Chris: > >> > >> I'm betting the solution also needs indexing, because you want to pick > >> up where the last list left off and you don't want to wait for a select > >> to return to save the list. So, SAMPLE isn't really a solution but > >> indexing is. We do this all the time, but we have to use indexing. In > >> fact, we parse through a file with millions of records to get a page > >> full of stuff and the pop-up list is instantaneous. > >> > >> Secondly, I'm not sure a dropdown list is the appropriate choice for a > >> thousand items. > >> > >> HTH, > >> > >> Bill > >> > >> ------------------------------------------------------------------------ > >> ----- Original Message ----- > >> *From:* cjausti...@hotmail.com > >> *To:* u2-users@listserver.u2ug.org > >> *Date:* 7/20/2011 10:14 AM > >> *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