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: https://stackoverflow.com/a/53258585/9967174 — Ayoub Anbara, Nov 02 '19 at 21:41

score 1 · Accepted Answer · answered Jul 12 '16 at 18:25

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 '16 at 18:25

PPartisan

8,173
4
29
48

yes. Always use those methods instead of trying to write SQL yourself. – njzk2 Jul 12 '16 at 18:32

score 0 · Answer 2 · edited Jul 12 '16 at 18:14

0

try removing the quotes from SELECT * FROM

edited Jul 12 '16 at 18:14

Damian Kozlak

7,065
10
45
51

answered Jul 12 '16 at 18:08

tibbi

249
4
27

score 0 · Answer 3 · edited Jul 12 '16 at 18:13

0

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

edited Jul 12 '16 at 18:13

Damian Kozlak

7,065
10
45
51

answered Jul 12 '16 at 18:10

Rishav Sengupta

241
2
4

score 0 · Answer 4 · edited Jul 12 '16 at 18:15

0

Replace

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

With

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

edited Jul 12 '16 at 18:15

Damian Kozlak

7,065
10
45
51

answered Jul 12 '16 at 18:13

Priya Singhal

1,261
11
16

I have fixed your formatting, you don't have to destroy it again. – Damian Kozlak Jul 12 '16 at 18:16

score 0 · Answer 5 · answered Jul 13 '16 at 08:45

0

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

answered Jul 13 '16 at 08:45

PecaWolf

77
1
11

SQLite queries always return empty cursor

5 Answers5