Read-write. The number of the current row in a result set, starting from row 1.

Defined in

ODBCResultSet

Data type

Long

Syntax

row& = odbcResultSet.CurrentRow

odbcResultSet.CurrentRow = row&

Usage

The special value DB_ADDROW specifies that the current row is the AddRow workspace.

Setting the current row value is equivalent to positioning the cursor to that row and may require fetching records. Unless caching is enabled, it may not be possible to set the row at a location before the current row. Once the data has been fetched, setting the CurrentRow property to 0 raises error #545.

Errors

The result contains no data (DBstsNODA)

Cannot access requested row (DBstsCARR)

Cannot position at AddRow (DBstsCPAR)

Invalid row number (DBstsINVR)

The row has previously been deleted (DBstsROWD)

Events

AfterCurrentRow

AfterRowPositionChange

BeforeCurrentRow

BeforeRowPositionChange

Example
See Also

AddRow method
Connection property (in ODBCQuery)
LastRow method
LocateRow method
NextRow method
NumRows method
PrevRow method

Glossary