Like I said before, are there maybe some other js files that need to be changed as I revert sql.js to 1.8.0? dmxCapacitorSQLite.js was released a month ago, so maybe it is not compatible with 1.8.0
well did you insert any records to your database? Maybe it is simply empty.
Try adding a flow to add records and trigger it with a button. Then reload the flow with the database select, so new records are fetched. It is not done automatically.
No you are looking at different sqlite database within Wappler. From within Wappler you have a development only copy of local sqlite database file.
While in runtime, in the browser or in your mobile app - a user specific database is created. And that one is probably empty as you don’t have anything in it.
That is why I suggested adding some records next to the query.
Sorry about this, it seems I forgot to enable “auto-run” on the page flow, so now it’s working with bootstrap and sql.js 1.8.0. Not with F7 but that’s another thing.
Back on this:
This is not very clear. Just followed the tutorial as teodor explains.
I just picked the .sqlite3 file generated by Wappler, the one is placed on the project folder, the same that page-flow loads. And now that it’s solved, I can see the results.