LOTUS CONNECTORS


NextRow method
Example

Sets the current row position to the next row in a result set.

Defined in

ODBCResultSet

Syntax

status = odbcResultSet.NextRow

Return value

status


Usage

Use to read through a result set. An error is generated if there is no result set, or if the last record in a result set is reached. Use GetError to examine errors. To aid in looping over newly retrieved result sets, a NextRow operation that is the first row-positioning method invoked after Execute sets the row position to 1.

Do not use NextRow as a condition for a While or Until loop because when NextRow returns False because there are no more rows, an error is generated. Use IsEndOfData to test for the end of the table, and use NextRow within the loop.

In a Do loop, use IsEndOfData in the Until clause. Then, you can use NextRow at the top of the loop. When the loop is first called and no other procedures have been called, NextRow is set to 1 to cover all rows in the table.

Errors

Invalid row (DBstsINVR)

End of data has been reached (DBstsEOFD)

Events

BeforeNextRow

AfterNextRow

BeforeRowPositionChange

AfterRowPositionChange

Example
See Also