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

------------------------------------------------------------------------------
This SF.net email is sponsored by Windows:

Build for Windows Store.

http://p.sf.net/sfu/windows-dev2dev
_______________________________________________
Gambas-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/gambas-user

Reply via email to