SQLite and QSqlQuery "Parameter count mismatch" Error

Christian Ehrlicher

What Qt version do you use?
Please check the return values of query.prepare() and bindValue(). Also re-write your query to UPATE summary_payment SET product_name = :product_name, price = :price WHERE id = :id

ppitu

I am using Qt 1.15.1
I re-write this line but i have still this problem.
And i check the lastError():
Parameter count mismatch"
And lastQuery():
UPDATE summary_payment SET product_name = :product_name, price = :price WHERE id = :id

JonB

@ppitu
In addition to @Christian-Ehrlicher 's correction to your syntax.

SQLite apparently returns "Parameter count mismatch" for "almost any" error :)

JonB

@ppitu
What did you do about @Christian-Ehrlicher's

Please check the return values of query.prepare() and bindValue().

?

We do not know what is in your database. We don't know whether you have a table named summary_payment. We don't know whether it has the column names you specify. We don't know whether your code is supplying good values for these.

Christian Ehrlicher

This works fine for me:

QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.open();
QSqlQuery query(db);
query.exec("CREATE TABLE summary_payment (product_name text, price real, id primary key)");
query.prepare("UPDATE summary_payment SET product_name = :product_name, price = :price WHERE id = :id");
query.bindValue(":product_name", QLatin1String("product_name"));
query.bindValue(":price", 8);
query.bindValue(":id", 7);
if (!query.exec()) {
  qDebug() << query.lastError().databaseText() << query.lastError().driverText();
}

ppitu

https://github.com/ppitu/SummaryPaymentApp/blob/main/summary-payment-app/summary-payment-app-core/SummaryPaymentDao.cpp

Here is a link to the whole file.
I create the table the same as @Christian-Ehrlicher , and insert to database work correct i have a problem with update and remove

Christian Ehrlicher

Did you try my code? If so adjust yours until it's working as expected.

ppitu

@Christian-Ehrlicher i tried your code (in new project) and it worked fine.
But when i change code in my app I get this error: "" "Parameter count mismatch"

Christian Ehrlicher

Then simplify your code until it works or looks like mine to find your problem.

ppitu

Thanks for help, i found my mistake (in database in table summay_payment i have: summarypayment_id not id)

JonB

@ppitu
Which is why, as I suggested, we could not help you.....

You really ought take the time to find one of the various free off-line or on-line SQLite workbench tools available to test your queries outside of Qt while you develop them.