SQLLite DB not working

Expo SDK
1

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

2

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