search

storesafe / cordova-sqlite-storage

A Cordova/PhoneGap plugin to open and use sqlite databases on Android, iOS and Windows with HTML5/Web SQL API
Other
2.14k stars 713 forks source link

Error with ON CONFLICT syntax #969

Open rushiraj111 opened 3 years ago

rushiraj111 commented 3 years ago

The sqlite documentation says it supports upsert since version 3.24.0.

https://www.sqlite.org/lang_UPSERT.html

While I am getting an error using it with this plugin. Please let me know What version of Sqlite is being used in this plugin.

ERROR:

near "ON": syntax error (code 1 SQLITE_ERROR[1]): , while compiling:

roitto commented 2 years ago

This plugin uses sqlite version 3.32.3. So the "on conflict" is not supported.