SQLite queries always return empty cursor

Question

I'm making an app where I need to store data for each day and it would be helpful if i could easily filter it, so i decided to learn about SQLite databases, found tutorial (several actually), followed it and in the end always got the same result - empty cursor.

enter public Day getDay(int year, int month, int day) {
    Day ret = null;

    SQLiteDatabase db = this.getReadableDatabase();
    Cursor c = db.rawQuery("SELECT '*' FROM '" + TABLE_DAYS + "'", null);
    Log.d("DATA", "entries found: " + c.getCount());
    c.close();
    db.close();
    return ret;
}

Method to insert new row seems to be functional as it returns expected number, but even though this is called just afterwards, it returns empty Cursor. I've read many tutorials and SO posts without finding a fix. I also tried metod .query(...) with same result.

i'm faced same problem with android P, This solution saved me: stackoverflow.com/a/53258585/9967174 — Ayoub Anbara
– Ayoub Anbara, Commented Nov 2, 2019 at 21:41

PPartisan · Accepted Answer · 2016-07-12 18:25:01Z

1

It may be worth using the query() method in place of rawQuery() in order to avoid future syntax errors. The following will achieve the same outcome as your rawQuery() by returning the data for all rows.

Cursor c = db.query(TABLE_DAYS, null, null, null, null, null, null);
c.getCount();

answered Jul 12, 2016 at 18:25

PPartisan

8,2614 gold badges31 silver badges51 bronze badges

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

1 Comment

njzk2 Over a year ago

yes. Always use those methods instead of trying to write SQL yourself.

Damian Kozlak · Accepted Answer · 2016-07-12 18:13:58Z

0

Use db.rawQuery("SELECT * FROM " + TABLE_DAYS + "", null);

edited Jul 12, 2016 at 18:13

Damian Kozlak

7,09310 gold badges47 silver badges51 bronze badges

answered Jul 12, 2016 at 18:10

Rishav Sengupta

2412 silver badges4 bronze badges

Comments

Damian Kozlak · Accepted Answer · 2016-07-12 18:14:05Z

0

try removing the quotes from SELECT * FROM

edited Jul 12, 2016 at 18:14

Damian Kozlak

7,09310 gold badges47 silver badges51 bronze badges

answered Jul 12, 2016 at 18:08

tibbi

2495 silver badges29 bronze badges

Comments

Damian Kozlak · Accepted Answer · 2016-07-12 18:15:52Z

0

Replace

Cursor c = db.rawQuery("SELECT '*' FROM '" + TABLE_DAYS + "'", null);

With

Cursor c = db.rawQuery("SELECT * FROM "+ TABLE_DAYS ,null);

edited Jul 12, 2016 at 18:15

Damian Kozlak

7,09310 gold badges47 silver badges51 bronze badges

answered Jul 12, 2016 at 18:13

Priya Singhal

1,29111 silver badges17 bronze badges

1 Comment

Damian Kozlak Over a year ago

I have fixed your formatting, you don't have to destroy it again.

PecaWolf · Accepted Answer · 2016-07-13 08:45:39Z

0

Turns out the mistake was somewhere else - passed wrong parameters to method creating the database. Thanks anyway for all responses.

answered Jul 13, 2016 at 8:45

PecaWolf

771 silver badge11 bronze badges

Collectives™ on Stack Overflow

SQLite queries always return empty cursor

5 Answers 5

1 Comment

Comments

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related