"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.


Dmitry