Deleting row from QTableWidget and from Sqlite database

[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.

[Christian Ehrlicher]

querymodel->removeRow(addressId, 1);

model->removeRows(row, 1);

removeRow() != removeRows()

[Risver]

@mchinand
Yes you're right.

[Risver]

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

querymodel->removeRow(addressId, 1);

model->removeRows(row, 1);

removeRow() != removeRows()

Thank You Christian, now i have no errors, but it is not removing.