PdcDBQuery.RecordCount - Revision history

MKob: dim intCnt is absolutely useless for this function

2022-05-24T08:43:41Z

dim intCnt is absolutely useless for this function

← Older revision		Revision as of 08:43, 24 May 2022
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)

MKob: /* Code example */

2021-12-27T15:01:55Z

Code example

← Older revision		Revision as of 15:01, 27 December 2021
Line 22:		Line 22:
	msgbox objQuery.RecordCount		msgbox objQuery.RecordCount
	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:57, 31 July 2013

2013-07-31T12:57:43Z

← Older revision		Revision as of 12:57, 31 July 2013
Line 9:		Line 9:

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

	<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
			msgbox objQuery.RecordCount
			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 == RecordCount as VT_INT == Description == Returns the record count of the query == Notes == This method returns the total count of records in the created q..."

2012-05-21T12:40:16Z

Created page with "== Declaration == RecordCount as VT_INT == Description == Returns the record count of the query == Notes == This method returns the total count of records in the created q..."

New page

== Declaration ==
RecordCount as VT_INT

== Description ==
Returns the record count of the query

== Notes ==
This method returns the total count of records in the created query.

== Code example ==

<source lang="vb">

</source>

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