Icon RowsAffected Property

property RowsAffected: Integer

Usage

Use the RowsAffected property to determine how many rows were inserted, updated or deleted by the execution of the current SQL statement specified via the SQL property. If RowsAffected is 0, the SQL statement did not insert, update or delete any rows.

Information This property is only useful for INSERT, UPDATE, or DELETE SQL statements and will always be equal to the RecordCount property for any SELECT SQL statement that returns a result set.
Image