Page 1 of 1

dbMonitor select queries show "0 rows affected"

Posted: Sun 11 Jul 2010 02:00
by Wade
dbMonitor 3.0.2 with dbxida, FB2.5RC2, Delphi2009

For select queries, dbMonitor shows the SQL, and reports "-- 0 row(s) affected.". While no rows were updated, inserted or deleted, so technically it is correct, the result would be significantly more useful if it reported the number of rows returned by the select statement.

Posted: Mon 19 Jul 2010 11:13
by Dimon
dbMonitor shows the result of executing a SQL query that can be different and therefore can change table data. Also dbMonitor gets the result of execution immediately after getting the result from server and before fetching recorset, therefore it can't report returned row count.