MoveNext

Description

Moves to the next row in a cursor.

Applies to

Syntax

cursorobject.MoveNext( )

Argument	Description
cursorobject	A variable that contains a reference to an instance of PSCursorClass

Returns

Boolean. Returns true if the end of the cursor has been reached, and false if it has not.

Usage

At runtime, MoveNext calls the next method on the ResultSet object.

Examples

Example 1

The following example uses MoveNext to process all of the rows in a cursor. Each time the cursor position changes, it writes the column values for the current row to the HTML page:

myquery = "SELECT products.prod_id, products.prod_name
		FROM DBA.products";

mycursor = myconnect.CreateCursor(myquery);

if ( myconnect.GetError() == null )

		for (i=0; (!mycursor.EOF()); i++)

			psDocument.Write(mycursor.GetValue(0) + " " +
				mycursor.GetValue(1));

			psDocument.Write("<BR>");

			mycursor.MoveNext();

else {

		dberror = true;

	if ( dberror == true )

		errobj = myconnect.GetError();

		str = errobj.GetCode() + " " +        errobj.GetMessage();

		psDocument.Write ( str );