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.

(missing or bad snippet)

(missing or bad snippet) 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.

(missing or bad snippet)

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)

Version Supported: RFgen 4.0 and newer.