I have tried this even before you write me:
query.prepare("UPDATE clients ( ClientName, ClientCity, ClientAddress, ClientMol, ClientEik, ClientVat, ClientTel, ClientMail) WHERE (ROWID)"
"VALUES (:name, :address, :mol, :eik, :vat, :tel, :mail, :rowid)");
query.bindValue(":name", ui->lineEdit_name->text());
query.bindValue(":address", ui->lineEdit_city->text());
query.bindValue(":mol", ui->lineEdit_address->text());
query.bindValue(":eik", ui->lineEdit_mol->text());
query.bindValue(":vat", ui->lineEdit_eik->text());
query.bindValue(":tel", ui->lineEdit_vat->text());
query.bindValue(":mail", ui->lineEdit_tel->text());
query.
bindValue(":rowid",
QString::number(rowid
));
query.exec()
QSqlQuery query;
query.prepare("UPDATE clients ( ClientName, ClientCity, ClientAddress, ClientMol, ClientEik, ClientVat, ClientTel, ClientMail) WHERE (ROWID)"
"VALUES (:name, :address, :mol, :eik, :vat, :tel, :mail, :rowid)");
query.bindValue(":name", ui->lineEdit_name->text());
query.bindValue(":address", ui->lineEdit_city->text());
query.bindValue(":mol", ui->lineEdit_address->text());
query.bindValue(":eik", ui->lineEdit_mol->text());
query.bindValue(":vat", ui->lineEdit_eik->text());
query.bindValue(":tel", ui->lineEdit_vat->text());
query.bindValue(":mail", ui->lineEdit_tel->text());
query.bindValue(":rowid", QString::number(rowid));
query.exec()
To copy to clipboard, switch view to plain text mode
AND ALSO THIS:
query.prepare("UPDATE clients ClientName=:name, ClientCity=:city, ClientAddress=:address, ClientMol=:mol, ClientEik=:eik, ClientVat=:vat, ClientTel=:tel, ClientMail=:mail WHERE ROWID=:rowid");
query.bindValue(":name", ui->lineEdit_name->text());
query.bindValue(":address", ui->lineEdit_city->text());
query.bindValue(":mol", ui->lineEdit_address->text());
query.bindValue(":eik", ui->lineEdit_mol->text());
query.bindValue(":vat", ui->lineEdit_eik->text());
query.bindValue(":tel", ui->lineEdit_vat->text());
query.bindValue(":mail", ui->lineEdit_tel->text());
query.
bindValue(":rowid",
QString::number(rowid
));
query.exec();
QSqlQuery query;
query.prepare("UPDATE clients ClientName=:name, ClientCity=:city, ClientAddress=:address, ClientMol=:mol, ClientEik=:eik, ClientVat=:vat, ClientTel=:tel, ClientMail=:mail WHERE ROWID=:rowid");
query.bindValue(":name", ui->lineEdit_name->text());
query.bindValue(":address", ui->lineEdit_city->text());
query.bindValue(":mol", ui->lineEdit_address->text());
query.bindValue(":eik", ui->lineEdit_mol->text());
query.bindValue(":vat", ui->lineEdit_eik->text());
query.bindValue(":tel", ui->lineEdit_vat->text());
query.bindValue(":mail", ui->lineEdit_tel->text());
query.bindValue(":rowid", QString::number(rowid));
query.exec();
To copy to clipboard, switch view to plain text mode
It's all about this WHERE statement.How to handle it?To put it in parenthesis or not?To stay after VALUES or not?
Added after 12 minutes:
Problem SOLVED!!!
There should be a SET after UPDATE in the query!
Bookmarks