Hi People I'm new here and I formerly developed Software in RAD Studio. I started with QT Creator because I need to... Don't ask please... To my question: I am developing a database application and I need to use a model based TableView in a MainWindow-Class. For this to work, I decided to use the QSqlTableModel. I Use the following code to bring it to work - and as far as I can see - it works... The Database connection "DB_Connection" is already set as private "global " object in the class of MainWindow and gets the connection via a function called setDB like so: //mainwindow.h class MainWindow : public QMainWindow { Q_OBJECT public: MainWindow(QWidget *parent = nullptr); ~MainWindow(); QSqlTableModel getSQLTableModel(); void setSQLTableModel(QSqlTableModel *model); void setDB(QSqlDatabase db); QSqlTableModel* getTableModel(); void onOpenMainWindow(); private slots: void on_pushButton_clicked(); private: Ui::MainWindow *ui; QSqlTableModel *TableModel; QSqlDatabase DB_Connection; }; //mainwindow.cpp void MainWindow::onOpenMainWindow() { QSqlTableModel *model = new QSqlTableModel; setSQLTableModel(model); model->setTable("mytable"); model->setEditStrategy(QSqlTableModel::OnManualSubmit); model->select(); model->setHeaderData(0, Qt::Horizontal, tr("oneOfManyColumns")); model->setHeader... . . -> and so on ui->view->setModel(model); ui->view->hideColumn(0); } //mainwindow.cpp void MainWindow::setSQLTableModel(QSqlTableModel *model) { this->TableModel = model; } //mainwindow.cpp void MainWindow::on_pushButton_clicked() { QSqlTableModel *model = TableModel; model->submitAll(); } It compiles without errors. Also it shows the DB-Data correctly in the tableView. I can also click it, edit, etc. BUT when i push the button it only saves the data once. After that I can still make changes in the tableView but I can't save it anymore. I don't get errors. It must have to do with the "model"-object. But I don't know how to fix that. So generally spoken: How can I use a button to save changes, that a user makes inside the tableView connected with the QSqlTableModel? I explicitly DON'T want it to be updated right with the change! Thanks in advance for your ideas and I hope someone can help me... EDIT: I don't usually instanciate objects with "new" but I had no other Idea how it would work... Greetz, mooswitz

Hi and welcome to devnet, There are several issues with your code but one of the most important thing: you don't check that submitAll succeeds. That's the first thing you should add. Next thing: don't store QSqlDatabase member variables. That's not how the class shall be used and is explained in the documentation. Why are you creating the function local model pointer in your slot ? You can call submitAll directly on your member variable.

Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

How to use an Object of type QSqlTableModel in another function of the same class?

Unsolved General and Desktop

21 Posts 4 Posters 1.9k Views 4 Watching

M mooswitz

Okay. Thanks a lot!

How would I do that? I mean: connecting the button directly to the function?
S Offline
S Offline
SGaist
Lifetime Qt Champion
wrote on last edited by

#21

@mooswitz sorry, that was a bad suggestion, you would lose the error handling check.
Interested in AI ? www.idiap.ch
Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct
1 Reply Last reply

0