MySQL Forums
Forum List  »  Sybase

Re: Getting updated rowcount in Powerbuilder
Posted by: Peter Piechutzki
Date: September 29, 2009 08:17AM

In MySql Query Browser issuing follwoing statements
SELECT * FROM K_ORT;
//status line: 21 rows returned in nnn secs //
SELECT ROW_COUNT();
//status line: 1 row returned in nnn secs //
## Result set: -1 ##

UPDATE K_ORT SET BEZEICHNUNG = 'munich' WHERE NUMMER = 1;
//status line: 1 row affected, no result set //
SELECT ROW_COUNT();
//status line: 1 row returned in nnn secs //
## Result set: -1 ##

why is row_count() function allways returning -1 ???

tested on local connection and network connection.
mysql query browser 1.2.12
mysql server 5.0.51b-community-nt via TCP/IP
storage engine INNODB

is there another way of retrieving the affected rows after update/insert/delete using ansi standard sql?

any help appreciated

regards

Peter

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Getting updated rowcount in Powerbuilder
5283
September 29, 2009 08:17AM


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.