How to get a query result into LineEdit widget?

qtnoob420

@JonB thanks for the hint. i will look into it.

qtnoob420

@Pl45m4 ok i got it to work now. it atleast gives me the first value. probably i am mistaken here again.

int i=0;
while (query.next())
{
    ui->bem_1->insertPlainText(query.value(i).toString());
    i++;
}

it does not give other values than the id. i thought, that now all the values from the first row would be put into my plainText

JonB

@qtnoob420
You are not doing the right thing here. You use i to access a column in the query, yet you increment i for each new row fetched from query.next(). So you ask for:

row 0, column 0
row 1, column 1
row 2 column 2

And 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*
    }
}

SGaist

Hi,

Did you try to first draw a suitable UI before diving into the SQL parts ?

As @jsulm noted, it looks like you are trying to implement a UI that might well be really difficult to use.

Depending on what your user needs to get you might want to consider a light page with only the basic information and then a second one with more details etc. You might even be better served by a simple table.

mrjj

@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 + QDataWidgetMapper

Also, 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.

alt text

qtnoob420

@mrjj @SGaist here the pictures of my ui. https://imgur.com/a/NulxYJe

qtnoob420

@JonB thanks sir. this is what i needed :)

JonB

@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 a QSqlTableModel and being able to use a QDataWidgetMapper. 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

@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

JonB

@qtnoob420
I quite understand! :)