QTableWidget and SQL (dynamic) not working

cxam

@SGaist "i" is the number of rows that add's +1 at the end of the loop

cxam

@SGaist But how QtableView works ?

Joel Bodenmann

I can recommend reading these two articles to not only understand the model/view concept but also how Qt implements it:

As @SGaist pointed out there's an existing model that allows you to display SQL query results in a QTableView. The model is called QSqlQueryModel. You'd basically use a QTableView instead of a QTableWidget and use QTableView::setModel() to set the QSqlQueryModel as the model for the table view.

cxam

@Joel-Bodenmann I tried to use QTableView but actually it would break a lot of my code so unless it's completely necessary I won't use it. I'm focusing on trying to solve my current issue.

SGaist

What would break ?

In any case, I don't see you creating new rows. The incrementation of i doesn't mean your QTableWidget will have an additional row unless you did it before your while loop.

Joel Bodenmann

@cxam QTableWidget actually inherits from QTableView so it shouldn't break anything in terms of the GUI. In terms of the data handling: You just outsource that to the model. As there's an existing model that is designed specifically for handling SQL queries I can imagine that the only thing it would do is drastically simplify your life.
The QTableWidget really is just a QTableView with an internal model. That model is a generic model. Using the QTableView would allow you to use the SQL query specific QSqlQueryModel.

@SGaist QTableWidget::setItem() actually creates the row internally.

cxam

@Joel-Bodenmann Hmm I see. I'll check it out then, thanks for your help.

SGaist

@Joel-Bodenmann No it doesn't. First thing done, it checks whether the row, column combination returns a valid index if not then it returns immediately.

Joel Bodenmann

@SGaist Yes, you are correct. I am sorry for giving wrong information.

@cxam So as @SGaist pointed out in his first post: Make sure that your QTableWidget "has enough rows".
But anyway, I'd still recommend going with QTableView and QSqlQueryModel in your case.

cxam

@SGaist Indeed, you're right When I set the properties for my table I set that the number of rows was "1" so I have to create an "int" variable and then say that the number of rows is that variable starting from 1 and then increment that number on the loop.