sql android something seems to b wrong how do you deduce from a cursor the query status

Question

i have this code :

    private void insertValus() {
        ContentValues initialValues = new ContentValues();


          for (int i = 0 ; i < COUNTRIES.length ; i++){

              Character tmp = (Character)COUNTRIES[i].charAt(0);

              initialValues.put(VALUE, COUNTRIES[i]);
              initialValues.put(TYPE, "country");
              initialValues.put(LETTER,tmp.toString(tmp));

          db.insert(TABLE_NAME, null, initialValues);
          }
    }

public boolean existInDataBase(String userChoice) {
        boolean returnval = true;
        //gameList[0]

        Cursor cursor = db.query(TABLE_NAME, new String[] {VALUE}
        ,VALUE+" like " + "'%"+ userChoice +"%'", null, null, null, null);

        if (cursor != null)//i always enter here even if the string is no country
            returnval = false;

        return returnval;

and what ever i insert even if the query result should b false(meanning cursor == null)

and two more question

1. how can i see the database that i have build in the emulator??

   2.should i run him outside my app and then to append it to my app or in first compiltion at user he will suffer a little overhead in the first time he use this app?

Answer 1

Well, first off, when you want to check if a query returned without results, rather than check if cursor == null, you want to have an if statement like

if(! doesMoveExist.moveToFirst())

At least that's how I'm doing it, and it seems to be working fine for me.

Additionally, for your emulator, the databases are stored inside the image file, not as separate files on your hard drive.