Re: [android-developers] Creating SQLite DB

2011-03-15 Thread Kamil Michalak
Did you try this.getApplicationContext().openOrCreateDatabase(DATABASE_NAME, Context.MODE_PRIVATE, null); ? W dniu 14.03.2011 01:46, David Williams pisze: All, I am trying to create an SQLite DB but for some reason it's not working. My logic performs the following. db.openDatabase(Global

Re: [android-developers] Creating SQLite DB

2011-03-14 Thread Nadeem Hasan
Not strictly. You can always use the projection map. -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+u

Re: [android-developers] Creating SQLite DB

2011-03-14 Thread Greg Donald
On Mon, Mar 14, 2011 at 12:40 PM, David Williams wrote: > > Shame that I can't connect to the this DB with Toad for MySQL, but I can live > with the > sqlite3 for now :) http://code.google.com/p/sqlite-manager/downloads/list -- Greg Donald destiney.com | gregdonald.com -- You received this m

Re: [android-developers] Creating SQLite DB

2011-03-14 Thread Kostya Vasilyev
14.03.2011 20:40, David Williams ?: 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 unde

Re: [android-developers] Creating SQLite DB

2011-03-14 Thread David Williams
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

Re: [android-developers] Creating SQLite DB

2011-03-14 Thread Kostya Vasilyev
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 -

Re: [android-developers] Creating SQLite DB

2011-03-14 Thread David Williams
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 ap

Re: [android-developers] Creating SQLite DB

2011-03-14 Thread Kostya Vasilyev
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

Re: [android-developers] Creating SQLite DB

2011-03-14 Thread David Williams
Ok, I think I have been able to resolve this now :) Took a look at the notepad demo and that helped a lot. One other question, once I have my database and I start to create tables for it and programatically start to populate these tables with data, is there any way (any tool) that I can take

[android-developers] Creating SQLite DB

2011-03-13 Thread David Williams
All, I am trying to create an SQLite DB but for some reason it's not working. My logic performs the following. db.openDatabase(GlobalVars.DATABASE_NAME, null, 0); This simply tries to open my DB. If the DB doesn't exist it will throw an exception, which I can check, but I would suspect th