Deleting row from QTableWidget and from Sqlite database

Risver

@jsulm
Okay and how can i connect it with the button_clicked signal?

Christian Ehrlicher

@Risver said in Deleting row from QTableWidget and from Sqlite database:

Okay and how can i connect it with the button_clicked signal?

You won't
When you react on the button clicked signal, get the current selection from the view and delete the selected rows in the model.

Risver

@Christian-Ehrlicher said in Deleting row from QTableWidget and from Sqlite database:

@Risver said in Deleting row from QTableWidget and from Sqlite database:

Okay and how can i connect it with the button_clicked signal?

You won't
When you react on the button clicked signal, get the current selection from the view and delete the selected rows in the model.

Something like this ?

void MainWindow::on_remove_clicked()
{
    int selectedRow = ui->tableView->selectionModel()->currentIndex().row();
    
}

Christian Ehrlicher

@Risver Yes.

Risver

@Christian-Ehrlicher
Now when i'm trying to implement QSqlTableModel::deleteRowFromTable the debugger says the deleteRowFromTable is a protected member of QSqlTableModel

jsulm

@Risver https://doc.qt.io/qt-5/qsqltablemodel.html#removeRows

Risver

@jsulm
Could you give some example ?

jsulm

@Risver Example?

model->removeRows(row, 1);

Risver

@jsulm
Now i have error - reference to type 'const QModelIndex' could not bind to an rvalue of type 'int'.
I think i have to refer to QModelIndex but i don't know how. I have a QSqlQueryModel. Should i change it to QAbstractTableModel ?

jsulm

@Risver Please show how you're calling removeRows
And what Qt version do you use?

Risver

@jsulm

void MainWindow::on_remove_clicked()
{

    if (ui->tableView->selectionModel()->hasSelection())
    {
        int addressId = ui->tableView->selectionModel()->currentIndex().row();
        querymodel->removeRow(addressId, 1);
        qDebug() << addressId;
    }
}

The QT version is 5.0.2

jsulm

@Risver said in Deleting row from QTableWidget and from Sqlite database:

QT version is 5.0.2

Check the documentation for removeRows() in that Qt version.
Probably it has a different signature.

Is there a reason why you're using such an ancient version?

Risver

@jsulm said in Deleting row from QTableWidget and from Sqlite database:

Is there a reason why you're using such an ancient version?

I just installed it a while time ago.

JonB

@Risver said in Deleting row from QTableWidget and from Sqlite database:

I just installed it a while time ago.

Before you spend any more time on this. Qt5 is already up to 5.15, unless you have some deep reason for wanting 5.0 I would uninstall and get such an up-to-date version.

Risver

@JonB
I can just upgrade Qt to v6 and see if it works

JonB

@Risver
You can indeed, though my personal preference would be to take the latest Qt5.x release. I still see too many issues with Qt6, not to mention that I think they still have not ported all modules, depends what bits you will be using.

However, my learned colleagues may disagree and advise you to go for Qt6, i don't know....

Risver

@JonB
I'm installing Qt 6 for now, i will check if everything works. If it won't i will install Qt 5.15

Okay, I configured the project in the new Qt and i still have the same error.

jsulm

@Risver said in Deleting row from QTableWidget and from Sqlite database:

I configured the project in the new Qt and i still have the same error.

And you are sure you're building with Qt6 now?
And did you do a complete rebuild?

Risver

@jsulm said in Deleting row from QTableWidget and from Sqlite database:

@Risver said in Deleting row from QTableWidget and from Sqlite database:

I configured the project in the new Qt and i still have the same error.

And you are sure you're building with Qt6 now?
And did you do a complete rebuild?

Yes i'm sure i building with Qt6, ~~but i'm not sure how can i complete rebuild the project.~~
found this. Still have error

mchinand

@Risver said in Deleting row from QTableWidget and from Sqlite database:

The QT version is 5.0.2

I'm guessing 5.0.2 is/was your QtCreator version (the IDE) not the version of Qt. Look at the 'Kit' you are using, it will say what version of Qt you are using.