[Qt-interest] Proper way to update a BLOB field

[Eric Landuyt]

Hello David,

DB> QString str = "UPDATE MyTable SET x='" + QString::number(myClass->x) +
DB>     "', y='" + QString::number(myClass->y) +
DB>      ", headerState" + myClass->byteArray +
DB>       " WHERE id='" + QString::number(myClass->id));

as Andre suggested, you should use placeholders.
Also, it looks like an '=' is missing right behind your 'headerState' column.

--
Eric Landuyt, Developer - mailto:eric at datarescue.be
DataRescue sa/nv - http://www.datarescue.com