Paul,

Thanks for your help.

Andrew

Paul Reeves wrote:

> Andrew Guts wrote:
> >
> > Hello.
> >
> > How to get number of affected rows if using
> > isc_dsql_execute_immediate() or isc_dsql_exec_immed2()?
> >
>
> The solution lies in calling isc_dsql_sql_info. See the manual for an example
> of the call. ibase.h has the constants you need to test for. In this case you
> need to pass isc_info_sql_records in the *items parameter. The result buffer
> has a series of three pieces of information - a constant representing the type
> of information returned, the length of the value to come and the value itself.
>
> If that isn't enough to get you going ask again.
>
> Paul
> --
>
> Paul Reeves
> http://www.ibphoenix.com
> taking InterBase further