[Solved] Android Database help needed

by


Say, you have the corresponing row id of item which is long clicked in a variable rid. Then run the following query: 

  String q = "SELECT * FROM TABLE_NAME where(ROW_ID like '"+rid+"')";
  Cursor c = db.rawQuery(q, null); //  db is a object of SQLiteDatabase type

Then retrieve TITLE_ID and STORY_ID like:

              if(c.getCount() == 0)
              {                   
                 //No entry found
              }
              else  {
                  c.moveToFirst();
                  do {
                      String titleid = c.getString(c.getColumnIndex("TITLE_ID")); 
                      String storyid = c.getString(c.getColumnIndex("STORY_ID"));
                      } while (c.moveToNext());                 
            c.close();

Then use them as you like 🙂

6

solved Android Database help needed