Thanks, That worked a treat. Am able to see what is going on in my DB now :)Shame that I can't connect to the this DB with Toad for MySQL, but I can live with the sqlite3 for now :)
One more question if I may, do all id fields have to be prefixed with a underscore like _id ? Right now (not sure what version of sql WebOS uses) all my database tables simple have columns called id. If I do need to prefix all my id columns with an underscore then what is the reason for that? A restriction/limitation of sqlite3?
------------------------------------------------------------------------ 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 1:10 PM, Kostya Vasilyev wrote:
14.03.2011 19:40, David Williams ?????:How would I go about copying the database file from the emulator (or phone) to my computer? Where would I find the db?To copy from the emulator:- In Eclipse, switch to DDMS perspective (toolbar on the right side or Window - Open Perspective - Other - DDMS)- Select the emulator in the pane on the left - Select the "File Explorer" pane on the right - Navigate to /data/data/<your package name>/databases- Press the icon in the top-right corner that looks like a floppy disk with a red arrowAlternatively: - From the host computer's command window, type:- "adb pull /data/data/<your package name>/databases/<your database file name>"to pull the file to the host computer.I do use Eclipse, but am not familiar with DDMS view (oe even what it is) nor the adb pull command.http://developer.android.com/guide/developing/debugging/ddms.html http://developer.android.com/guide/developing/tools/adb.html -- 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 athttp://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>>
