Android SQLite query is always empty

Question

So right now I'm using this solution in my app Ship an application with a database

In my main activity, I just want to test to make sure that the database is working, so all I'm doing it a simply query to get some names, all I did was add 3 lines(commented where I added them):

       DatabaseHelper myDbHelper;
       SQLiteDatabase myDb = null;

       myDbHelper = new DatabaseHelper(this);
       /*
        * Database must be initialized before it can be used. This will ensure
        * that the database exists and is the current version.
        */
        myDbHelper.initializeDataBase();
        Cursor c;
        String s = null;
        try {
           // A reference to the database can be obtained after initialization.
           myDb = myDbHelper.getWritableDatabase();
//the next 3 lines are all I added
           c = myDb.rawQuery("select name from breads", null);
           s = c.getString(1);
           c.close();
           /*
            * Place code to use database here.
            */
        } catch (Exception ex) {
           ex.printStackTrace();
        } finally {
           try {
               myDbHelper.close();
           } catch (Exception ex) {
               ex.printStackTrace();
           } finally {
               myDb.close();
           }
       }

However, s just remains empty. If I do the exact same query select name from breads in the console, I will get data. Does anyone have any ideas?

define empty please. Do you mean an empty string or null?

WarrenFaith
– WarrenFaith

2011-03-27 23:34:30 +00:00
Commented Mar 27, 2011 at 23:34 — WarrenFaith
– WarrenFaith, Commented Mar 27, 2011 at 23:34

Corey Sunwold · Accepted Answer · 2011-03-27 23:34:32Z

4

myDb = myDbHelper.getWritableDatabase();
//the next 3 lines are all I added
c = myDb.rawQuery("select name from breads", null);
c.moveToFirst(); // ADD THIS
s = c.getString(1);
c.close();

answered Mar 27, 2011 at 23:34

Corey Sunwold

10.3k6 gold badges53 silver badges55 bronze badges

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

Collectives™ on Stack Overflow

Android SQLite query is always empty

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related