Returns the number of rows inserted into the table by the latest COPY execution.

Syntax:

property RowsAffected: Integer;

Description:

Inspect RowsAffected to determine how many rows were inserted by the last COPY operation. If no rows were affected 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 or if COPY TO was executed.

Example:

procedure TForm1.PSQLCopy1AfterCopyPut(Sender: TObject);
begin
  if PSQLCopy1.RowsAffected > -1 then
    ShowMessage(Format('%d rows were inserted', [PSQLCopy1.RowsAffected]));
end;