Chris, Bscan is a universe command that will let you traverse a secondary index. Say the last company on the page was ABC Company, your BSCAN commands match value could be Abc and then step thru the list with a loop. The UV docs description isn't too bad.
Curt Chris Austin <cjausti...@hotmail.com> wrote: > >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 > _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
