Capacitor SQLite query is empty

It’s not related to F7, it doesn’t work on a Bootstrap project neither

Recreated the whole tutorial and changed sql.js to 1.8.0 as you said, but nothing shows up on the query and no errors on the console.




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.

It’s not empty, already check that:

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.

Anyway, I appreciate the replies, and sorry again.