Recordset Navigator

Results 1 to 2 of 2

Thread: Recordset Navigator

  1. #1
    Join Date
    Dec 1969

    Default Recordset Navigator

    I need 4 buttons Movefirst,Movenext,Moveprevious,Movelast<BR>for to navigating records. <BR>Here i am able to get first and last but i have problem with<BR>next and previous. Please help me<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Recordset Navigator

    Hi,<BR>The problem is that when the page is recreated when pressing either of these buttons, the recordset has lost its position in the database. What you could do is store the recset position in a hidden text box, and when posted (next button) use the move command to move to the appropriate record.<BR>dim moveRec<BR>moveRec=request.form("txtLastRec")<BR>i f movenext<BR>moveRec=moverec+1<BR>else<BR>moverec=m overec-1<BR>end if<BR>of course check for eof and bof.<BR>rsRecSet.move(moverec)<BR><BR>Hope this helps,<BR>SteveF

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts