Android: file in storage not created

Houge · 09-13-2016 09:23 PM

Hello, i need some help with creating files on android.
What i need:
1. Create sqlite database
2. Insert some rows inside
3. Read rows

Sample project is in attachment.
When building on PC it works fine, but on Android file is not created and sqlite say "SQL not connected".

What am i doing wrong? I tried to find a place to create a file with function SystemPath() and i tried to use almost all SYSTEM_PATH types that are connected to mobile devices, but no luck.

Tested on Galaxy Note 2 (Android 4.4) and Galaxy S7 (Android 6), results are the same.

**Esenthel** · 09-14-2016 01:53 AM

Are you adding a slash after system path?
SystemPath(SP_APP_DATA).tailSlash(true)+"file.db"
Should work fine

Houge · 09-14-2016 05:43 AM

Yes, i use:

Code:

#if MOBILE

    path = SystemPath(SP_APP_DATA);

    path = path.tailSlash(true) + "testdb.db";

#endif

**Esenthel** · 09-14-2016 10:33 AM

Thank you for reporting the issue.

I was able to reproduce the problem with the provided project.
I will investigate this and try to solve the problem ASAP.

**Esenthel** · 09-14-2016 10:53 AM

Sorry for the problem.
Simply forgot to convert \ slashes to / on non-Windows platforms for SQLite function smile

Fix is now available on GitHub.
Tested on Galaxy Note4 and works OK now.

Houge · 09-14-2016 11:39 AM

Thank you very much! I will check it later today smile

Zervox · 09-15-2016 04:19 AM

I thought everyone used / for paths, I know I do(whenever I see a \ I make it / ). smile

Glad this was fixed though. wink

Android: file in storage not created
Author	Message