Firebird Documentation IndexFirebird 2.5 Language Ref. UpdateContext variables → ROW_COUNT
Firebird Home Firebird Home Prev: OLDFirebird Documentation IndexUp: Context variablesNext: SQLCODE

ROW_COUNT

Available in: PSQL

Added in: 1.5

Changed in: 2.0

Description: The ROW_COUNT context variable contains the number of rows affected by the most recent DML statement (INSERT, UPDATE, DELETE, SELECT or FETCH) in the current trigger, stored procedure or executable block.

Type: INTEGER

Example: 

update Figures set Number = 0 where id = :id;
if (row_count = 0) then
  insert into Figures (id, Number) values (:id, 0);

Behaviour with SELECT and FETCH

Note

ROW_COUNT cannot be used to determine the number of rows affected by an EXECUTE STATEMENT or EXECUTE PROCEDURE command.

Prev: OLDFirebird Documentation IndexUp: Context variablesNext: SQLCODE
Firebird Documentation IndexFirebird 2.5 Language Ref. UpdateContext variables → ROW_COUNT