SQLNumRows() function

The SQLNumRows() function indicates how many rows met the criteria specified in the last SQLSelect() function. For example, if a WhereExpr argument is used to select all rows with a column name AGE, where AGE is equal to 45, the number of rows returned could be 40 or 4000. This may determine which function is processed next.

Category

SQL

Syntax

SQLNumRows(ConnectionID);

Argument

ConnectionID

Name of a memory integer tag that holds the number (ID) assigned by the SQLConnect() function to each database connection.

Example

The following statement returns the number of rows selected to the NumRows integer tag:

NumRows=SQLNumRows(ConnectionID);

See Also

SQLConnect()