TPSQLDirectQuery.Properties.Bof

Indicates whether or not a cursor is positioned at the first record in a dataset.

Syntax:

property Bof : boolean;

Description:

Examine Bof (beginning-of-file) to determine if the cursor is positioned at the first record in a dataset. If Bof is True, the cursor is unequivocally on the first row in the dataset.

Bof is True when an application:

Opens an empty dataset.
Calls a dataset's First() method.
Call a dataset's Prior() method, and the method fails (because the cursor is already on the first row in the dataset).

Bof is False in all other cases.

If both Eof and Bof are True, the dataset is empty.