PdcDBQuery.Execute - Revision history

TC at 13:17, 30 May 2018

2018-05-30T13:17:00Z

← Older revision		Revision as of 13:17, 30 May 2018
Line 14:		Line 14:
	Sub sExecuteQuery		Sub sExecuteQuery
	dim objQuery		dim objQuery
	~~dim intCnt~~

	set objQuery = pdc.Database.OpenQuery(pdcConData)		set objQuery = pdc.Database.OpenQuery(pdcConData)
Line 22:		Line 21:

	else		else
	msgbox "Error:" & vbCrLf & pdc.LastError & vbCrLf & vbCrLf & "SQL:" & vbCrLf & ~~qryCustomer~~.SQL		msgbox "Error:" & vbCrLf & pdc.LastError & vbCrLf & vbCrLf & "SQL:" & vbCrLf & objQuery.SQL
	end if		end if
	End Sub		End Sub

Mike at 12:47, 31 July 2013

2013-07-31T12:47:48Z

← Older revision		Revision as of 12:47, 31 July 2013
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
			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
	</source>		</source>

	== Availability ==		== Availability ==
	Available since September 2008 (from version 3.8)		Available since September 2008 (from version 3.8)

Mike: 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..."

2012-05-21T12:37:17Z

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..."

New page

== 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 ==

<source lang="vb">

</source>

== Availability ==
Available since September 2008 (from version 3.8)