Android Question SQLite Create Database

Declan · Apr 1, 2017

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

B4X:

    ' 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:

B4X:

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

klaus · Apr 1, 2017

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

Declan · Apr 1, 2017

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

imbault · Apr 1, 2017

try :

B4X:

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

or better with your code

B4X:

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

Declan · Apr 1, 2017

I ha

imbault said:
try :

B4X:

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

or better with your code

B4X:

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

I have tried that too, same Error.

Mahares · Apr 1, 2017

This code will do it for you:

B4X:

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 · Apr 1, 2017

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 · Apr 1, 2017

Mahares said:

This code will do it for you:

B4X:

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 · Apr 1, 2017

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

imbault · Apr 1, 2017

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

B4X:

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

Declan · Apr 1, 2017

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

Declan · Apr 1, 2017

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

B4X:

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

Yes, I have that line in the Manifest

Android Question SQLite Create Database

Declan

Well-Known Member

klaus

Expert

Declan

Well-Known Member

imbault

Well-Known Member

Declan

Well-Known Member

Mahares

Expert

klaus

Expert

Declan

Well-Known Member

Mahares

Expert

Attachments

imbault

Well-Known Member

Declan

Well-Known Member

Declan

Well-Known Member

Similar Threads

Android Question SQLite Create Database

Well-Known Member

Expert

Well-Known Member

Well-Known Member

Well-Known Member

Expert

Expert

Well-Known Member

Expert

Attachments

Well-Known Member

Well-Known Member

Well-Known Member

Similar Threads

Privacy & Transparency

Privacy & Transparency