Android Question Test database location

[PeterRodwell]

I want to test a small database program with the AVD. Where do I have to put the database in my PC so that the program can find it?

 

[giga]

are you using Sqllite?

 

[PeterRodwell]

Yes.

 

[LucaMs]

You can simply put it in your app, as you must do on real device!

Add it to the "Files" tab of the IDE, then use DBUtils

 

[PeterRodwell]

You can simply put it in your app, as you must do on real device!

Add it to the "Files" tab of the IDE, then use DBUtils

But that would presumably make the database unavailable to other programs.

 

[LucaMs]

But that would presumably make the database unavailable to other programs.

Using DBUtils you should copy it from Assets to DirDefaultExternal

 

[LucaMs]

A Sub of DBUtils:

'Copies a database file that was added in the Files tab.
'The database must be copied to a writable location.
'This method copies the database to the storage card.
'If the storage card is not available the file is copied to the internal folder.
'The target folder is returned.
'If the database file already exists then no copying is done.
Sub CopyDBFromAssets (FileName As String) As String

 

[mangojack]

Peter .. Are you utilizing DBUtils ? or dealing directly with SQLite ?

It is not neccessary to involve DBUtils to do what you wish , unless you've already gone down that path.

Just create a db file on your PC then include it in your app .. by way of the IDE Files tab as LucaMS suggested.
Run your app and copy the file to a writable location ie ..

If File.Exists(File.DirDefaultExternal, "Database.db") = False Then
     File.Copy(File.DirAssets, "Database.db", File.DirDefaultExternal, "Database.db")
  End If

'then ...
  SQL1.Initialize(File.DirDefaultExternal, "Database.db", True)

'and start your SQL queries etc

Edit ..
If you do not already have these .. 2 Free DB Creation / Editing Software

SQLite Browser ... simple DB Create,View AND Edit program

SQLiteExpert Personal ... more options than above

Cheers mj