How to get the return value of a 'returning clause' using PostgreSQL?

[gboelter]

Good afternoon!

Using PostgreSQL my query looks like this:

UPDATE nummernkreise SET wert = wert+1 WHERE name = 'Angebot' RETURNING wert;

UPDATE nummernkreise SET wert = wert+1 WHERE name = 'Angebot' RETURNING wert;

To copy to clipboard, switch view to plain text mode 

The query returns the updated value of 'wert'.

In Qt (4.8.4) I have tried

query.prepare( "UPDATE nummernkreise SET wert = wert+1 WHERE name = :Name RETURNING wert" );
query.bindValue( ":Name", m_form );
query.exec();

query.prepare( "UPDATE nummernkreise SET wert = wert+1 WHERE name = :Name RETURNING wert" );
query.bindValue( ":Name", m_form );
query.exec();

To copy to clipboard, switch view to plain text mode 

Any idea how to get the updated content of 'wert' returned by this query?

Guenther

[Lesiok]

Read carefully about QSqlQuery::bindValue. It have 3 parameters.

[gboelter]

Read carefully about QSqlQuery::bindValue. It have 3 parameters.

Thanks Lesiok,

I have never recogniced the third parameter of QSqlQuery::bindValue, but now it's working.

Regards

Guenther