Xojo Documentation Xojo Documentation

Method

MySQLCommunityServer.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 ExecuteSQL statement.

Example

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

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