Location of database and csv files

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Jul 23, 2011

• #2

You cannot directly access your desktop file system from the emulator. This folder is inside the emulator own file system.

 

Upvote 0

D

devlei

Active Member

Licensed User

Longtime User

• Jul 23, 2011

• #3

Thanks for the response, Erel.

Where do I place any existing sqlite or csv files that I want my B4A app to read?

 

Upvote 0

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Jul 23, 2011

• #4

Go to the Files tab in the right pane and add the required files.
These files get packaged in the APK file and are accessed with File.DirAssets.

It is not possible however to open a SQLite database in this folder. You can use DBUtils.CopyDBFromAssetsFolder to copy the file from this folder to a regular folder.

 

Upvote 0

D

devlei

Active Member

Licensed User

Longtime User

• Jul 23, 2011

• #5

Thanks, I used DBUtils.CopyDBFromAssetsFolder to copy the file to File.DirDefaultExternal and was able to access the data.

Now I have added and edited data, but the next time I run the app I am back to the same old problem of it not being able open the file in the File.DirDefaultExternal location.

How do I open this updated database file when I run the app again?

 

Upvote 0

klaus

Expert

Licensed User

Longtime User

• Jul 23, 2011

• #6

There should be no problem the second time as you had access to the database the first time, otherwise you could also use Files.DirInternal.

Best regads.

 

Upvote 0

D

devlei

Active Member

Licensed User

Longtime User

• Jul 23, 2011

• #7

Thanks, Klaus.

I am just busy going through your SQLiteDB example and hopefully that will help me resolve this issue. If not, I will post again.

 

Upvote 0

D

devlei

Active Member

Licensed User

Longtime User

• Jul 23, 2011

• #8

It seems like the SQLiteDB example uses Files.DirInternal.

The problem with that for my app is that I need to be able to synchronise the sqlite db from the device with the desktop as there is a companion desktop app that also needs to access that same sqlite db.

Any suggestions on how to achieve that?

 

Upvote 0

klaus

Expert

Licensed User

Longtime User

• Jul 23, 2011

• #9

Yes, SQLiteDB uses Files.DirInternal.
Perhaps try using Files.DirRootExternal.

Best regards.

 

Upvote 0

D

devlei

Active Member

Licensed User

Longtime User

• Jul 23, 2011

• #10

I will try that.

If I use the Files.DirRootExternal, in what folder do I place my existing sqlite db during development using the emulator?

 

Upvote 0

klaus

Expert

Licensed User

Longtime User

• Jul 23, 2011

• #11

You can also use Files.DirRootExternal with the emulator.
You to setup the emulator for sdcard and set in the IDE in the Project menu 'Can Install To External Storage'. Just tried it.

Best regards.

 

Upvote 0