From Xojo Documentation

You are currently browsing the old Xojo documentation site. Please visit the new Xojo documentation site!

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.


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