lundi 29 juin 2015

SQLiteDatabase, Updated Values not matching in select query

I got stuck in a very strange issue. Where i am able to update the db Values when when trying to fetching the rows corresponding to that values i am not getting anything.

enter image description here In this database, i inserted these rows, the date were 29, june for the last two rows, but when i updated these dates to 15, and tried to fetch the rows corresponding to that date

    String where = COL_DATE + " = ?";
    String[] args = {"15"};
   Cursor cursor = db.query(TABLE_DAILY_EXPENSE, null, where, args, null, null, null);

Then Log.d(TAG, "Cursor count= " + cursor.getCount());gives 0`

Where as by fetching through month, it gives count = 2. So i concluded, that somewhere after updating the fields, its not matching that updated field for fetching that corresponding row. But why this is happening?? No Idea.

`

Aucun commentaire:

Enregistrer un commentaire