Android Question SQLite Create Database

[Declan]

I am attempting to create a SQLite database.
My Code in Service_Create:

    ' Make Database directory
    Dim TargetFolder As String
    If File.ExternalWritable Then TargetFolder = File.DirRootExternal Else TargetFolder = File.DirInternal
    File.MakeDir(TargetFolder, "/products/data/")
   
    ' Setup SQL
    SQL0.Initialize(File.DirRootExternal, "/products/data/products.db", True) <--- ERROR HERE

However, I receive the following error:

android.database.sqlite.SQLiteCantOpenDatabaseException: unknown error (code 14): Could not open database

 

[klaus]

Try: SQL0.Initialize(TargetFolder, "/products/data/products.db", True)

 

[Declan]

I have tied "SQL0.Initialize(TargetFolder, "/products/data/products.db", True)"
Same error.
I am running Android 6.0

 

[imbault]

try :

SQL0.Initialize(File.DirRootExternal & "/products/data/", "products.db", True)

or better with your code

SQL0.Initialize(TargetFolder & "/products/data/", "products.db", True)

 

[Declan]

I ha

try :

SQL0.Initialize(File.DirRootExternal & "/products/data/", "products.db", True)

or better with your code

SQL0.Initialize(TargetFolder & "/products/data/", "products.db", True)

I have tried that too, same Error.

 

[Mahares]

This code will do it for you:

Sub Service_Create
    Dim TargetFolder As String
    If File.ExternalWritable Then TargetFolder = File.DirRootExternal Else TargetFolder = File.DirInternal
    File.MakeDir(TargetFolder, "products/data")
    SQL0.Initialize(TargetFolder & "/products/data", "products.db", True)
End Sub

 

[klaus]

I tested your code from post#1 on my Samsung Galaxy S6 Android 6.0.1.
Attached my test project.

By the way, the code in your first post is incoherent.
You define a TargetFolder, but you dont use it.
With your code, if File.ExternalWritable = False the code won't work.

 

[Declan]

This code will do it for you:

Sub Service_Create
    Dim TargetFolder As String
    If File.ExternalWritable Then TargetFolder = File.DirRootExternal Else TargetFolder = File.DirInternal
    File.MakeDir(TargetFolder, "products/data")
    SQL0.Initialize(TargetFolder & "/products/data", "products.db", True)
End Sub

I still receive the same Error?

 

[Mahares]

I tested it before posting and it worked just fine. Here is attached the full zipped project

 

[imbault]

Just an idea, can you make a try adding that in your manifest:

AddManifestText(<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE"/>)

 

[Declan]

Working now - I have no idea as to why it wasn't working.

 

[Declan]

Just an idea, can you make a try adding that in your manifest:

AddManifestText(<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE"/>)

Yes, I have that line in the Manifest