SimpleSQLite1, File1, Filescope and ASD...Retrieving the data from the table

MIT App Inventor Help
, ,
1

The SQLite in the ASD is opened successfully and the SELECT retrieves the data from the table successfully.
Resource Path: /storage/emulated/0/Android/data/[ASD]/files/abc.sqlite3
Filescope is changed to App, works successfully and data is also retrieved from the table.

But if another directory is mentioned in the path, FileScope is also changed. The database is opened successfully, but no data retrieved from the Table...
Resource Path: /storage/emulated/0/myData/abc.sqlite3
Does not work, though the Database is opened successfully but no data is retrieved from the Table. Filescope is changed to Legacy/ Private/ Shared

What is the correct solution to this?

Thanks and regards
Stephen

2

Use a Shared Directory to store your database

3

Use a relative absolute path to shared storage
For example /storage/emulated/0/Download/myData/abc.sqlite3
See also Some basics on Android storage system

Taifun

4

The SimpleSqlite extension generally requires an absolute path.

6

Thank you for the response.

JewelFilePicker, solves the problem. Picked the Database through it...

Applied the filePath to SimpleSQLite.DBName

It worked wonders!!!

Thanks to the JewelFilePicker, SDK version is 30.