Method

MSSQLServerDatabase.GetAffectedRows


Warning

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

Description

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

Sample code

' 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.