Yes I am. I tested it and verified that it is the database file that my application has created.
Any other suggestions ? Emre > Date: Tue, 18 Aug 2009 09:16:23 -0700 > Subject: [android-developers] Re: Accessing the sqlite3 database via shell ? > From: marc...@android.com > To: android-developers@googlegroups.com > > > On Tue, Aug 18, 2009 at 8:05 AM, Emre A. Yavuz<eayl...@hotmail.com> wrote: > > > > Hi, > > > > I've been using the "SQLiteOpenHelper" class to create/open a database for > > my application. During the initialization process, I've been adding two > > tables to it and fill one of them with some data. Everything seems to be > > working fine and I'm getting no errors or whatsoever when I run my code. > > > > Then I try to access the same database via shell using the > > > > "adb -s emulator-XXXX shell" > > > > command followed by > > > > "sqlite3 /data/data/com.android.myapplication/databases/mydatabase.db" > > Are you sure that is actually the name of your database file? The > 'sqlite3' command will not complain if the file doesn't exist, it will > just create it. > > > and I am able to see that the database is created. However, when I want to > > see the contents; say the tables using ".tables", there seems to be nothing > > in the database. > > That sounds like what would happen if you specified the wrong filename. > > > I debug my code to make sure that my code executes the lines where I created > > these tables so I am wondering what the problem might be. I haven't seen > > anything with respect to that in the references, but do we have to commit > > after using the "execSQL" method ? Or am I missing something else ? > > > > Thanks for your help in advance, > > > > Emre > > > > > > > > ________________________________ > > Attention all humans. We are your photos. Free us. > > > > > > > > _________________________________________________________________ More storage. Better anti-spam and antivirus protection. Hotmail makes it simple. http://go.microsoft.com/?linkid=9671357 --~--~---------~--~----~------------~-------~--~----~ 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-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -~----------~----~----~----~------~----~------~--~---
