I have a ListActivity that uses a CursorAdapter to fill the rows in the view. I wrote a database helper class that gives me back results for common queries I make for my app, and it uses an SQLiteOpenHelper implementation I wrote to open the database. I use the open helper to open the database and get a cursor to pass to my CursorAdapter. Here's a code snippet:
public static Cursor getCursor(DbOpenHelper openHelper) { SQLiteDatabase db = openHelper.getWritableDatabase(); db.beginTransaction(); Cursor c = null; try { String sql = "select * from " + TABLE_NAME; c = db.rawQuery(sql, null); db.setTransactionSuccessful(); } catch (SQLException e) { Log.e("Exception on query", e.toString()); } finally { db.endTransaction(); } return c; } The problem I'm having, that I didn't have before I implemented the open helper (before I just opened the database directly without a helper), is when I click on an item, which takes me to another activity, and then go back to this activity. When it initializes everything is fine, and my list is populated fine, but when I go back from the activity that follows, the list is empty and in the LogCat I see "Invalid statement in fillWindow()". It appears from a few post I've seen that the reason is, when I requery the cursor, the database is closed. But I'm not closing it! I'm scratching my head on this one. -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en