set data as ( utf8_general_ci ) not ( utf8_unicode_ci ) and test it

Hi and welcome to devnet,

You can use a proxy model that adds the columns you want/need.

You can keep updating the DB content and trigger the GUI update at some known interval or when a certains amount of changed happened to the database.

@Cleiton-Bueno Yes. If the query string is correct it will work.

Można użyć modelu proxy, który będzie interpretował jakieś dane (np. "0" i "1") jako checkbox, np.

class MyProxy : public QIdentityProxyModel { public: MyProxy(QObject* parent) : QIdentityProxyModel(parent) {} QVariant data(const QModelIndex& index, int role) const override { if (role == Qt::CheckStateRole && index.column() == 0) { QString str_value = QIdentityProxyModel::data(index, Qt::DisplayRole).toString(); return (str_value == "1") ? Qt::Checked : Qt::Unchecked; } return QIdentityProxyModel::data(index, role); } bool setData(const QModelIndex& index, const QVariant& value, int role) override { if (role == Qt::CheckStateRole && index.column() == 0) { QString str_value = (value.toInt() == Qt::Checked) ? "1" : "0"; return QIdentityProxyModel::setData(index, str_value, Qt::EditRole); } else return QIdentityProxyModel::setData(index, value, role); } Qt::ItemFlags flags(const QModelIndex& index) const override { Qt::ItemFlags f = QIdentityProxyModel::flags(index); if (index.column() == 0) f |= Qt::ItemIsUserCheckable; return f; } };

oczywiście numer kolumny i dane rozpoznawane jako "zaznaczony" można sobie dostosować.
Takiego modelu można użyć potem tak:

QSqlTableModel* model = new QSqlTableModel(parent, database); MyProxy* proxy = new MyProxy(parent); proxy->setSourceModel(model); tableView->setModel(proxy);

@_compiler

Model *derived = static_cast<QSqlQueryModel*>(model);

This isn't a valid cast because you can't implicitly cast to a derived type (see @mrjj's comment).

Model *derived = static_cast<Model *>(model);

Is valid but unsafe, as @SGaist pointed out.

Ultimately, what is not working?

Yeah, according to QComboBox code should work:

QVariant QComboBox::itemData(int index, int role) const { Q_D(const QComboBox); QModelIndex mi = d->model->index(index, d->modelColumn, d->root); return d->model->data(mi, role); }

Will implement this.

I would do:

int id = model->index(index.row(), 1).data().toInt();

The sequence of the columns in the query is the same as in the model and the view so 0=name, 1=id. The model is obtained either directly from the class where you have it or from the view using QListView::model().

You have more information about why you can't copy QObject derived class here

Hi and welcome to devnet,

They index provides you the row/column of the clicked item, so you can request the data from the index of the id column and the same row that you just clicked.

Hope it helps

Sorry for the late reply, the page says that there's nothing to be found

Thanks for the heads up. I had no idea.

Since I tried to use a model and failed, I became curious. I have done one more example using this tutorial, and it went fine. Do you have any idea why is it complaining about my database not being open, when it clearly is, judging from the fact that my query worked fine.