| Firebird Documentation Index → Firebird 1.5 Language Ref. Update → Context variables → ROW_COUNT |
|
|
|
Available in: PSQL
Added in: 1.5
Description: The ROW_COUNT context variable contains the number of rows affected by the most recent DML statement (INSERT, UPDATE or DELETE) in the current trigger or stored procedure.
Type: INTEGER
Example:
update Figures set Number = 0 where id = :id; if (row_count = 0) then insert into Figures (id, Number) values (:id, 0);
For SELECT statements, ROW_COUNT currently returns 0.
ROW_COUNT cannot be used to determine the number of rows affected by an EXECUTE STATEMENT or EXECUTE PROCEDURE command.
|
| Firebird Documentation Index → Firebird 1.5 Language Ref. Update → Context variables → ROW_COUNT |