Using bound values in insert gives "parameter count mismatch" error in SQLite

[remy_david]

I had a similar problem leading to "parameter count mismatch" error.
I was trying to bind the table name like:

QSqlQuery q;
q.prepare("SELECT * FROM :table");
q.bind(":table", "myTable");
q.exec();

QSqlQuery q;
q.prepare("SELECT * FROM :table");
q.bind(":table", "myTable");
q.exec();

To copy to clipboard, switch view to plain text mode 

This is not possible, one can only bind filed values.
Could be useful for future readers.