Deleting row from QTableWidget and from Sqlite database

[Christian Ehrlicher]

Does your table has a primary key? Otherwise removing will not work.

[Risver]

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

Does your table has a primary key? Otherwise removing will not work.

Yes, it has.

[JonB]

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

Does your table has a primary key? Otherwise removing will not work.

That's very interesting. I assume we're talking about a SQL table model here? I looked through the docs (briefly) but did not see any mention of this requirement, is it documented?

[Risver]

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

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

Does your table has a primary key? Otherwise removing will not work.

That's very interesting. I assume we're talking about a SQL table model here? I looked through the docs (briefly) but did not see any mention of this requirement, is it documented?

That is how my SQL Table looks.

[JonB]

@Risver

qDebug() << querymodel->removeRows(addressId, 1);

Please add qDebug() << addressId, we need to make sure what that is, just in case.....

[Risver]

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

@Risver

qDebug() << querymodel->removeRows(addressId, 1);

Please add qDebug() << addressId, we need to make sure what that is, just in case.....

It is a variable to store the selected row, for example when i select the first row, it returns 0.
I checked this and its working fine

[JonB]

@Risver
OK, so independent of your selection querymodel->removeRows(0, 1); fails to remove the first row? We can then rule out anything to do with the UI or the selection.

[Risver]

@JonB
Exactly.

[Risver]

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

@Risver
OK, so independent of your selection querymodel->removeRows(0, 1); fails to remove the first row? We can then rule out anything to do with the UI or the selection.

Do you have something specific in mind ?

[JonB]

@Risver
Hang on. Does QSqlQueryModel allow any removing it all? It's a query, it won't/shouldn't do anything to the database for sure.

[Yep, I'm sure, QSqlQueryModel is a read only model, you can't remove rows from it.]

If you are wanting to alter the underlying the database table, I think you should be using QSqlTableModel instead?

I leave this to you, or @Christian-Ehrlicher, now, as I'm done for the week :)

[Risver]

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

@Risver
Hang on. Does QSqlQueryModel allow any removing it all? It's a query, it won't/shouldn't do anything to the database for sure.

[Yep, I'm sure, QSqlQueryModel is a read only model, you can't remove rows from it.]

If you are wanting to alter the underlying the database table, I think you should be using QSqlTableModel instead?

I leave this to you, or @Christian-Ehrlicher, now, as I'm done for the week :)

Okay, thank You, I will try to use QSqlTableModel.

[Risver]

I've changed the QSqlQueryModel into QSqlTableModel and everything is working !
Thank you all ! :)

I have one more question - how can i refresh the table at the current time ?

Done it !

[Risver]

I have one more question - can i get data from column and replace these with other data ?

[SGaist]

Hi,

Do you mean an entire column ?

[Risver]

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

Hi,

Do you mean an entire column ?

Hi, yes i mean all the cells that are in the column

[SGaist]

Yes, select the whole column and then use a loop to parse the selection.

[Risver]

@SGaist
Okay and can i replace the old data with new data ?

[JonB]

@Risver
What "new data", from where? Do you mean something like over-pasting a selected column's data with other data in the QTreeView UI? Do you mean updating all rows to change one column's data in the model and/or the SQL database? Programatically or by user interaction? Or what?

[Risver]

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

@Risver
What "new data", from where? Do you mean something like over-pasting a selected column's data with other data in the QTreeView UI? Do you mean updating all rows to change one column's data in the model and/or the SQL database? Programatically or by user interaction? Or what?

I mean updating all rows to change one column's data in the model(not in SQL), I would like this to happen programatically.

The passwords in database are encrypted, I want them to be decrypted when I open the application.

[JonB]

@Risver
The you must loop over each row, updating the column:

for (int row = 0; row < querymodel->rowCount(); row++)
    querymodel->setData(querymodel->index(row, someColumnNumber), someValue);

Is that what you meant?