From the first error message it looks like you are using an outdated version of the extension...
Click the question mark in the designer next to the extension to find it out... You should use version 2 or 2a... you always can download the latest version from the download folder...
The version history is here App Inventor Extensions: SQlite | Pura Vida Apps
Taifun
I put a simple SQL to verify if it works and I can say that the APK works
There seems to be a problem in the code somewhere ( I have not figured it out/ fixed it yet). Tick the box in the designer for column headers. If you do not want header columns returned then set this to false with the property block (not in Screen.Initialise)
That's why I already asked in post #9:
Yes, it is outdated, I buyed it in 2020: SQlite database extension. Version 1j as of 2020-10-30.
Extension Version: 1
Date Built: 2020-10-30
And this version works with my blocks!
Ok, you probably realized now how important it is to always use the latest version of an extension ...
Each year Google adds new requirements into the Android system and if you do not keep updated, old versions will stop working
Taifun
Sure, until now it worked well but I was developing on Android 8...
Well, I can say that alone your extension works also with companion so it should work with Taifun SQLite updated extension. Instead, if I build the APK both extensions work together.
I read your documentation a little bit better and now I am able to open and work with a database using the companion and the APK. But I would be sure if I did it correctly. I tryed closing the (default) database and also without closing it and seems to work always. I uploaded the DB using the Designer Upload File button and set the DB just setting the name, not using Import. Anyway I attached all my test code in the image. May you say if this approach is correct or not?
yes, checking ReturnColumnHeaders did the trick. Thank you
Column Headers Bug now fixed, download latest version 3
Also ListFixer merged to main extension
SimpleSqliteV3
Good job, it works perfectly!
I mean that my example/test code works perfectly with the newer release. I do not use ImportDatabase, instead I use DBName and I upload the DB using Designer Upload button. In this way my test code here works on Android 8.0 and Android 11
Ok, but my (workaround) blocks for the path to the assets shouldn't really be required. The extension should intercept that.
Yes, I agree, should be better
What do you feel about Android 12 and 13? An app designed for Android 11 may run correctly in Android 12 and 13 as well?
"Should" be fixed now, download latest V3 from link above
