MySQL Forums
Forum List  »  Sybase

Re: Getting updated rowcount in Powerbuilder
Posted by: Shawn Pleska
Date: August 16, 2009 05:57PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Getting updated rowcount in Powerbuilder
5497
August 16, 2009 05:57PM


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.