Purpose
Returns the current value of the end of file (EOF) flag.
When the program attempts to move the record pointer off the end of the result set, the EOF flag is set to TRUE and the record pointer is positioned at the last record in the result set.
Note
It is not possible to move completely off the end of the result set; the rowset buffers will always be associated with a row if there are rows in the result set.
EOF returns FALSE if the record pointer has been successfully moved to a new record in the result set. If the record set is empty, BOF and EOF always return TRUE.
Syntax
DBStatement.EOF
Compliance:
Core level
Example
The following example displays all contact names from a database from the first record to the last.
Sub DisplayContactNames(Contact as DBStatement)
Contact.MoveFirst
Do While Not Contact.EOF
Print "Contact name:"; Contact.Column("name")
Contact.MoveNext
Loop
End Sub
|