Returns the number of rows operated upon by the latest query execution.

Syntax:

property RowsAffected: Integer;

Description:

Inspect RowsAffected to determine how many rows were updated or deleted by the last query operation. If no rows were updated or deleted, RowsAffected has a value of zero. RowsAffected will have a value of -1 if the execution of the SQL statement could not be executed due to an error condition. This latter situation would typically follow the raising of an exception.