Arjan at 20:16, 11 September 2017

2017-09-11T20:16:48Z

← Older revision		Revision as of 20:16, 11 September 2017
Line 1:		Line 1:
	== Declaration ==		== Declaration ==
	AffectedRows as ~~VT_INT~~		AffectedRows as integer

	== Description ==		== Description ==

Arjan: Created page with "== Declaration == AffectedRows as VT_INT == Description == Returns the number of records that are affected by the query == Notes == This method returns the number of recor..."

2017-09-11T20:15:52Z

Created page with "== Declaration == AffectedRows as VT_INT == Description == Returns the number of records that are affected by the query == Notes == This method returns the number of recor..."

New page

== Declaration ==
AffectedRows as VT_INT

== Description ==
Returns the number of records that are affected by the query

== Notes ==
This method returns the number of records that are affected by the query .

== Code example ==
This code example executes a SQL statement and returns the AffectRows.

<source lang="vb">
Sub sExecuteQuery
dim objQuery
dim intCnt

set objQuery = pdc.Database.OpenQuery(pdcConData)
objQuery.SQL = "UPDATE LK_KLANT SET KL_USER1 = 'update' WHERE KL_PLAATS = 'Veenendaal'"

if objQuery.Execute then
msgbox objQuery.AffectedRows
else
msgbox "Error:" & vbCrLf & pdc.LastError & vbCrLf & vbCrLf & "SQL:" & vbCrLf & objQuery.SQL
end if
End Sub
</source>

== Availability ==
Available since September 2017(from version 5.3)

PdcDBQuery.AffectedRows - Revision history

Arjan at 20:16, 11 September 2017

Arjan: Created page with "== Declaration == AffectedRows as VT_INT == Description == Returns the number of records that are affected by the query == Notes == This method returns the number of recor..."