Subject Re: [firebird-support] Counting rows affected by UPDATE/INSERT/DELETE queries
Author Martijn Tonies
Hi Scott,

> From the C API whats the best was to find out how many records have
> been affected by an UPDATE, INSERT or DELETE query?
> The only solution I can work out so far, is to use the isc_database_info
> function to retive the isc_info_insert_count, isc_info_update_count and
> isc_info_delete_count before and after the query is run and find the
> diffrence.
> Is their a better, more direct way to do this?

Use isc_dsql_sql_info (with isc_info_sql_records as request).

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions