Adding values into a table - "Parameter count mismatch" error in SQLite

[jefftee]

No problem, glad to help. I did want to mention that if you are going to use named query parameters, the bindValue is just the parameter name. In your example, you have " = " as part of the parameter name, it should be something like:

query.prepare("INSERT INTO users (user_id,name,reg_date,designation,password ) VALUES (:user_id,:name,:reg_date,:designation,:password)");
 
query.bindValue(":user_id", id_s );
query.bindValue(":name", ui6->lineEdit->displayText());
query.bindValue(":reg_date",QDate::currentDate().toString("dd-MM-yyyy") );
query.bindValue(":designation", ui6->comboBox->currentText());
query.bindValue(":password", id_s );
query.exec();

query.prepare("INSERT INTO users (user_id,name,reg_date,designation,password ) VALUES (:user_id,:name,:reg_date,:designation,:password)");

query.bindValue(":user_id", id_s );
query.bindValue(":name", ui6->lineEdit->displayText());
query.bindValue(":reg_date",QDate::currentDate().toString("dd-MM-yyyy") );
query.bindValue(":designation", ui6->comboBox->currentText());
query.bindValue(":password", id_s );
query.exec();

To copy to clipboard, switch view to plain text mode