deleting record (row) from QSqlTableModel

[waynew]

I'm not an expert, but I'll give it a try.
First of all, I would suggest not removing the NoteID and nUnitID columns from the model. Don't know your reason for doing this.
Instead, if you are using a view, use view->setColumnHidden(<column_number>, TRUE) that way the columns are still available in the model, but not shown.

As for the printing and removing, notesmodel->removeRow(i, QModelIndex()) looks like it would remove all rows.
I would need to see more of the surrounding code to see what is going on.
If you removed columns NoteID and nUnitID from the model, then column 0 is now Date.
You can't remove columns for a specific nUnitID after the column has been removed from the model.

[schnitzel]

I'm not an expert, but I'll give it a try.
First of all, I would suggest not removing the NoteID and nUnitID columns from the model. Don't know your reason for doing this.
Instead, if you are using a view, use view->setColumnHidden(<column_number>, TRUE) that way the columns are still available in the model, but not shown.

As for the printing and removing, notesmodel->removeRow(i, QModelIndex()) looks like it would remove all rows.
I would need to see more of the surrounding code to see what is going on.
If you removed columns NoteID and nUnitID from the model, then column 0 is now Date.
You can't remove columns for a specific nUnitID after the column has been removed from the model.

Thanks for your helpful post. For a non-expert you are pretty good!
I misunderstood the removing of columns and thought they would just be hidden. This will solve some of the problems for which I have implemented work arounds in other parts of my app.

[waynew]

You are welcome. I have misunderstood many Qt things and probably will again.
Hiding a column in the view, like the primary key id or such improves the looks but you can still use the column in the model, just not in the view, at least visually.

Good luck with your app.