Positions the current row pointer at the previous row.

Defined in

ODBCResultSet

Syntax

status = odbcResultSet.PrevRow

Return value

status

Boolean. Returns True if the pointer is successfully set to the previous row; otherwise, returns False, indicating an error.

The previous row is not accessible if the pointer is already at the first row; a result set is not cached; the current row is the AddRow workspace; or the cache is limited, and the previous row was flushed from the cache.

Errors

Invalid row number (DBstsINVR)

Cannot access requested row (DBstsCARR)

Events

BeforePrevRow

AfterPrevRow

BeforeRowPositionChange

AfterRowPositionChange

Example
See Also

CurrentRow property
FirstRow method
IsBeginOfData method
LastRow method
LocateRow method
NextRow method

Glossary