With this code i got "Success!" but nothing happens again!
In accordance with sqlite documentation ROWID should be a int.
Qt Code: 
  1. QSqlQuery query;
  2.         query.prepare("UPDATE clients SET ClientName=:name, ClientCity=:city, ClientAddress=:address, ClientMol=:mol, ClientEik=:eik, ClientVat=:vat, ClientTel=:tel, ClientMail=:mail WHERE ROWID=:rowid");
  3.         query.bindValue(":name", ui->lineEdit_name->text());
  4.         query.bindValue(":city", ui->lineEdit_city->text());
  5.         query.bindValue(":address", ui->lineEdit_address->text());
  6.         query.bindValue(":mol", ui->lineEdit_mol->text());
  7.         query.bindValue(":eik", ui->lineEdit_eik->text());
  8.         query.bindValue(":vat", ui->lineEdit_vat->text());
  9.         query.bindValue(":tel", ui->lineEdit_tel->text());
  10.         query.bindValue(":mail", ui->lineEdit_mail->text());
  11.         query.bindValue(":rowid", rowid);
  12.         if (query.exec())
  13.         {
  14.     emit updateTable();
  15.     QMessageBox::information(this,"", "Success!");
  16.         }
  17.         else
  18.         {
  19.     QMessageBox::information(this,"", query.lastError().text());
  20.  
  21.         }
  22.     this->close();
To copy to clipboard, switch view to plain text mode