QSqlQuery bindValue problem

Dan3460

void CompanyInfo::on_zip_editingFinished()
{
  QSqlQuery query;
  query.prepare("update company set zip=:zip");
  query.bindValue(":zip",ui->zip->text());
  query.exec();
}

void CompanyInfo::on_st_editingFinished()
{
  QSqlQuery query;
  query.prepare("update company set st=:st");
  query.bindValue(":st",ui->st->text());
  query.exec();
    qDebug() << query.lastError();
}

In the above statements the zip works perfectly but the st gives me an "Parameters count mismatch". On the form both fields are line edits, even more the "st" is a copy of "zip", the columns in the database have exactly the same size and type (VARCHAR(10)). Completely lost...I tried putting "()" around the column name on the prepare statement and :st, but get the same error. I have another 6 similar statements on this sheet all work fine.

Dan3460

Solved my problem, i did not realized that when the database was created an extra " was added to the name of the column. When using SQLite there is no way to see exactly the name of the columns of a table. It shows you the creation command and because the extra " was on a line break i could not see it. Drove me crazy for a full day.