I have no idea what the BSCAN directive is? Is that a UniVerse command? It seems that there's not really a straightforward consensus on the solution to this problem.
Chris > From: lar...@wcs-corp.com > To: u2-users@listserver.u2ug.org > Date: Wed, 20 Jul 2011 12:42:10 -0700 > Subject: Re: [U2] SELECT question, paginated select. > > Look at the BSCAN directive. It allows you to scan and traverse B-Tree type > files and alternate indices. > > Larry Hiscock > Western Computer Services > > > -----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 12:19 PM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] SELECT question, paginated select. > > > 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 > > _______________________________________________ > 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