ValidRecords

Syntax

SQL.ValidRecords(recSet[, IgnoreEOF])

Description

Checks if the specified recordset object is valid and (optionally) if there are any records in the object.

Parameter	Description
Recset	A reference to a Recordset object (ADODB).
IgnoreEOF	Optional. If TRUE, no check will occur on the recordset object regarding the existence of rows inside of the object.

See Also

andere SQL.RunQueryxxxxxxxx functies.

Example

Sub Main

Dim sQuery As String, rs as ADODB.Recordset

sQuery = "Select Bedrijfsnaam, Adres, Postcode, Woonplaats From Klanten WHERE Code = '$KDE##@@#'" 'causes invalid recordset

SQL.RunRecordset sQuery, rs

Debug.Print SQL.ValidRecords(rs)

End Sub