dbQueryRows#

Purpose#

Returns the size of the result (number of rows returned), or -1 if the size cannot be determined or if the database does not support reporting information about query sizes.

Format#

result_size = dbQueryRows(qid)#

Parameters:: qid (scalar) – query number.
Returns:: result_size (scalar) – number of rows in the current result set of the active query. If the number of rows cannot be determined a -1 is returned.

Examples#

// Given a table with US States.
qid = dbCreateQuery(db_id, "SELECT *
    FROM STATES");

count = dbQueryRows(qid); // count = 50

Remarks#

Note that if the query is not active or if the query is not a SELECT statement, a -1 is returned. These properties can be checked with dbQueryIsActive() or dbQueryIsSelect().