[Solved] error while performing query multiple "insert or replace" with sqlite and Qt 4.8
-
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")@ -
Hi,
Could you post the code where you use this query ?
-
find the problem.
the version of sqlite is 3.7.7 and need 3.7.11 to multiple insert
thanks. -
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 :)