Android Question SQLite compatibility with Android 4.2

[DickD]

I have an app that uses SQLite and runs on several different recent Android platforms but crashes and burns on the very first initialization statement on Android 4.2.2 on a Samsung tablet (model GT-P5113). The error is just "could not open database". I wonder if "DirRootExternal" is not a valid folder or directory name on this older tablet. But the actual path /storage/emulated/0 does exist. Maybe the folder is locked or protected?

SQL1.Initialize(File.DirRootExternal & "/MyFolder", DBname, True)

 

[DickD]

I have an app that uses SQLite and runs on several different recent Android platforms but crashes and burns on the very first initialization statement on Android 4.2.2 on a Samsung tablet (model GT-P5113). The error is just "could not open database". I wonder if "DirRootExternal" is not a valid folder or directory name on this older tablet. But the actual path /storage/emulated/0 does exist. Maybe the folder is locked or protected?

SQL1.Initialize(File.DirRootExternal & "/MyFolder", DBname, True)

Nevermind. I had to add the command File.MakeDir to create the directory. Although in testing on other Android versions I didn't have to do this. Go Figure.

 

[Erel]

BTW, I don't recommend you to use File.DirRootExternal. Use File.DirDefaultExternal instead. Or better use RuntimePermissions.GetSafeDirDefaultExternal("").