[Solved] error while performing query multiple "insert or replace" with sqlite and Qt 4.8

diego

Hi, the query work in sqlitestudio 2.1.4

lastQuery output
@"INSERT OR REPLACE INTO settings (field, value) VALUES ('modo','0'), ('server_ip_address','192.168.0.3'), ('server_login','teste'), ('server_passwd','123456'), ('server_folder','pessoal')"@

lastError output
@QSqlError(-1, "Unable to fetch row", "No query")@

SGaist

Hi,

Could you post the code where you use this query ?

diego

find the problem.
the version of sqlite is 3.7.7 and need 3.7.11 to multiple insert
thanks.

SGaist

Great you found out and thanks for sharing !

Don't forget to update the thread title prepending solved so other forum users may know a solution has been found :)