Android Sqlite3 database: Cursor in SQLite is not returning null?

Question

Could someone advise me why I am only getting true result, even though that record does not exist in my database?

For clarification, in my table, _id is the telephone number.

Here's my code:

public boolean checkifExists(String number){
    String[] columns = new String[]{"_id"};
    String[] wehreargs = new String[]{number};
    this.openDataBase();
    if (myDataBase.query("mytable", columns, "_id=?", wehreargs, null, null, null)==null){
        myDataBase.query("mytable", columns, "_id=?", wehreargs, null, null, null).close();
        this.close();
    return false;
    } else {
        myDataBase.query("mytable", columns, "_id=?", wehreargs, null, null, null).close();
        this.close();
        return true;
    }
}

Doug Currie · Accepted Answer · 2012-06-04 20:38:39Z

1

query returns a Cursor which is always non-null. You must read from the Cursor to get the result of the query

answered Jun 4, 2012 at 20:38

Doug Currie

41.4k1 gold badge103 silver badges121 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rafael T · Accepted Answer · 2012-06-04 20:55:02Z

0

As @DougCurrie mentions: Query is returning non-Null cursors only: revised your code:

public boolean checkifExists(String number){
    String[] columns = new String[]{"_id"};
    String[] wehreargs = new String[]{number};
    this.openDataBase();
    Cursor c = myDataBase.query("mytable", columns, "_id=?", wehreargs, null, null, null)
    boolean hasEntry = c.moveToFirst()
    c.close();
    this.close()
    return hasEntry;
}

answered Jun 4, 2012 at 20:55

Rafael T

15.7k15 gold badges85 silver badges148 bronze badges

Collectives™ on Stack Overflow

Android Sqlite3 database: Cursor in SQLite is not returning null?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related