Android database query not returning any results

Question

This is my code to query my android database.

int lastID = -1;

String selectQuery = "SELECT * FROM " + TABLE_MAIN + " WHERE " + KEY_ID + " > " + lastID;

Log.i(LOG, selectQuery);
SQLiteDatabase db = this.getReadableDatabase();
Cursor c = db.rawQuery(selectQuery, null);

if (c.moveToFirst())
{
    ...
}
else
{
    return null;
}

For some reason every time this runs (I have debugged it) it always falls into the else of the if statement and I dont know why. This led me to believe that my query is wrong but I cannot see how it is wrong. I know that the table name and column name is correct because it is a globally defined variable. Is anyone able to spot my mistake? Thanks

The most obvious reason would be that your table has no data matching your selection. — laalto
– laalto, Commented Jun 8, 2015 at 14:06
try and remove the condition " WHERE " + KEY_ID + " > " + lastID; and see if it returns any data if it still don't return any data, then im guessing either the table has no data, you using the wrong database or TABLE_MAIN is not the table you expect — forcewill
– forcewill, Commented Jun 8, 2015 at 14:23

Santiago · Accepted Answer · 2015-06-08 14:12:18Z

1

Test your select like

String selectQuery = "SELECT * FROM " + TABLE_MAIN + " WHERE " + KEY_ID + " > " + "'" + lastID + "'";

Some devices (this happen to me in some devices) sqlite integer only works with > 1 without simple quotes, but numbers <= 0 need simple quotes. Why? I don't know.

answered Jun 8, 2015 at 14:12

Santiago

1,74515 silver badges23 bronze badges

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

1 Comment

kabeersvohra Over a year ago

actually this did solve my problem after testing it again...thanks!

Collectives™ on Stack Overflow

Android database query not returning any results

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related