1. Check out our companion app, Forums for Android! Download from Google Play

Getting null Cursor from DBAdapter inspite of record being there in table.

Discussion in 'Android Apps & Games' started by rraiyarela, Dec 17, 2010.

  1. rraiyarela

    rraiyarela New Member
    Thread Starter

    Mar 15, 2010
    Hello All,

    In my android application i have created a class to handle sqlite database & table.
    In that i have created one function which returns all the records in the table.

    Below is the code i m using

    Cursor result=null;result = db.query(DATABASE_TABLE1, new String[]{KEY_ID,KEY_UID,KEY_TICKETID},null, null, null, null, null);

    return result;

    inspite of records being there i m getting a empty cursor.

    But if i write

    System.out.println("getAllItemsCursor(), " + result.getCount());

    before return result statement i m getting the records properly i.e. non-empty cursor.

    Can anybody guide me where i m making a mistake.


Share This Page