How to get data from sqlquery that result 3 columns in a row and show only 1 Colum

[umen]

How to get data from sqlquery that result 3 columns in a row and show only 1 Colum and use the other columns data
hello all
im using QSqlQueryModel subclass to execute sql querys and populate them to tableview
now i have simple sql query that results 3 columns/ fields in a row that invoked in the QSqlQueryModel subclass like this :


QString query_local = "SELECT foo1,foo2,foo3 FROM tbl" ;
QSqlQueryModel::setQuery(query_local, queryDB);

now i what to use the data from foo1 and foo 2 but display only foo3
so in the end there will be only one column in the view per row.

[ChrisW67]

Do yourself a favour... find an SQL tutorial. If you only want foo3 in the result then only list foo3. Assuming "use the data from foo1 and foo 2" means filtering on those columns then they appear in the WHERE clause.

[umen]

Hi
sorry but English isn't my native language so i guess i have semantic errors .
what i mean is that i need the data from foo1 and foo2 to use ( store in the Qt::UserRole as string)
but display in the Qt::DisplayRole the result of foo3.
is it more clear ?

[Lesiok]

RTFM and hint is QTableView::hideColumn (http://qt-project.org/doc/qt-4.8/qtableview.html#hideColumn)

[Lykurg]

To avoid double answers: http://qt-project.org/forums/viewthread/15861/.
Not so polite to ask the same question in different forums...

EDIT: And here we go: http://qt-project.org/forums/viewthread/15795/.
Menu -> Block User -> add!

[umen]

Thanks for the answer , but this dosn't work i set the table like this :

m_pPlayListMiniItemDelegate =new PlayListMiniItemDelegate(this);
ui->PlayListMini_tableView->setSelectionBehavior(QAbstractItemView::SelectRows );
ui->PlayListMini_tableView->setSelectionMode(QAbstractItemView::SingleSelectio n);
ui->PlayListMini_tableView->setItemDelegate(m_pPlayListMiniItemDelegate);
ui->PlayListMini_tableView->setAlternatingRowColors(true);
ui->PlayListMini_tableView->setModel(PlayListMiniSqlModel::instance());
ui->PlayListMini_tableView->hideColumn(0);
ui->PlayListMini_tableView->hideColumn(1);

and inside the PlayListMiniSqlModel::instance()
i execute simple sql that returns 3 results in a row.
"SELECT foo1,foo2,foo3 FROM tbl"
the hide column 0,1 dosnt work i still see 3 column in raw.
also i follow this tutorial :
http://www.jwdougherty.com/content/qtableview-primary-keys-and-user-interfaces

[wysota]

Show us your model implementation, please.

[ChrisW67]

i execute simple sql that returns 3 results in a row.
"SELECT foo1,foo2,foo3 FROM tbl"
the hide column 0,1 dosnt work i still see 3 column in raw.

Ah yes... and that is a problem because...?