Kostya,

Thanks for the info.

How would I go about copying the database file from the emulator (or phone) to my computer? Where would I find the db? I do use Eclipse, but am not familiar with DDMS view (oe even what it is) nor the adb pull command. Any additional info on this would be much appreciated. I like the idea of being able to browse my database from Eclipse.
------------------------------------------------------------------------

David Williams
Check out our WebOS mobile phone app for the Palm Pre and Pixi:
<http://www.dtw-consulting.com/GolfCaddie> Golf Caddie <http://www.dtw-consulting.com/GolfCaddie> | Golf Caddie Forum <http://www.dtw-consulting.com/GolfCaddie/forum> | Golf Caddie FAQ <http://www.dtw-consulting.com/GolfCaddie/faq.html> by DTW-Consulting, Inc.



On 3/14/2011 11:13 AM, Kostya Vasilyev wrote:
14.03.2011 17:31, David Williams ?????:
is there any way (any tool) that I can take a look at the table contents so I can check that my code is populating the data in my tables as I'd expect?

You can copy the database file to the host computer and use sqlite3, which is a command-line SQlite interface. It comes with the Android SDK.

The syntax is:

    "sqlite3 <db file name>".

Reference:

http://www.sqlite.org/sqlite.html

The only thing is, database files are private to your application. Some options for dealing with this are:

- Using the emulator (which allows access to application-specific data directories, either in Eclipse's DDMS view or with "adb pull <file>");

- Writing your own SQLiteOpenHelper type class that would place the database on the memory card;

- Implementing a button in your application that would copy the database file to the memory card.
--
Kostya Vasilyev --http://kmansoft.wordpress.com
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en

--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en

<<inline: GClogo.png>>

Reply via email to