PdcDBQuery.Execute

Declaration

Execute as Boolean

Description

Executes the SQL statement

Notes

This methos will execute the provided SQL statement. There is no difference between a SELECT-statement and other statements.

Code example

This code example executes a SQL statement.

Sub sExecuteQuery
dim objQuery
dim intCnt

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

  if objQuery.Execute then

  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)