QTableView Headers problem

[vcp]

Hi,

See my source code, I think that will can help.

Note that the 'setHeaderData' always should be between the 'select' statement. and setModel().

QApplication::setOverrideCursor(QCursor(Qt::WaitCursor));
  QSqlQueryModel *model = new QSqlQueryModel;
  model->setQuery("SELECT LPAD(PV_IDENT,5,'0') AS PV_IDENT, PV_NOME, CONCAT_WS(' ',sys.spISO2EUR(LEFT(PV_DATA,10)),RIGHT(PV_DATA,8) ) AS PV_DATA, PV_OBJ FROM ACPEDVISTA WHERE PV_FLAG = 0 ORDER BY PV_DATA");
  model->setHeaderData(0, Qt::Horizontal, tr("Id#"));
  model->setHeaderData(1, Qt::Horizontal, tr("Requisitante"));
  model->setHeaderData(2, Qt::Horizontal, tr("Data"));
  model->setHeaderData(3, Qt::Horizontal, tr("Objeto"));
 
  tviewPedidos->setModel(model);
  tviewPedidos->show();
  QApplication::restoreOverrideCursor();

QApplication::setOverrideCursor(QCursor(Qt::WaitCursor));
  QSqlQueryModel *model = new QSqlQueryModel;
  model->setQuery("SELECT LPAD(PV_IDENT,5,'0') AS PV_IDENT, PV_NOME, CONCAT_WS(' ',sys.spISO2EUR(LEFT(PV_DATA,10)),RIGHT(PV_DATA,8) ) AS PV_DATA, PV_OBJ FROM ACPEDVISTA WHERE PV_FLAG = 0 ORDER BY PV_DATA");
  model->setHeaderData(0, Qt::Horizontal, tr("Id#"));
  model->setHeaderData(1, Qt::Horizontal, tr("Requisitante"));
  model->setHeaderData(2, Qt::Horizontal, tr("Data"));
  model->setHeaderData(3, Qt::Horizontal, tr("Objeto"));

  tviewPedidos->setModel(model);
  tviewPedidos->show();
  QApplication::restoreOverrideCursor();

To copy to clipboard, switch view to plain text mode