Method

MySQLCommunityServer.GetAffectedRows

---

Warning

This item was deprecated in version 2019r2. Please use MySQLCommunityServer.AffectedRowCount as a replacement.

Description

Returns the number of rows that were modified by the most recent SQLExecute statement.

Sample code

Get the number of rows that were changed by an UPDATE statement:

' db is a previously connected MSSQLServerDatabase
db.SQLExecute("UPDATE Team SET City = 'Boston' Where Coach = 'Bob Roberts'")
If Not db.Error Then
  Dim changeCount As UInt64
  changeCount = db.GetAffectedRows
End If

Compatibility

All project types on all supported operating systems.