March 26, 2012

umen242 umen242
Ant Farmer
326 posts

Qt QSqlQueryModel::setQuery control what display in in the column

 

Im using :

  1. QString query = "SELECT foo,n1,n2 FROM play_list";
  2. QSqlQueryModel::setQuery(query, queryDB);

in QSqlQueryModel subclass , but i dont want to display all the results that i getting from the select , i want to use the data and display only foo in the display and others results in others things . how can it be done?

4 replies

March 26, 2012

dridk dridk
Lab Rat
48 posts
  • Certified developer
  • Qt Developer Days 2011

Hide column in the view, not in the model.
For exemple :

  1. QTableView::setColumnHidden ( int column, bool hide )

 Signature 

Nothing in Biology Makes Sense Except in the Light of Evolution

April 1, 2012

umen242 umen242
Ant Farmer
326 posts

but i like to use the data from the other columns

April 5, 2012

Volker Volker
Robot Herder
5428 posts
  • Qt DevNet Moderator
  • Certified Specialist

Subclassing QSortFilterProxyModel and reimplementing method filterAcceptsColumn() should do the trick.

 Signature 

http://www.catb.org/~esr/faqs/smart-questions.html

April 9, 2012

Andre Andre
Area 51 Engineer
6031 posts
  • Certified Specialist
  • Qt DevNet Moderator

Hiding the data from the view does not stop you from using the data in other contexts…

 Signature 

Looking for Qt developers to join our team @ i-Optics: https://qt-project.org/forums/viewthread/25393/

 
  ‹‹ [Solved] QLineEdit input incorrectly uppercased      QGraphicsItem child’s type() ››

You must log in to post a reply. Not a member yet? Register here!

 
Selected by the fine Qt Content Robot based on tags and ratings.

Possibly related content

Forum posts and FAQ

© 2013 Qt Project Hosting. Qt® and the Qt logo is a registered trade mark of Digia plc and/or its subsidiaries and is used pursuant to a license from Digia plc and/or its subsidiaries.
All other trademarks are property of their respective owners. Privacy Policy
This site is hosted by Gitorious AS. Your use of this web site is governed by these terms of service.

Qt Project Hosting, P.O. Box 4332 Nydalen, 0402 Oslo, Norway. Org. Nr. 997 447 913