MoveNext Method

Applies To
OBinder

Description
This method changes the current record to be the next record in the dynaset's result set.

Usage
oresult OBinder::MoveNext(void)

oresult ODynaset::MoveNext(oboolean gopast = TRUE)

Arguments
gopast TRUE when we allow the current record mark to go past the last record in the set

Remarks
This method sets the current record of the dynaset (for OBinder, the dynaset being managed by the OBinder object) to be the next record in the result set. It is the most common routine used to navigate through the records of the database.

It is possible to MoveNext past the last record in the dynaset. The current record then becomes invalid and the IsEOF method returns TRUE. This is the default behavior. If you want to restrict dynaset navigation to valid records, pass in a gopast argument of FALSE. OBinder::MoveNext always restricts navigation to valid records.

Execution of this method sends OADVISE_MOVE_NEXT messages to all attached advisories. One of the advisories could cancel the move, which would result in an OFAILURE return.

If the dynaset is being managed by an OBinder object, this method causes PreMove and PostMove triggers to be called.

Return Value
An oresult indicating whether the operation succeeded (OSUCCESS) or not (OFAILURE).

Example
This example deletes all the managers.

// open a database

ODatabase odb("ExampleDB", "scott", "tiger");

// open a dynaset

ODynaset empdyn(odb, "select * from emp");

// get an OField object for looking at the job field

OField job = empdyn.GetField("job");

// look through all the employees

while (!empdyn.IsEOF())

{

if (0 == strcmp((const char *) job, "MANAGER"))

{ // we found a manager - delete that employee

empdyn.DeleteRecord();

}

// go to next record (gets us to valid record)

// or past EOF if there are no more records

empdyn.MoveNext();

}