dbMonitor select queries show "0 rows affected"

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for InterBase & Firebird in Delphi and C++Builder
Post Reply
Posts: 31
Joined: Sun 03 Jan 2010 06:04

dbMonitor select queries show "0 rows affected"

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.

Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

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.

Post Reply