SirBabyface
6th September 2007, 17:54
Hi,
I've a problem in updating data using a Model/View approach.
If I try to do this:
bool PhonoLabSentenceSqlModel::setCode(int sentenceId, const QString &code)
{
QSqlQuery query;
query.prepare("UPDATE sentence SET code='?' WHERE id=?");
query.addBindValue(code);
query.addBindValue(sentenceId);
if (!query.exec()) {
return false;
}
return true;
}
But if change to this, it works fine.
bool PhonoLabSentenceSqlModel::setCode(int sentenceId, const QString &code)
{
QSqlQuery query;
QString s = "UPDATE sentence SET code='" + code + "' WHERE id=" + QString::number(sentenceId);
query.prepare(s);
if (!query.exec()) {
return false;
}
return true;
}
Does anyone know what I'm doing wrong
I've a problem in updating data using a Model/View approach.
If I try to do this:
bool PhonoLabSentenceSqlModel::setCode(int sentenceId, const QString &code)
{
QSqlQuery query;
query.prepare("UPDATE sentence SET code='?' WHERE id=?");
query.addBindValue(code);
query.addBindValue(sentenceId);
if (!query.exec()) {
return false;
}
return true;
}
But if change to this, it works fine.
bool PhonoLabSentenceSqlModel::setCode(int sentenceId, const QString &code)
{
QSqlQuery query;
QString s = "UPDATE sentence SET code='" + code + "' WHERE id=" + QString::number(sentenceId);
query.prepare(s);
if (!query.exec()) {
return false;
}
return true;
}
Does anyone know what I'm doing wrong