Re: Getting updated rowcount in Powerbuilder

[Peter Piechutzki]

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