NextRow (ODBCResultSet - LotusScript)
Sets the current row position to the next row in a result set.
Defined in
Syntax
status = odbcResultSet . NextRow
Return value
status
Boolean. Returns True if the next row in the result set is successfully retrieved; otherwise, returns False, indicating an error.
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