User`s guide

7 Functions — Alphabetical List
7-198
rows
Return number of rows in fetched data set
Syntax
numrows = rows(curs)
Description
numrows = rows(curs) returns the number of rows in the fetched data set curs.
Examples
Return the Number of Rows in the Cursor
After executing an SQL statement, return the number of rows in the database cursor
object generated by fetch.
Establish connection conn to a MySQL database with user name username and
password pwd.
conn = database('MySQL','username','pwd');
Execute a SELECT query on the productTable for product numbers 1 through 5
inclusive.
curs = exec(conn,['select * from productTable'...
' where productNumber >= 1 and productNumber <= 5']);
exec returns the database cursor object curs.
Fetch the data in curs.
curs = fetch(curs);
The Data property of curs contains the fetched data from the SELECT query.