I need to use sqlite databases with Qt, and data submiting is not working.
I've connected a button click to this:
void submit()
{
if(!model
->database
().
driver()->hasFeature
(QSqlDriver::Transactions)) qDebug() << "sqlite driver doesn't support transactions";
if(model->database().transaction())
{
if(model->submitAll())
{
model->query().finish();
if(model->database().commit())
{
model->query().exec();
commitBtn->setEnabled(false);
return;
}
}
}
model->database().rollback();
this,
tr("Database error"),
model->database().lastError().text());
}
void submit()
{
if(!model->database().driver()->hasFeature(QSqlDriver::Transactions))
qDebug() << "sqlite driver doesn't support transactions";
if(model->database().transaction())
{
if(model->submitAll())
{
model->query().finish();
if(model->database().commit())
{
model->query().exec();
commitBtn->setEnabled(false);
return;
}
}
}
model->database().rollback();
QMessageBox::information(
this,
tr("Database error"),
model->database().lastError().text());
}
To copy to clipboard, switch view to plain text mode
I've once tried without the query stop stuff but no success, two days since i've started searching around a way but nothing. I hope you guys can help me, thanks in advance, and sorry my bad english.
Bookmarks