dbMonitor select queries show "0 rows affected"

Wade · Post by **Wade** » Sun 11 Jul 2010 02:00

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.

Dimon · Post by **Dimon** » Mon 19 Jul 2010 11:13

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.