Used to indicate the number of rows which were inserted, updated, or deleted during the last query operation.
property RowsAffected: integer;
Check RowsAffected to determine how many rows were inserted, updated, or deleted during the last query operation. If RowsAffected is -1, the query has not inserted, updated, or deleted any rows.
For correct initializing this property you should explicitly prepare SQL as it is shown in the example below.
IBCSQL.SQL.Text := 'Update Employee set salary = :sal where emp_no = :no'; IBCSQL.Prepare; IBCSQL.Execute; AffRows := IBSQL.RowsAffected; IBCSQL.Unprepare;