This question is locked. New answers and comments are not allowed.
Hi,
Since the last AppBuilder update, I have noticed that the SQLite Plugin in all my projects stopped working as it should. When starting the app for the first time after a fresh build, the plugin works perfectly, but when refreshing my app to get the latest updates, the plugin would stop executing my queries.
I noticed that the DB file that the plugin creates gets removed whenever I attempt to refresh my app, and it would not get created again unless I close the app completely and re-open it again. Then when attempting to execute an INSERT/UPDATE/DELETE query, the plugin would throw this error:
"error while trying to commit: cannot commit - no transaction is active", but when executing a SELECT query, the query executes without issues and gets the actual data even when the DB file is not present.
Can someone please help me with this issue?
Regards,
Nader
Since the last AppBuilder update, I have noticed that the SQLite Plugin in all my projects stopped working as it should. When starting the app for the first time after a fresh build, the plugin works perfectly, but when refreshing my app to get the latest updates, the plugin would stop executing my queries.
I noticed that the DB file that the plugin creates gets removed whenever I attempt to refresh my app, and it would not get created again unless I close the app completely and re-open it again. Then when attempting to execute an INSERT/UPDATE/DELETE query, the plugin would throw this error:
"error while trying to commit: cannot commit - no transaction is active", but when executing a SELECT query, the query executes without issues and gets the actual data even when the DB file is not present.
Can someone please help me with this issue?
Regards,
Nader