PdcDBQuery.Execute: Difference between revisions
Jump to navigation
Jump to search
Created page with "== Declaration == Execute as Boolean == Description == Executes the SQL statement == Notes == This methos will execute the provided SQL statement. There is no difference be..." |
No edit summary |
||
| (One intermediate revision by one other user not shown) | |||
| Line 9: | Line 9: | ||
== Code example == | == Code example == | ||
This code example executes a SQL statement. | |||
<source lang="vb"> | <source lang="vb"> | ||
Sub sExecuteQuery | |||
dim objQuery | |||
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 & objQuery.SQL | |||
end if | |||
End Sub | |||
</source> | </source> | ||
== Availability == | == Availability == | ||
Available since September 2008 (from version 3.8) | Available since September 2008 (from version 3.8) | ||
Latest revision as of 13:17, 30 May 2018
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
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 & objQuery.SQL
end if
End Sub
Availability
Available since September 2008 (from version 3.8)