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

Extensions
13

From the documentation

The simplest way is to upload the database into the assets of your app, see also @TIMAI2's guide METRIC RAT AI2 - Working with SQLite

Else use the file component to copy it from shared storage /Download or /Documents to the ASD and import from there

Taifun

14

Which extension are you using ? (SQLite1) ?

15

Mmmm... may be OK set column headers to false using a clock started by Screen1.Initialize?

16

Column Headers Bug now fixed, download latest version 3
Also ListFixer merged to main extension
SimpleSqliteV3

17

Android 8.1:

grafik
grafik1127×589 47.2 KB

Android 12:

grafik
grafik1130×592 47 KB

2 Likes
18

For Android <10 there is a bug (typo ?) that carried over from the original extension

return getExternalStoragePath() + "/AppInventor/data/";

should read

return getExternalStoragePath() + "/AppInventor/assets/";

Should now be fixed

For Android 12, just use //myDatabase.sqlite, extension is looking for // for asset files

19

Android 8.1 - a relative path seems to work:

grafik
grafik1138×377 34.9 KB

2 Likes
20

Android 11: (this path is redirected to the ASD)

grafik
grafik1033×287 26.3 KB

2 Likes
21

... the same of course on Android 10+

22

On Android ≤ 9 a relative path must therefore be set (at least as long as this is not adjusted in the extension).

23

Hmmm, looks like

is doubling up on /storage/emulated/0....

Will test some more

24
31

Yes, I think (and find on the forum next I post this question) this extension dont work with Android 10. The question is all my code is coded with the SqlLite extension and if I go to use the SimpleSqlite extension I will recode all my app. Really there are no way to "import" a empty (preformated with tables) database to use with sqllite? Any solution welcome. thanks. Ex. move (with the app) the database to a directory that can use the sqlite extension?...
Solved: I have used the method "dbname" of simplesqlite to change the name (and dir) of the db to the name (and dir) of db that expects the extension sqllite before import the database. To import the database I used the method ImportDatabase of simplesqlite extension. thanks.

32

You could have done exactly the same thing with Taifun's extension. Have you updated to the latest version which works with Android <=10?

33

Version 3 on Android 9:

grafik
grafik1228×472 52.5 KB

1 Like
34

@Anke, many thanks for all your help with sorting out file paths :+1:

35

I got this error:

Snipaste_2022-11-03_07-15-32
Snipaste_2022-11-03_07-15-321253×448 106 KB

after tick the returncolumnheaders then untick, this error message will not popup again.

36

Is this with the latest version ?

Try with V3 from link in first post....

37

yes, it's v3 from first post
image

38

Hmmm, just tested and you are correct. Thought I had this fixed. I made it go away, but now has come back ? More work to do....