Help with setting QTableView's vertical header data

holygirl

Hey everybody!

     I need some help with setting the vertical header data of _QTableView_ to a list of strings in a _QStringList_. I am able to set the horizontal data using

@
QSqlQueryModel *model = new QSqlQueryModel;
model->setHeaderData(0, Qt::Horizontal, tr("Age"));
model->setHeaderData(1, Qt::Horizontal, tr("Salary"));
@

but when I try to customize the row header label, the following code returns false.

@
QSqlQueryModel *model = new QSqlQueryModel;
model->setHeaderData(0, Qt::Vertical, tr("Andrew"));
model->setHeaderData(1, Qt::Vertical, tr("Isobel"));
@

I found "this":http://www.qtcentre.org/threads/15328-setHeaderData-Qt-Vertical-on-QSqlTableModel but I didn't really understand how the OP implemented it. Could anybody please help me?

hpollak

See class-documentation of "QSqlQueryModel":http://qt-project.org/doc/qt-5.0/qtsql/qsqlquerymodel.html#setHeaderData for setHeaderData again:

Returns true if orientation is Qt::Horizontal and the section refers to a valid section; otherwise returns false.

holygirl

I did read the documentation before and I did so again. My question is, since it returns false for anything other than Qt::Horizontal, is it possible to set the label for the vertical headers? If yes, how?
Thanks.

SGaist

IIRC for the QSqlQueryModel, the vertical headers text are based on what the select statement contains. In that case you can write your select statement with the column name you want to have in you headers.

@SELECT a.columnName AS MyColumnName FROM a@

BEWARE this is not tested.

Out of curiosity, why do you want the vertical headers to contain people names ?
Shouldn't you have something like Name, Age, Salary, and in your horizontal data "Andrew", "50", "2500" ?

holygirl

The solution you suggested is not an option because I want to generate the vertical header labels using the values in a QStringList.

I gave names as vertical headers just as an example. I am coding a TV guide which will have channel names as the vertical header, shows of each channel as the rows and timings of the shows as the horizontal header. I was too lazy to explain all this which is why I gave names as an example :)

SGaist

Then, how does your query return the data for each separated channel ?

holygirl

The query is within a channels loop where each loop returns all the shows for a particular channel.

SGaist

Is the loop in SQL or in c++ ?

holygirl

c++

SGaist

In that case, how do you setup the grid ? The QSqlQueryModel will only contain the data for the current channel not all

holygirl

Yes. I do something like this

@Loop for channel {

  For each channel, get all the show details
  Loop for all the shows {
        
           Display all the shows for channel n
  }

  n++;

}
@

So the result is

But instead of the 1, 2, 3 .... in the column header, I want

I hope I'm able to put across my problem clearly. I'm struggling to find words to explain it to you. Sorry!

SGaist

?

EDITED:
Corrected horizontal/vertical headers

holygirl

No no! I mean

I know it's weird but using the below code changes the row headers and not the column headers. Which basically means that the horizontal header is the row header and the vertical header is the column header.

@
QSqlQueryModel *model = new QSqlQueryModel;
model->setQuery("SELECT name FROM channel");
model->setHeaderData(0, Qt::Horizontal, tr("2:00"));
model->setHeaderData(1, Qt::Horizontal, tr("2:30"));
model->setHeaderData(1, Qt::Horizontal, tr("3:00"));
@

Thanks for being patient :)

SGaist

Right, might be confusing: The horizontal header view is for the column name and the vertical is for the row name. It's more a positional point of view: The header view "deploys" horizontally so it shows the column name.

Anyway, the QSqlQueryModel doesn't allow to set the vertical header data. But what intrigues me is how to you make your grid from your SQL ?

With your last query you will only get one column with the channel names.

How does your database look like ?
A table with the channels and a table with the shows and their time ?

holygirl

[quote author="SGaist" date="1366987686"]With your last query you will only get one column with the channel names.

How does your database look like ?
A table with the channels and a table with the shows and their time ?[/quote]

Yes, I will get only one column with the channel name which I want to display as the vertical headers.

Within the loop where I get the channel names, I use another SQL query to get all the show titles and timings for that particular channel which is active in the current loop.

For example, if my channels are HBO, Fox and CBS, I run a loop while query.next() to get each channel. Inside this loop, when HBO is my current channel query.value(0), I use the channel name to get the show titles and then display them. Since the loop will run thrice, I get all the show titles for all three channels one after the other.

SGaist

Then... Why do you use a QTableView with a QSqlQueryModel ? You won't get all shows data since you change the query on each loop

holygirl

OMG! I'm so sorry. I'm confusing you and myself here. When I couldn't set the QTableView's vertical header, I moved on to generating the grid using just QLabels and that's when I used the looping technique. I'm so so sorry for the confusion.
With QSqlQueryModel, i simply used a single query to get the show details. However, I couldn't display the channel details as the vertical header which is why I posted this question originally.
Once again, I'm really very sorry :(

SGaist

If you are now running the query for each channel individually and pulling the data. You could simply use a QTableWidget and make the grid as you wanted before.

holygirl

I could. But there's another problem. Please have a look at "this question":http://qt-project.org/forums/viewthread/27263/ I posted.
What I actually have to do is this:

@

| Label1 | Label2 | Label3 | Label4 |

| Label5 | Label6 | Label7 | Label8 |

| Label9 | Label10 | Label11 | Label12 |

@

So I not only have to generate these labels on the GUI, but also access them using indices so I can manipulate their properties like

@
label [0][2]->setText("Changed label");
@

I'm struggling to find the right data structure to use to solve my issue. Please please help.

holygirl

Hi again!

    I couldn't solve my problem using _QTableWidget_ or similar widgets so I used a different "approach":http://qt-project.org/forums/viewthread/27263/ instead. I'd love to learn new ways of solving the same problem though :)

SGaist

Ok I see now...

With layout you need, you would have to make your own QAbstractItemView on top of your model

holygirl

Oh ok. I'll try implementing that too and see which one suits better. Thanks very much for your assistance SGaist. You've been very kind and patient :)

SGaist

You're welcome !

IIRC there are some good examples in the book Advanced Qt Programming that might help

holygirl

By Mark Summerfield right? I have that book. I read the first few pages and then I got too lazy to continue. I learned so much more from "Void Realms":http://www.youtube.com/playlist?list=PL2D1942A4688E9D63, "Bucky":http://www.youtube.com/course?list=ECD0D54219E5F2544D, online Qt "documentation":http://qt-project.org/doc/qt-4.8/ and of course the most awesome forum on web, qt-project.org :)
But I guess I could give the book another try!