Update query

Cannot update a table with this code

Code:

---

QString str;
int ord = n_ord->text().toInt();
query = QSqlQuery ("UPDATE leg SET dip = '"+ str +"'  WHERE n_ord = "+ ord +"  LIMIT 1");

---

"n_ord" is an integer primary key table field and "ord" its actual value

Can someone helps ?
Thanks in advance

What's the error you get?

I suggest you use it this way

Code:

---

query = QSqlQuery (QString("UPDATE leg SET dip = '%1'  WHERE n_ord = %2  LIMIT 1").arg(str).arg(ord));

---

It works, thank you !
Why does my previous code fail in QT ? In Java, for instance, it is correct ...

To avoid possible injections have a look at QSqlQuery::prepare().