Form update problem

[thefatladysingsopera]

I am trying to update my form with the following code by the form won't save the edits.

tableModel->select();
  QModelIndex index = ui.tableView->currentIndex();
  QString sqlQuery = QString("UPDATE %1 SET firstname=:firstname, lastname=:lastname, country=:country, city=:city WHERE id=:id)").arg(tableName);
  query.prepare(sqlQuery);
  QSqlRecord recordz = tableModel->record(index.row());
 
  query.bindValue(":firstname", ui.fEdit->text());
  query.bindValue(":lastname",  ui.lnEdit->text());
  query.bindValue(":country", ui.cEdit->text());
  query.bindValue(":city",  ui.cityEdit->text());
  query.bindValue(":id", recordz.value("id").toInt());
  query.exec();
  tableModel->submitAll();

tableModel->select();
  QModelIndex index = ui.tableView->currentIndex();
  QString sqlQuery = QString("UPDATE %1 SET firstname=:firstname, lastname=:lastname, country=:country, city=:city WHERE id=:id)").arg(tableName);
  query.prepare(sqlQuery);
  QSqlRecord recordz = tableModel->record(index.row());

  query.bindValue(":firstname", ui.fEdit->text());
  query.bindValue(":lastname",  ui.lnEdit->text());
  query.bindValue(":country", ui.cEdit->text());
  query.bindValue(":city",  ui.cityEdit->text());
  query.bindValue(":id", recordz.value("id").toInt());
  query.exec();
  tableModel->submitAll();

To copy to clipboard, switch view to plain text mode