Help Center
/
Help Center›AfxNova›CODBCStmt Class

CODBCStmt.RecordCountmethod

Gets the number of records in the result set.

DatabasesmethodCODBCStmt.incdocumented

Syntax

FUNCTION RecordCount (BYREF wszSqlStr AS WSTRING) AS LONG

Parameters

NameDescription
wszSqlStrSQL string.
Uses an instruction like SqlStr = "SELECT COUNT(\*) FROM Customers".
This is a know workaround to get the number of records in a result set by using the same SELECT clause that will be used to open the result set but adding the COUNT function.

Return value

The number of records in the result set.

Description

Gets the number of records in the result set.

Reference

  • Include file CODBCStmt.inc
  • Defined in AfxNova/COdbcStmt.inc:122
  • Documented in Databases/ODBC Classes/CODBCStmt Class.md
  • Topic: CODBCStmt Class