[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