Xojo Documentation Xojo Documentation

Method

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

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

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