Subject | How to get the number of rows affected by the execution of an stored procedure ?? |
---|---|
Author | Carlos Guzman Alvarez |
Post date | 2003-09-25T13:00:41Z |
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 :(
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 :(