Can't update data in QSqlTableModel when the pk Column hidden

[topquarck]

Hellow there;

I'm trying to view data from a simple DB table to a QtableView.
I used the Sample Code supplied in the QSqlTableModel's Documentation page with a minor modification.
I have a STUDENT table with id pk and name

-- the DB engine is sqlite:
create table student (id INTEGER PRIMARY KEY AUTOINCREMENT, name varchar(20) not null);

-- the DB engine is sqlite:
create table student (id INTEGER PRIMARY KEY AUTOINCREMENT, name varchar(20) not null);

To copy to clipboard, switch view to plain text mode 

and i modified the code to be :

model = new QSqlTableModel;
    model->setTable("student"); //that's the table name
    model->setEditStrategy(QSqlTableModel::OnManualSubmit); // whatever edit strategy, it still not working
    model->select();
    model->setHeaderData(0, Qt::Horizontal, tr("id"));
    model->removeColumn(0); // don't show the ID; <<-- here is the PROBLEM
     model->setHeaderData(1, Qt::Horizontal, tr("name"));
 
     ui->tableView->setModel(model);
     ui->tableView->show();

model = new QSqlTableModel;
    model->setTable("student"); //that's the table name
    model->setEditStrategy(QSqlTableModel::OnManualSubmit); // whatever edit strategy, it still not working
    model->select();
    model->setHeaderData(0, Qt::Horizontal, tr("id"));
    model->removeColumn(0); // don't show the ID; <<-- here is the PROBLEM
     model->setHeaderData(1, Qt::Horizontal, tr("name"));

     ui->tableView->setModel(model);
     ui->tableView->show();

To copy to clipboard, switch view to plain text mode 

data is shown and everything is fine. But when I try to update a recoed ' the name field for a given record'; I get a debug message saying :

QSqlQuery::value: not positioned on a valid record

QSqlQuery::value: not positioned on a valid record

To copy to clipboard, switch view to plain text mode 

and the rows don't update
If I just commented the removeColumn() line; data updates when I modify them and everything works fine.
BUT I need to remove the ID column - i.e keep it hidden from users - ! it is the PRIMARY KEY and I cant just let users manipulate it

Is there a way to hide the ID column and still be able to update 'the other column values that are NOT id' ???

thanx alot in advance

[qteto]

hi,
try view->hideColumn(0) instead model-> removeColumn(0)

[ChrisW67]

Updates require a way to uniquely identify the row to be updated. Removing the unique id makes updates difficult.

Hiding the column is a function of the view, not the model. So, for example,

model = new QSqlTableModel;
model->setTable("student"); //that's the table name
model->setEditStrategy(QSqlTableModel::OnManualSubmit); 
model->select();
model->setHeaderData(0, Qt::Horizontal, tr("id"));  // will not be shown in view below
model->setHeaderData(1, Qt::Horizontal, tr("name"));
 
ui->tableView->setModel(model);
ui->tableView->setColumnHidden(0, true);  // hide the id from view
ui->tableView->show();

model = new QSqlTableModel;
model->setTable("student"); //that's the table name
model->setEditStrategy(QSqlTableModel::OnManualSubmit); 
model->select();
model->setHeaderData(0, Qt::Horizontal, tr("id"));  // will not be shown in view below
model->setHeaderData(1, Qt::Horizontal, tr("name"));
 
ui->tableView->setModel(model);
ui->tableView->setColumnHidden(0, true);  // hide the id from view
ui->tableView->show();

To copy to clipboard, switch view to plain text mode