MSSQLServerDatabase.AffectedRowCount

From Xojo Documentation

Method

MSSQLServerDatabase.AffectedRowCount() As UInt64

New in 2019r2

Supported for all project types and targets.

Returns the number of rows that were modified by the most recent SQL statement passed to ExecuteSQL.

Example

// db is a previously connected MSSQLServerDatabase
db.ExecuteSQL("UPDATE Team SET City = 'Boston' Where Coach = 'Bob Roberts'")
Var changeCount As UInt64
changeCount = db.AffectedRowCount