IsEndOfData (ODBCResultSet - LotusScript)
Indicates whether the cursor position is at the end of the result set.
Defined in
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.
Usage
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 Errors
Out of memory (DBstsMEMF)