From Xojo Documentation
Call to save changes to the current row in the RowSet.
If the row could not be saved, a DatabaseException is raised. Always call SaveRow inside a Try-Catch where you check for a DatabaseException. You can display the error message from the DatabaseException's Error and/or Message properties.
Some databases do not allow you to save if the SQL statement used to get the RowSet contains more than one table. Additionally, some databases may require that the SQL statement specifically include the Primary Key for the table.
Saving with MySQL
MySQL cannot guarantee the contents of a RowSet after issuing an SaveRow call (after having previously called EditRow). This means you should not try to modify the contents of a RowSet in a loop. Instead, use a separate Database.SelectSQL call to get the single Row you wish to change.
Set the string value of a column in a RowSet: