Subject Re: [firebird-support] Count number of rows affected by update
Author Dmitry Yemanov
"kapsee" <kapil.surlaker@...> wrote:
> After executing an update statement using isc_dsql_execute, how do I
> count the number of rows affected without making another roundtrip to
> firebird ? I am currently using isc_dsql_sql_info and this seems
> pretty expensive, so I think it's going to back to firebird server to
> get the information.

You're right. The only way (that I can think of) allowing you to avoid this
extra roundtrip is to use a stored procedure which performs an update and
returns the ROW_COUNT value.