Subject How to get the number of rows affected by the execution of an stored procedure ??
Author Carlos Guzman Alvarez
Hello:

There are any way for known the number of rows deleted, inserted or
updated by the execution of an stored procedure using firebird-api, i
need this for the .NET Data Provider ( isc_dsql_info_sql doesn't work in
this case returns always 0 ), an example:


CREATE PROCEDURE SP_DELETE_USERS(
IDUSER INTEGER)
AS
BEGIN
DELETE FROM USERS WHERE ID = :IDUSER;
END

I want to know the number of rows affected by the DELETE statement.


--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain


P.S.: I have sent this question to the firebird-devel list but nobody
has answered this question :(