dbMonitor select queries show "0 rows affected"

dbMonitor select queries show "0 rows affected"

Postby 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.
Wade
 
Posts: 31
Joined: Sun 03 Jan 2010 06:04

Postby 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.
Dimon
Devart Team
 
Posts: 2885
Joined: Mon 05 Mar 2007 16:32


Return to dbExpress driver for InterBase & Firebird