How to get a query result into LineEdit widget?
-
@qtnoob420 said in How to get a query result into LineEdit widget?:
i could provide a picture of my ui if that helps.
Hi
Please do as lineEdits and checkboxes can easily be replaced by a table, making it much easier to load
and edit data and save it back to the database.While it is possible to loop the QSqlQuery and assign each column to a given pre-placed widget, its
also likely to become a burden over time.
Just saving the data back will be "involving" as the widgets have no idea what column they belong to and
Qt already contains other data-aware classes to help with these tasks.
Like as @JonB mentions, using QSqlQueryModel + QDataWidgetMapperAlso, a QSqlTableModel + TableView would allow to directly edit a table with only a few lines of code, so
please show us the GUI so we can see if we can find a better way than manually updating and saving
50 LineEdits and 200 CheckBoxes.
-
@qtnoob420
You are not doing the right thing here. You useito access a column in the query, yet you incrementifor each new row fetched fromquery.next(). So you ask for:row 0, column 0 row 1, column 1 row 2 column 2And if you get only one row back, as per your query
WHERE id = 1, you will only get one row and therefore only the first output from above.To iterate all columns in rows, you mean something more like:
while (query.next()) // next *row* { int col = 0; QVariant v = query().value(col); // first *column* while (v.isValid()) // column exists, will return invalid QVariant once `col` goes beyond last column { ui->bem_1->insertPlainText(v.toString()); col++; v = query().value(col); // next *column* } } -
@qtnoob420
You are probably referring to the code for correctly reading the value in that column loop. And that's fine, but now that I see your form and how many fields there are I do think you would benefit from changing over to aQSqlTableModeland being able to use aQDataWidgetMapper. It looks like you are going to allow the user to edit the fields (not just display them), and the data widget mapper will allow you to do this very easily, and propagate the changes back to the database. I realize it is something new to learn, you don't have to do it but you might want to move that way if you have the time. -
@qtnoob420
You are probably referring to the code for correctly reading the value in that column loop. And that's fine, but now that I see your form and how many fields there are I do think you would benefit from changing over to aQSqlTableModeland being able to use aQDataWidgetMapper. It looks like you are going to allow the user to edit the fields (not just display them), and the data widget mapper will allow you to do this very easily, and propagate the changes back to the database. I realize it is something new to learn, you don't have to do it but you might want to move that way if you have the time. -
@JonB i could try this too, if i get everything to work and have enough time left. but i need to finalize it 3 weeks and must write a paper about it too. it is part of my studies
@qtnoob420
I quite understand! :)
