Subject Re: [firebird-support] return the number of records affected
Author Ismael L. Donis García
Thank you very much, I thought that row_count was for the select.

Then can I do something like?

begin
insert into eadatge (entidad, eadp, proceso) values (:vch_entidad, :dat_eadp, :int_proceso) returning row_count into :int_reg;
suspend;
end

=========
¦¦ ISMAEL ¦¦
=========

----- Original Message -----
From: Dimitry Sibiryakov
To: firebird-support@yahoogroups.com
Sent: Wednesday, February 17, 2010 3:45 PM
Subject: Re: [firebird-support] return the number of records affected



17.02.2010 19:56, Ismael L. Donis García wrote:
> Is possible return the number of records affected by an operation of insert, update and delete of a stored procedure in FB 2.1.3?

In SP you can use ROW_COUNT. In client application you can use
appropriate method of access driver.

--
SY, SD.




[Non-text portions of this message have been removed]