Indicates whether the cursor position is at the end of the result set.

Defined in

ODBCResultSet

Syntax

flag% = odbcResultSet.IsEndOfData

Return value

• True indicates that the cursor is on the last record, or the result set has 0 rows.
• False indicates that the cursor is not on the last record.

When IsEndOfData returns True, it could mean that the result set is empty. If you do not know whether any rows were returned from your query, use the IsResultSetAvailable method to test whether data is available before using methods that assume data is present.

Use IsEndOfData in a loop structure when you want to step through rows to the end of the result set. Start the loop with NextRow and then process the row. The first NextRow after an Execute positions you on the first row.

Do
 result.NextRow
 'Process each row
Loop Until res.IsEndOfData

Out of memory (DBstsMEMF)

Example
See Also

IsResultSetAvailable method
LastRow method

Glossary