QSqlQuery query_journ(db);
QSqlQuery lastId(db);
QTime exitTime = QTime::currentTime();
QString strExitTime;
strExitTime = exitTime.toString("hh:mm:ss");
QDate work_date = QDate::currentDate();
QString olo;
olo = work_date.toString("dd-MM-yyyy");
QString lastId_select ="SELECT last_insert_rowid() FROM work_journal";
lastId.prepare(lastId_select);
lastId.exec();
QString aqw;
aqw = lastId.lastInsertId().toString();
QMessageBox zx;
zx.setText(aqw);
zx.exec();
QString query_journ_select ="UPDATE work_journal SET exit_time='%1', where id='%2'";
QString strQ = query_journ_select.arg(strExitTime).arg(aqw);
if(!query_journ.exec(strQ)){
qDebug()<<tr("Невозможно сделать вставку")<< query_journ.lastError();
}
И в консоли такая ошибка:
QSqlQuery::value: not positioned on a valid record
"Невозможно сделать вставку" QSqlError(1, "Unable to execute statement", "near "where": syntax error")