2

I have a android application which i am developing using eclipse. I have a database in this application to which I cam make inserts and updates etc. Everything working fine so far. But I to check the status of a table at any given instance I need to do a query using the java code to see what is the status. Status i mean the row contents in my tables. I use the below code:

Cursor mCursor = mDb.query(MY_TABLE, new String[] { KEY_ROWID,
                KEY_TITLE },
                whereclause, null, null, null, sortOrder);

I have some experience working on windows applications where I know the back end of the application can be accessed by using the SQL Server Management Studio and writing the queries directly like, select * from MY_TABLE, will give the results

I suppose there should be a similar application for SQLite or atleast a Eclipse plugin to do this job easy for me. Just to run any queries on my application table. But I have very little idea of SQLite so some one plase let me know the details of this. Thank you for your time and help.

Rasel
  • 15,499
  • 6
  • 40
  • 50
Vinod
  • 31,933
  • 35
  • 96
  • 119
  • http://stackoverflow.com/questions/5762389/how-to-view-data-saved-in-android-databasesqlite – Rasel Aug 03 '11 at 03:07
  • Thank you very much for the link. Can you please mark it as a answer so that I an accept it as the answer. Thank you very much once again. – Vinod Aug 03 '11 at 03:31
  • Hi Rasel. I see the definitions of the table fine. But the data is always empty. Is it that I cannot see it when running the application? or is it any other problem? – Vinod Aug 03 '11 at 04:24
  • See http://coderzheaven.com/2011/04/sqlitemanager-plugin-for-eclipse/ – Rasel Aug 03 '11 at 04:30

1 Answers1

0

How to view data saved in android database(SQLite)?

Community
  • 1
  • 1
Rasel
  • 15,499
  • 6
  • 40
  • 50