qsqlquery UPDATE how to?

[ChrisW67]

As Mardi's example shows,

query.prepare("UPDATE SET clients ClientName=:name, ClientCity=:city, ClientAddress=:address, ClientMol=:mol, ClientEik=:eik, ClientVat=:vat, ClientTel=:tel, ClientMail=:mail WHERE ROWID=:rowid");

query.prepare("UPDATE SET clients ClientName=:name, ClientCity=:city, ClientAddress=:address, ClientMol=:mol, ClientEik=:eik, ClientVat=:vat, ClientTel=:tel, ClientMail=:mail WHERE ROWID=:rowid");

To copy to clipboard, switch view to plain text mode 

is not a valid SQL statement, it should read :

UPDATE clients SET ...

UPDATE clients SET ...

To copy to clipboard, switch view to plain text mode 

Do NOT build SQL by pasting strings as Mardi suggests. Using bindValue() is, by far, the better and safer option.