--- Jean-Pierre Soto <[EMAIL PROTECTED]> wrote: > Sorry ... I have too big finger ... > > I have another problem ... > > I can access to any data in the database but when I > want to see > complete record one by one, I have just > FIRST,PREVIOUS,NEXT and LAST > with built-in manager... > > How can I jump to record 100 in one step, see it, > and go to the next > record etc... > > Thanks ... >
Hi Jean-Pierre, If you're using the Automated queries and database linked controls, you can use the undocumented command 'revGoToRecordOfQuery'. If your query is named 'foobar' then use: ## on mouseUp revGoToRecordOfQuery "foobar",100 end mouseUp ## This will automatically update all the controls linked to that query. If you're using revdb library calls , you'll just have to iterate over the revdb cursor with 'revdb_movenext' until you get there: ## on mouseUp global gCursorID local tCurrentRec -- determine where we are in the cursor put revdb_currentrecord(gCursorID) into tCurrentRec if tCurrentRec < 100 then repeat 100 - tCurrentRec times get revdb_movenext(gCursorID) end repeat else repeat tCurrentRec - 100 times get revdb_moveprev(gCursorID) end repeat end if -- now that we're at the right record, do something -- ... end mouseUp ## Hope this helped, Jan Schenkel. Quartam Reports for Revolution <http://www.quartam.com> ===== "As we grow older, we grow both wiser and more foolish at the same time." (La Rochefoucauld) __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com _______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution