Quick References
      ADO
      ASP
      CSS2
      HTML
      JavaScript
      Jet SQL
      VBScript
      WML
      WMLScript
      WSH
      XHTML
      XML DOM
      XSLT

Features
      Knowledge Base
      Tutorials

Partners
     ZVON.ORG
     XML
     Planet Source Code
     VisualBuilder
     Web Design
     Your HTML Source
     XML/XSLT Forums
     ASPAlliance
     Scripts
     
     Programmers Heaven
     Tek-Tips Forums
     Developer Fusion
     Code Project











METHOD:  Recordset::MoveNext
recordsetobject.MoveNext

The MoveNext method is called to move to the next record in the specified Recordset object.

If you are at the last record, calling this method will put you at EOF and the EOF property will be set to True. If you are at EOF and call this method, an error will be generated.

This is one of four methods belonging to the Recordset object that allow you to navigate or move through a data record. The other three are, MoveFirst, MoveLast, and MovePrevious.

Code (VBScript):
rsGuruChants.MoveFirst
Do While Not rsGuruChants.EOF
   If rsGuruChants.Status = adRecModified Then
      Response.Write rsChants("ChantTitle") & VBCRLF
   End If
   rsGuruChants.MoveNext
Loop

RDS allows the Recordset object to be bound to an HTML tag so that the data can be displayed on a web page. You can use four buttons on a Web page to navigate through a displayed recordset. When a button is clicked, a subroutine containing one of the four move methods is called:

Code (VBScript):
Sub MoveFirst_OnClick
   objDataControl.objRecordset.MoveFirst
End Sub

Sub MoveLast_OnClick
   objDataControl.objRecordset.MoveLast
End Sub

Sub MoveNext_OnClick
   If objRecordset.EOF = False Then
      objDataControl.objRecordset.MoveNext
   End If
End Sub

Sub MovePrevious_OnClick
   If objRecordset.BOF = False Then
      objDataControl.objRecordset.MovePrevious
   End If
End Sub

  


Copyright 1999-2005 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information