Row number in a QSqlQueryModel

[fnmblot]

Is there any way to remove the row number in a QSqlQueryModel? I tried:

tableViewModel->removeColumn(0);

tableViewModel->removeColumn(0);

To copy to clipboard, switch view to plain text mode 

but that removes my first column of data.

The reason I need this removed is the database missing the number 13 and seeing a row number next to the UID gets a little confusing. (I am a little superstitous.)

[jpn]

You mean the vertical header?

tableView->verticalHeader()->hide();

tableView->verticalHeader()->hide();

To copy to clipboard, switch view to plain text mode 

[fnmblot]

well, I am getting errors compiling when I try that method.

src/tableVCS.cpp:22: error: invalid use of undefined type struct QHeaderView
/usr/include/QtGui/qtableview.h:55: error: forward declaration of struct QHeaderView
make[1]: *** [build/tableVCS.o] Error 1

Here is the code for the table:

#include "tableVCS.h"
#include <QtSql>
//
tableVCSDlg::tableVCSDlg( QWidget * parent, Qt::WFlags f) 
	: QDialog(parent, f)
{
	tableVCSUi.setupUi(this);
 
	QSqlQueryModel *tableViewModel = new QSqlQueryModel;
	tableViewModel->setQuery("SELECT piece_name, nn, short_instrum FROM main WHERE nn !='0' ORDER BY nn");
 
	tableViewModel->setHeaderData(0, Qt::Horizontal, "Piece Name");
	tableViewModel->setHeaderData(1, Qt::Horizontal, "NN");
	tableViewModel->setHeaderData(2, Qt::Horizontal, "Instrumentation");
 
 
	tableVCSUi.tableView->setModel(tableViewModel);
	tableVCSUi.tableView->resizeColumnsToContents();
	tableVCSUi.tableView->verticalHeader()->hide();
}
 
tableVCSDlg::~tableVCSDlg()
{}
//End tableVCS.cpp

#include "tableVCS.h"
#include <QtSql>
//
tableVCSDlg::tableVCSDlg( QWidget * parent, Qt::WFlags f) 
	: QDialog(parent, f)
{
	tableVCSUi.setupUi(this);

	QSqlQueryModel *tableViewModel = new QSqlQueryModel;
	tableViewModel->setQuery("SELECT piece_name, nn, short_instrum FROM main WHERE nn !='0' ORDER BY nn");

	tableViewModel->setHeaderData(0, Qt::Horizontal, "Piece Name");
	tableViewModel->setHeaderData(1, Qt::Horizontal, "NN");
	tableViewModel->setHeaderData(2, Qt::Horizontal, "Instrumentation");

	
	tableVCSUi.tableView->setModel(tableViewModel);
	tableVCSUi.tableView->resizeColumnsToContents();
	tableVCSUi.tableView->verticalHeader()->hide();
}

tableVCSDlg::~tableVCSDlg()
{}
//End tableVCS.cpp

To copy to clipboard, switch view to plain text mode 

[jpn]

#include <QHeaderView>

#include <QHeaderView>

To copy to clipboard, switch view to plain text mode 

[fnmblot]

That is why you are a Guru and I am just a wee Novice. Thanks a million jpn! It worked like a charm.