I'm new to Qt but have been a C++ coder since Borland... my question is how would one assign certain fields in a database ( I'm using SQlite ) to particular columns... ie changing the display order. This is a desktop application.

Let me know if I'm using the wrong class for what I need to do.... tnx.

code snippit follows:


// QSqlRelationalTableModel ////////////////////////////////////////////////////////////////////////////////////////////////
QSqlRelationalTableModel *model = new QSqlRelationalTableModel;
model->setJoinMode(QSqlRelationalTableModel::LeftJoin) ;
model->setTable("tblSales");
model->setEditStrategy(QSqlTableModel::OnManualSubmit) ;

model->setRelation(4, QSqlRelation("tblJewelryPiece", "JewelryPieceID", "Category"));// set Relation
model->setRelation(5, QSqlRelation("tblJewelryPiece", "JewelryPieceID", "PieceName"));// set Relation

model->setHeaderData(0, Qt::Horizontal, tr("Invoice #")); // set Header Data
model->setHeaderData(2, Qt::Horizontal, tr("Date"));
model->setHeaderData(3, Qt::Horizontal, tr("Qty"));
model->setHeaderData(4, Qt::Horizontal, tr("Category"));
model->setHeaderData(6, Qt::Horizontal, tr("Jewelry Piece"));
model->setHeaderData(7, Qt::Horizontal, tr("Price"));

model->setFilter("CustomerID=" + val); // set filter to current customer

model->select(); // select
ui->tv_Sales->setModel(model);

ui->tv_Sales->resizeColumnsToContents();
ui->tv_Sales->show();