1. Download our Official Android App: Forums for Android!

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 Lurker
    Thread Starter
    Rank:
    None
    Points:
    25
    Posts:
    2
    Joined:
    Mar 15, 2010

    Mar 15, 2010
    2
    0
    25
    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.
     

    Advertisement

Share This Page

Loading...