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
Bookmarks