Count

This function will return the number of rows contained in a specified rows item returned from the DB.Execute function or any Dynamic Array.

Group: Database Related Extensions

Syntax: vNbr = DB.Count(sRows)

vNbr (Variant) is the number of rows contained in the Records item.

sRows (String) is the string representation of a static recordset generated by a SQL statement using the DB.Execute function.

Example:

Dim sSQL As String

Dim sCols As String

Dim sRows As String

Dim iNbr As Integer

sSQL = "select * from ItemMaster"

DB.Execute(sSQL, sCols, sRows)

iNbr = DB.Count(sRows)