How to make a column read-only in QSqlRelationalTableModel?

[aekilic]

Dear All

We have a QSqlRelationalTableModel, and we would like to make a column read-only? Is there any example codes that could help us?

Thanks!

AEK

[wysota]

Subclass the model and reimplement the flags() method to not return Qt::ItemIsEditable for items in the first column.

[aekilic]

Could you please help us a little with a example! We are a bit new to QT

[wysota]

class MyModel : public QSqlRelationalTableModel {
public:
  MyModel(QObject *parent=0) : QSqlRelationalTableModel(parent){}
  Qt::ItemFlags flags ( const QModelIndex & index ) const{
    if(index.column()!=0) 
        return QSqlRelationalTableModel::flags(index);
    return (QSqlRelationalTableModel::flags(index) & ~Qt::ItemIsEditable);
  }
};

class MyModel : public QSqlRelationalTableModel {
public:
  MyModel(QObject *parent=0) : QSqlRelationalTableModel(parent){}
  Qt::ItemFlags flags ( const QModelIndex & index ) const{
    if(index.column()!=0) 
        return QSqlRelationalTableModel::flags(index);
    return (QSqlRelationalTableModel::flags(index) & ~Qt::ItemIsEditable);
  }
};

To copy to clipboard, switch view to plain text mode 

[patrik08]

Could you please help us a little with a example! We are a bit new to QT

i attach a sample at end of class cpp you find the mysql structure....

[aekilic]

Let me explain more in our .h we call relationaltable below,

QSqlRelationalTableModel *model = new QSqlRelationalTableModel;
model->setTable("stokdakiler");
model->setFilter("stokid = " + Stokid);
model->setEditStrategy(QSqlRelationalTableModel::OnField Change);
model->setRelation(2, QSqlRelation("marka", "markaid", "marka"));
model->setRelation(4, QSqlRelation("birimler", "birimid", "birim"));
model->select();

table->setModel(model);
table->resizeColumnsToContents ();
table->resizeRowsToContents ();
table->setColumnHidden (0, true);
table->setColumnHidden (1, true);
table->setItemDelegate(new QSqlRelationalDelegate(tablestokda));
table->setSortingEnabled (true);

And after this what should we do?

[wysota]

You should substitute all occurences to QSqlRelationalTableModel with "MyModel" (based on the code I have given you - if you change the class name, change it here as well).

[patrik08]

Let me explain more in our .h we call relationaltable below,
And after this what should we do?

Build it..

other crude sample....
http://www.qtcentre.org/forum/f-qt-s...dmin-6807.html

[aekilic]

Thank you very much both of you, we were able to solve the problem easly!