View Full Version : QTableview, checkboxes and SQlite

22nd May 2014, 21:02
Hello to each and everyone, I'm trying to put in a tableview a checkbox which should be linked to a value in the db of SQlite, the program select first a query and insert data into the table but I want to add a column with a checkbox for each record found in the db. How can i add it to the QSqlQueryModel and Qtableview already created by QTcreator?
Thank you so much

This is my code:

void myClass::on_pushButton_clicked()
Widget conn;
QSqlQueryModel * model = new QSqlQueryModel();
QSqlQuery* qry = new QSqlQuery(conn.db);
qry->prepare("select * from plan where username='"+username_temp+"'");
QTextStream (stdout) << qry->lastQuery();



qDebug() << (model->rowCount());

23rd May 2014, 09:18
You have to create your own data model inheriting from QSqlTableModel.
Reimplement flags() method and use Qt::ItemIsUserCheckable for the column with the checkbox.
Reimplement data() and setData() to manage the role Qt::CheckStateRole properly for the column with the checkbox.

25th May 2014, 20:59
Ok, I'm trying to do that, I have the delegate but I don't know how to link with the database. Can you give me an example?

25th May 2014, 22:52
nix suggested to create a subclass of the model you are currently using, so that you can either make one of the existing columns checkable or add a column.
Another option is to use a proxy model.

Delegate has nothing to do with that.