🟥 [FREE] SimpleSqlite - an extension for working with SQLite Databases

Don't remember this being an issue previously, not heard of this before. I have tested a 3 screen project in companion, with SimpleSqlite loaded in each screen (not doing anything) and I see no crashing.

Are you closing/unloading databases before switching screens ?

Do you need multiple real screens, you could probably use virtual screens for your app

I have attached the .aia file with modification adding Screen4 .

When the Search button in Screen1 is clicked, Screen4 opens but takes time and the app freezes.

Please, Let me know why it is so?

Thanks and regards
St
Bible (1).aia (515.2 KB)
ephen

I am looking

Why are you using V2 of SimpleSQLite? Use the latest version V4 which includes the listFixer method along with other improvements.

You appear to have got yourself into a muddle. You only have one bible database, so why does the user have to pick a file from Shared Directories ? Just import it to the main database from assets and work from there, or as I did in my previous example, download it to your ASD and set the filepath there.

Different real screens should be considered as different apps, you need to ensure you close the database on one screen before loading and opening the database on another. This I why I suggested virtual screens.