Android Question Database error

[anaylor01]

Here is the error I get on the emulator:
An error has occurred in sub:
main_activity_create(B4A line: 68)
sql1.initialize(file.dirassets,"Databaseandroiddatabase.sqlite. sqlitecantoopendatabaseException: Unable to open database file
Here is line 68 of the code that is causing the error:
SQL1.Initialize(File.DirAssets, "Database.db", True)
I have created a database called Database with SQLiteStudio and added it to the files in B4A.
Any ideas?

 

[JohnK]

Could it possibly be that most databases are expected to be R/W while the assets folder is RO? just a first guess.

 

[DonManfred]

Any ideas?

DirAssets is readonly. You cannot use a Database from there.

FIRST Copy the database to a writeable storage. Then use it.

Get inspired: https://www.b4x.com/android/forum/threads/dbutils-android-databases-are-now-simple.8475/

 

[DonManfred]

Could it possibly be that most databases are expected to be R/W while the assets folder is RO? just a first guess.

Good guess. You are absolutely right.

 

[anaylor01]

Thanks guys.