qt sqlite3 delete Parameter count mismatch




先prepare,再bindvalue ,再exec执行。我的实现就是没有按照这个顺序,所以出现这个错误。



7down votefavorite

I'm working with SQLite, doing insert into table. Folowwing

QSqlQuery testQuery(QString("INSERT INTO test(testcol) VALUES(?)"));
testQuery.bindValue(0, someQStringObg);

works, but

QSqlQuery testQuery(QString("INSERT INTO test(testcol) VALUES(:val)"));
testQuery.bindValue(":val", someQStringObg);

don't. testQuery.lastError().text() returns No query Unable to fetch row

Have no clue why things are that way, but really want to find out.


Which sql type and version are you using? Which Qt version? Which OS, which version? Have you tried explicit .prepate() call to see the return value? Also, it is strange that you mix the "?" and ":" approaches, though that should not matter. – lpapp Dec 26 '13 at 14:11 


Try to print out the last query with this: qDebug () << query->lastQuery() just to make sure. What does that print out? Also, could you please check if the table exists properly before the insertion of the second case? You could use a command line client for double checking this. – lpapp Dec 26 '13 at 14:20 


@LaszloPapp with prepare everything works! Thanks! – user3136871 Dec 26 '13 at 14:29


OK, great. Submitted an answer for better readability. – lpapp Dec 26 '13 at 14:30

add a comment


1 Answer



up vote7down voteaccepted

Please use prepare as the official example:

QSqlQuery testQuery;
testQuery.prepare("INSERT INTO test(testcol) VALUES(:val)");
testQuery.bindValue(":val", someQStringObj);

The reason for the error is that the query was executed before binding to the corresponding placeholder. You can see the relevant part of the constructor documentation:

If query is not an empty string, it will be executed.

shareimprove this answer