RecordSet.BOF
From Xojo Documentation
 |
This item was deprecated in version 2019r2. Please use RowSet.BeforeFirstRow as a replacement. |
Read-Only Property (As Boolean )
Returns True when the RecordSet is before the first row or the RecordSet is empty.
Notes
A new RecordSet is always at the first row (if any rows were returned). The only way to set the RecordSet to be before the first row is to use RecordSet.MovePrevious, which is not supported by all data sources.
Example
This moves the RecordSet pointer so that BOF is True:
Dim rs As RecordSet
rs = db.SQLSelect("SELECT * FROM data")
If rs <> Nil Then
rs.MovePrevious
If rs.BOF Then MsgBox("BOF!")
End If
rs = db.SQLSelect("SELECT * FROM data")
If rs <> Nil Then
rs.MovePrevious
If rs.BOF Then MsgBox("BOF!")
End If