Important: Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

[Solved] Problem with UPDATE query (QSQLITE)



  • Hi,
    This is my code:
    @
    reference=ui->reference->text();
    pseudo=ui->label_3->text();
    QSqlQuery qry("QSQLITE");
    qry.prepare("UPDATE candidates SET reference= :areference WHERE pseudo= :apseudo;");
    qry.bindValue(":areference",reference);
    qry.bindValue(":apseudo",pseudo);
    if (!qry.exec())
    {
    qDebug() << qry.lastError();
    qDebug()<< qry.executedQuery();
    }
    @

    When running, I get these messages:

    *QSqlError("", "Parameter count mismatch", "")
    "UPDATE candidates SET reference= ? WHERE pseudo= ?;" *

    Can someone help me and thank you.



  • Sorry but I have changed reference into reference_entreprise and I have forgotten it.That's why it shows me this problem.
    Now the program works correctly.


Log in to reply