bull3t
24th March 2020, 10:19
Hi,
i'm loading a table in a sqlite db file through QSqlTableModel, but while the original table has 2847 records, the view shows only 2755. QSqlTableModel::lastError() does not report any issue.
How can I debug the problem? This is the code I'm using:
QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName(currentDatabase.absoluteFilePat h());
if (!db.open()) {
QMessageBox::critical(this, qApp->tr("Error opening database"),
"Cannot connect to database.\n" + db.lastError().text(), QMessageBox::Cancel);
return;
}
tableModel = new QSqlTableModel(this, db);
ui->tableView->setModel(tableModel);
tableModel->setTable("my_table");
tableModel->select();
ui->tableView->show();
Thanks for any help
i'm loading a table in a sqlite db file through QSqlTableModel, but while the original table has 2847 records, the view shows only 2755. QSqlTableModel::lastError() does not report any issue.
How can I debug the problem? This is the code I'm using:
QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName(currentDatabase.absoluteFilePat h());
if (!db.open()) {
QMessageBox::critical(this, qApp->tr("Error opening database"),
"Cannot connect to database.\n" + db.lastError().text(), QMessageBox::Cancel);
return;
}
tableModel = new QSqlTableModel(this, db);
ui->tableView->setModel(tableModel);
tableModel->setTable("my_table");
tableModel->select();
ui->tableView->show();
Thanks for any help