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.