Fetching data from table view

[utkuaydin]

I've a QSqlQueryModel as a table view. I want users to delete some of entries by simply selecting them from the table and pressing delete button. I delete the entry by first column's value so I'm successful if user clicks to first column. I can't force user to click first column especially on S60 so I want to get first columns value if user clicks to other columns. How can I do it?

Ask if you want more information and thanks in advance.

[waynew]

1. Set up a menu item or a context menu with signal/slot to deleteEntry()

Example:

connect(ui->actionDelete_Log_Entry, SIGNAL(triggered(bool)),
          this, SLOT(deleteEntry()));

connect(ui->actionDelete_Log_Entry, SIGNAL(triggered(bool)),
          this, SLOT(deleteEntry()));

To copy to clipboard, switch view to plain text mode 

2. All user has to do is click anywhere in a record (any column) then select your new menu item 'Delete'
or new context menu entry 'Delete'.

void MainWindow::deleteEntry() {
 QModelIndex index = view->currentIndex();
  if (index.isValid()) {
      QSqlRecord record = model->record(index.row());
      model->removeRow(index.row());
      model->submitAll();
  }
}

void MainWindow::deleteEntry() {
 QModelIndex index = view->currentIndex();
  if (index.isValid()) {
      QSqlRecord record = model->record(index.row());
      model->removeRow(index.row());
      model->submitAll();
  }
}

To copy to clipboard, switch view to plain text mode 

Works fine for me.

[utkuaydin]

Strangely, it returns "QSqlQuery::value: not positioned on a valid record" error when I press to the delete key.

My delete function:

void lessons::deleteLesson(QModelIndex index)
{
    QSqlTableModel *model = this->lessonsTable();
    model->removeRow(index.row());
    model->submitAll();
}

void lessons::deleteLesson(QModelIndex index)
{
    QSqlTableModel *model = this->lessonsTable();
    model->removeRow(index.row());
    model->submitAll();
}

To copy to clipboard, switch view to plain text mode 

lessonsTable function:

QSqlTableModel* lessons::lessonsTable()
{
    QSqlTableModel *model = new QSqlTableModel;
    model->setTable("lessons");
    model->setEditStrategy(QSqlTableModel::OnManualSubmit);
    model->select();
    model->removeColumn(0); // Don't show the ID
    model->setHeaderData(0, Qt::Horizontal, "Name");
    model->setHeaderData(1, Qt::Horizontal, "Teacher");
    return model;
}

QSqlTableModel* lessons::lessonsTable()
{
    QSqlTableModel *model = new QSqlTableModel;
    model->setTable("lessons");
    model->setEditStrategy(QSqlTableModel::OnManualSubmit);
    model->select();
    model->removeColumn(0); // Don't show the ID
    model->setHeaderData(0, Qt::Horizontal, "Name");
    model->setHeaderData(1, Qt::Horizontal, "Teacher");
    return model;
}

To copy to clipboard, switch view to plain text mode 

And where I call the function:

void osman::on_pushButton_del_lesson_clicked()
{
    lsn.deleteLesson(ui->tableView_lessons->currentIndex());
}

void osman::on_pushButton_del_lesson_clicked()
{
    lsn.deleteLesson(ui->tableView_lessons->currentIndex());
}

To copy to clipboard, switch view to plain text mode 

[waynew]

Looks like you are creating a NEW model in your delete function, and trying to delete from that one, which would be empty, instead of deleting from the existing model.

[utkuaydin]

I've set my existing model's edit strategy to QSqlTableModel::OnFieldChange and when user edits the table directly it returns the same error too. Is it a problem with model or my database connection?

[JD2000]

How does

lsn.deleteLesson(ui->tableView_lessons->currentIndex())

lsn.deleteLesson(ui->tableView_lessons->currentIndex())

To copy to clipboard, switch view to plain text mode 

In your button clicked calling function relate to

void lessons::deleteLesson(QModelIndex index)
{
QSqlTableModel *model = this->lessonsTable()
.....
}

void lessons::deleteLesson(QModelIndex index)
{
QSqlTableModel *model = this->lessonsTable()
.....
}

To copy to clipboard, switch view to plain text mode 

You are passing a tableview index in the calling function to who knows what in the deleteLesson slot.

Also have you connected the signal and slot properly?

[numbat]

Also, get rid of the removeColumn and hide it in the view instead.