Hi, the code below does not sort and does not hide the column but the column header shows active when is clicked. Please, help

Qt Code:
  1. model->setQuery("SELECT f1, id, f3, serialno FROM person2 WHERE f1 like '" + nametxt + "'");
  2. model->setHeaderData(0, Qt::Horizontal, tr("f1"));
  3. model->setHeaderData(1, Qt::Horizontal, tr("id"));
  4.  
  5.  
  6. QTableView *view = new QTableView;
  7.  
  8. view->setEditTriggers(QAbstractItemView::NoEditTriggers);
  9. view->setSortingEnabled(true);
  10. :) view->setSelectionBehavior(QAbstractItemView::SelectRows);
  11. view->setSelectionMode(QAbstractItemView::SingleSelection);
  12.  
  13. view->setAlternatingRowColors(true);
  14. view->setAutoFillBackground( true );
  15. QPalette p = view->palette();
  16. p.setColor(QPalette::Base, Qt::darkYellow);
  17. p.setColor(QPalette::Highlight, Qt::magenta);
  18. view->setPalette(p);
  19.  
  20. view->hideColumn(0); // does not work!
  21.  
  22. view->verticalHeader()->hide();
  23.  
  24. view->setModel(model);
  25. view->show();
To copy to clipboard, switch view to plain text mode