I want to update a record with this code.Unfortunately the record remains unchanged!
Qt Code:
  1. QString name=ui->lineEdit_name->text();
  2. QString city=ui->lineEdit_city->text();
  3.  
  4. QSqlQuery query;
  5. query.prepare("UPDATE clients ClientName="+name+", ClientCity="+city+"WHERE RAWID="+rowid);
  6. query.exec();
To copy to clipboard, switch view to plain text mode 

What is the reason?Where i make mistake?