PdcDBQuery.PriorRecord

Declaration

PriorRecord

Description

Moves the record to the previous record

Notes

This method will move the record pointer to the previous record in the created query.

Code example

This code example executes a SQL statement and moves the pointer to the previous record.

Sub sExecuteQuery
dim objQuery
dim intCnt

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

  if objQuery.Execute then
    objQuery.PriorRecord
  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)