Subject | Re: [firebird-support] return the number of records affected |
---|---|
Author | Ismael L. Donis García |
Post date | 2010-02-18T13:44:20Z |
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 ¦¦
=========
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]