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