PdcDBQuery.BoF

Declaration

Bof as Boolean

Description

Returns true or false wheter the recordpointer is at the first record of the query

Notes

This property returns wheter or not the begin of file is reached.

Code example

This code example executes a SQL statement and shows a msgbox if the pointer is at the first record.

Sub sExecuteQuery
dim objQuery
dim intCnt

  set objQuery = pdc.Database.OpenQuery(pdcConData)
  objQuery.SQL = "SELECT * FROM LK_KLANT"

  if objQuery.Execute then
    if objQuery.BoF then
      msgbox "The pointer is at the first record of the query."
    end if
  else
    msgbox "Error:" & vbCrLf & pdc.LastError & vbCrLf & vbCrLf & "SQL:" & vbCrLf & qryCustomer.SQL
  end if
End Sub

Availability

Available since September 2008 (from version 3.8)