[Qt-interest] QSqlQuery::numRowsAffected

Rick Vernam rickv at hobi.com
Mon Jun 22 22:20:04 CEST 2009


I have very simple update query, which also returns data.
In Postgres' psql, I run:
update sometable set somefield = somevalue where somecriteria=whatever 
returning someothervalue;

When I run this query via the QPSQL driver, sometable.somefield is indeed 
updated to somevalue, however QSqlQuery::numRowsAffected returns zero.

If I run the query without the returning clause, then I get a valid result 
from QSqlQuery::numRowsAffected.

So is this the expected behavior?

Thanks,
-Rick



More information about the Qt-interest-old mailing list