diff options
| -rw-r--r-- | plugins/Dbx_sqlite/src/dbevents.cpp | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/plugins/Dbx_sqlite/src/dbevents.cpp b/plugins/Dbx_sqlite/src/dbevents.cpp index 81fc24fa39..55d4cd70aa 100644 --- a/plugins/Dbx_sqlite/src/dbevents.cpp +++ b/plugins/Dbx_sqlite/src/dbevents.cpp @@ -330,7 +330,7 @@ int CDbxSQLite::SetEventJson(MEVENT hDbEvent, const char *szSetting, DBVARIANT * CMStringA tmp(FORMAT, "$.%s", szSetting);
{
mir_cslock lock(m_csDbAccess);
- sqlite3_stmt *stmt = InitQuery("UPDATE events SET data=json_set(data, ?, ?) WHERE id = ?;", qEvSetJson);
+ sqlite3_stmt *stmt = InitQuery("UPDATE events SET data=json_set(cast(data as text), ?, ?) WHERE id = ?;", qEvSetJson);
sqlite3_bind_text(stmt, 1, tmp, tmp.GetLength(), nullptr);
switch (dbv->type) {
|