Sets the current row to the first row in a result set. Equivalent to setting CurrentRow to 1.

Defined in

ODBCResultSet

Syntax

status = odbcResultSet. FirstRow

Return value

status

Boolean. Returns True if successful; otherwise, returns False, indicating an error.

FirstRow is useful to prepare for another pass through the result set, as when using LocateRow interactively.

You may not be able to move to the first row unless you enabled caching of all rows. If FirstRow fails, use GetError to examine the meaning.

"Invalid row number" can occur if the result set has 0 rows.

Errors

Cannot access requested row (DBstsCARR)

Invalid row number (DBstsINVR)

Events

BeforeFirstRow

AfterFirstRow

BeforeRowPositionChange

AfterRowPositionChange

Example
See Also

CurrentRow property
IsBeginOfData method
LastRow method
LocateRow method
NextRow method
NumRows method
PrevRow method

Glossary