Yes and no. My experience with other databases are that each of the
following stmts reset the affected row counts:
update, insert, delete and select never generates any affected rows.

So a single "getAffectedRowCount() will return affected row count
without any specific knowledge of which affected row count stmt to return.

I guess it is just a different architecture/implementation. I am ok
with that. Just need to know the differences.

jml
--- In firebird-support@yahoogroups.com, "Dimitry Sibiryakov" <SD@...>
wrote:

>
> On 27 Apr 2006 at 17:52, Jeff Lynn wrote:
>
> >The only stme executed is SQL update, why did the select return a
> >count of 1?
>
> Because these counters are not counters of SQL statements. They are
> counters of real database operations. Isn't it obvious that the
> engine must read the record before updating it?..
>
> --
> SY, Dimitry Sibiryakov.
>