SQLLite DB not working

Please provide the following:

  1. SDK Version: 39.0.0
  2. Platforms(Android/iOS/web/all): Android

Earlier this year I started building my EXPO RN mobile app. I added the EXPO SQL-Lite package into my app as my primary DB. I was building the app with Argon UI kit. In my Argon UI app, I had all of my SQL Lite code working 100%, my code was creating the DB, reading, writing and updating the DB without any issues.

Recently I started rewriting my app with UI Kitten framework. This week when I copied and pasted my DB code into my new app its not working at all.

After I insert a record (From the app UI) I get the below logged in my console.

createBudgetCategory-ExecSQL:  WebSQLResultSet {
  "insertId": 1,
  "rows": WebSQLRows {
    "_array": Array [],
    "length": 0,
  "rowsAffected": 1,

This seems to confirm that a row was inserted. Yet when I go to my “list” view screen in my app, I get no results from my select query, as shown below.

listBudgetCategories-rows:  WebSQLRows {
  "_array": Array [],
  "length": 0,
getData-data:  Array []

If anyone has any ideas on what my issue could be here, please let me know.

The full code for my SQL DB helper is linked below.
SQL Lite DB Helper

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.