About setIndexWidget

[aekilic]

I got 15

I try to

tableView->insertColumn(16);

tableView->insertColumn(16);

To copy to clipboard, switch view to plain text mode 

But notting changes

[wysota]

I got 15

So trying to insert something into the 17th column probably shouldn't have any effect, should it?

I try to

tableView->insertColumn(16);

tableView->insertColumn(16);

To copy to clipboard, switch view to plain text mode 

But notting changes

You can't add columns to sql models just like that.

I think what you really want is to use Qt::CheckStateRole. That's only a teaser - how to use it is left as an exercise to you.

[aekilic]

I did it with

Qt::CheckStateRole

But the problem is check box is not editable...

[wysota]

Because you didn't implement setData() and flags() for your model.

[aekilic]

I do it like

class MyModel : public QSqlQueryModel {
    Q_OBJECT
public:
    MyModel(QObject *parent = 0);
    Qt::ItemFlags flags(const QModelIndex &index) const;
    QVariant data(const QModelIndex &index, int role = Qt::DisplayRole) const;
........
};
 
Qt::ItemFlags MyModel::flags(const QModelIndex &index) const {
    Qt::ItemFlags flags = QSqlQueryModel::flags(index);
    if (index.column() == aColWithCheckbox)
        flags |= Qt::ItemIsUserCheckable;
    else
        flags |= Qt::ItemIsEditable;
    return flags;
} 
 
QVariant MyModel::data(const QModelIndex &index,  int role) const {
  QVariant value = QSqlQueryModel::data(index, role);
  if (role == Qt::CheckStateRole && index.column() == aColWithCheckbox)
    return (QSqlQueryModel::data(index).toInt() != 0) ? Qt::Checked : Qt::Unchecked;
  else
    return value;
}

class MyModel : public QSqlQueryModel {
    Q_OBJECT
public:
    MyModel(QObject *parent = 0);
    Qt::ItemFlags flags(const QModelIndex &index) const;
    QVariant data(const QModelIndex &index, int role = Qt::DisplayRole) const;
........
};
 
Qt::ItemFlags MyModel::flags(const QModelIndex &index) const {
    Qt::ItemFlags flags = QSqlQueryModel::flags(index);
    if (index.column() == aColWithCheckbox)
        flags |= Qt::ItemIsUserCheckable;
    else
        flags |= Qt::ItemIsEditable;
    return flags;
} 
 
QVariant MyModel::data(const QModelIndex &index,  int role) const {
  QVariant value = QSqlQueryModel::data(index, role);
  if (role == Qt::CheckStateRole && index.column() == aColWithCheckbox)
    return (QSqlQueryModel::data(index).toInt() != 0) ? Qt::Checked : Qt::Unchecked;
  else
    return value;
}

To copy to clipboard, switch view to plain text mode 

But as I have told you I could not check the qcheckbox

[aekilic]

do I missed anything?

[wysota]

You didn't implement setData().

[aekilic]

I have writen the setData didnt paste

my code is exactly like this

Qt::ItemFlags CustomModel::flags(const QModelIndex &index) const {
	Qt::ItemFlags flags = QSqlTableModel::flags(index);
	if (index.column() == 16)
		flags |= Qt::ItemIsUserCheckable | Qt::ItemIsEditable;
	return flags;
}
 
QVariant CustomModel::data(const QModelIndex &index, int role) const
{
    if (role == Qt::CheckStateRole && index.column() == 16)
      return (QSqlQueryModel::data(index).toInt() != 0) ? Qt::Checked : Qt::Unchecked;
 
    return value;
}
bool CustomModel::setData(const QModelIndex &index,  const QVariant &value, int role) {
	if(role==Qt::CheckStateRole)
		return QSqlTableModel::setData(index,value.toBool(),Qt::EditRole);
	return QSqlTableModel::setData(index,value);
}

Qt::ItemFlags CustomModel::flags(const QModelIndex &index) const {
	Qt::ItemFlags flags = QSqlTableModel::flags(index);
	if (index.column() == 16)
		flags |= Qt::ItemIsUserCheckable | Qt::ItemIsEditable;
	return flags;
}

QVariant CustomModel::data(const QModelIndex &index, int role) const
{
    if (role == Qt::CheckStateRole && index.column() == 16)
      return (QSqlQueryModel::data(index).toInt() != 0) ? Qt::Checked : Qt::Unchecked;

    return value;
}
bool CustomModel::setData(const QModelIndex &index,  const QVariant &value, int role) {
	if(role==Qt::CheckStateRole)
		return QSqlTableModel::setData(index,value.toBool(),Qt::EditRole);
	return QSqlTableModel::setData(index,value);
}

To copy to clipboard, switch view to plain text mode 

The check box on the table is still not editable, I can not check the qcheckbox...

[wysota]

One time you are using QSqlQueryModel as your base class and the other time you are using QSqlTableModel. So which one is it?

[aekilic]

Sorry

QSqlTableModel it should be, working right now sorry for the delay and time, but right now I had a problem I could not check more than 2 rows?

[wysota]

Did you solve the previous problem? What was it?

[aekilic]

I was not able to check the check box, but I could do it right now, but I could not check more than 2 check box, When I press the 3rd check box, the 1st check is removed.