QTableView with a checkbox

[wysota]

You're changing the model here which is... well... at least controversial when it comes to the MVC paradigm.

BTW. The model is to be editable so you should subclass QSqlTableModel and also reimplement setData(). Now imagine someone wants to have another view (or access the database through the model) without the checkboxes... Or the column might allow NULLs

Of course I don't say that you can't do it this way, I only say you should do it with a delegate, as you'll be modifying only the user interaction this way. I wrote about it earlier in the thread.

Just for completeness - a third way would be to use a proxy model that would translate between the bool and the checkstate role. That would be my second best suggestion (as it doesn't change the source model).

[Georgest]

The bounds between View and Model are the conventionalities... Qt4 provides for changing font, color, alignment in model, so it can be useful.

For NULLs there is Qt::ItemIsTristate.

setData needs to be reimplemented of course:

bool MyModel::setData(const QModelIndex &index,  const QVariant &value, int /* role */) {
    if (index.column() ......)
        return false;
 
    QModelIndex primaryKeyIndex = QSqlQueryModel::index(index.row(), 0);
    int id = QSqlQueryModel::data(primaryKeyIndex).toInt();
    //clear();
    bool ok;
    QSqlQuery query;
    if (index.column() == 1) {
        query.prepare("update employee set name = ? where id = ?");
        query.addBindValue(value.toString());
        query.addBindValue(id);
    .......
    }else if(index.column() == aColWithCheck) {
        query.prepare("update employee set married = ? where id = ?");
        query.addBindValue(value.toInt());
        query.addBindValue(id);
    }
    ok = query.exec();
    refresh();
    return ok;
}

bool MyModel::setData(const QModelIndex &index,  const QVariant &value, int /* role */) {
    if (index.column() ......)
        return false;

    QModelIndex primaryKeyIndex = QSqlQueryModel::index(index.row(), 0);
    int id = QSqlQueryModel::data(primaryKeyIndex).toInt();
    //clear();
    bool ok;
    QSqlQuery query;
    if (index.column() == 1) {
        query.prepare("update employee set name = ? where id = ?");
        query.addBindValue(value.toString());
        query.addBindValue(id);
    .......
    }else if(index.column() == aColWithCheck) {
        query.prepare("update employee set married = ? where id = ?");
        query.addBindValue(value.toInt());
        query.addBindValue(id);
    }
    ok = query.exec();
    refresh();
    return ok;
}

To copy to clipboard, switch view to plain text mode 

ItemIsUserCheckable in flags() and CheckStateRole in data() achieve the interesting feature: checkbox is clicked -> text label is changed in cell.

Proxy model 'Bool to CheckStateRole' is realy the best i think

What about 'Qt Cookbook'?