dbQueryGetNumRowsAffected¶
Purpose¶
Reports the number of rows affected by the result’s SQL statement.
Format¶
-
num_rows =
dbQueryGetNumRowsAffected
(qid)¶ - Parameters:
qid (scalar) – query number.
- Returns:
num_rows (scalar) – the number of rows affected by the result’s SQL statement, or a -1 if it cannot be determined or the query is not active.
Examples¶
// Create and prepare query
qid = dbCreateQuery(db_id, "INSERT INTO
PEOPLE (fname, lname) VALUES
('John', 'Doe');");
// Print report of number of rows affected
print dbQueryGetNumRowsAffected(qid) " row(s) were affected";
1 row(s) were affected
Remarks¶
Note that for SELECT
statements, the value is undefined; use dbQueryRows()
instead.
See also
Functions dbQueryRows()
, dbHasFeature()