MSSQLServerDatabase.GetAffectedRows

From Xojo Documentation

Method

MSSQLServerDatabase.GetAffectedRows() As UInt64

Supported for all project types and targets.

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

Example

// 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