[Gambas-user] How to get the number of affected rows in mysql?

[Zach Smith]

Hi,

How can one get the number of affected rows from a mysql query in gambas?

See https://dev.mysql.com/doc/refman/5.1/en/mysql-affected-rows.html
"It returns the number of rows changed, deleted, or inserted by the
last statement if it was an UPDATE, DELETE, or INSERT"

I've experimented with running SELECT ROW_COUNT() after an update
query but I am unable to get a result that is the number of rows
changed.

See https://dev.mysql.com/doc/refman/5.1/en/information-functions.html#function_row-count

Thanks,
Zach