Re: Getting updated rowcount in Powerbuilder
I know the updated rowcount value is available somewhere, but finding it has been elusive. I tried another route to see if I can get the information I need elsewhere. A function that I found: SELECT ROW_COUNT() seemed to be an option. After I issued an update of any number of rows (one time 0, another time 1, another time 3, etc) I tried running this SQL immediately after the update command BUT every time I do the value returned is -1. Does anyone know why SELECT ROW_COUNT() would always be returning a value of -1? I'm using MySQL 5.1 on Windows to do my testing.
Regards,
Shawn
Subject
Views
Written By
Posted
11969
August 16, 2009 12:13PM
Re: Getting updated rowcount in Powerbuilder
6042
August 16, 2009 05:57PM
5535
September 29, 2009 06:18AM
5798
September 29, 2009 08:17AM
8864
September 29, 2009 02:45PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.