It might help others if you told us what the problem and solution were.
On Tue, Aug 18, 2009 at 12:41 PM, Emre A. Yavuz<eayl...@hotmail.com> wrote: > Problem solved, thanks for the comments. > > Emre > > ________________________________ > From: eayl...@hotmail.com > To: android-developers@googlegroups.com > Subject: [android-developers] Re: Accessing the sqlite3 database via shell ? > Date: Tue, 18 Aug 2009 13:05:26 -0400 > > 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. >> > > >> > >> >> </html > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
