Android SimpleCursorAdapter doesn’t update when database changes

by

Call requery() on the Cursor when you change data in the database that you want reflected in that Cursor (or things the Cursor populates, like a ListView via a CursorAdapter).

A Cursor is akin to an ODBC client-side cursor — it holds all of the data represented by the query result. Hence, just because you change the data in the database, the Cursor will not know about those changes unless you refresh it via requery().

UPDATE: This whole question and set of answers should be deleted due to old age, but that’s apparently impossible. Anyone seeking Android answers should bear in mind that the Android is a swiftly-moving target, and answers from 2009 are typically worse than are newer answers.

The current solution is to obtain a fresh Cursor and use either changeCursor() or swapCursor() on the CursorAdapter to affect a data change.

More Related Contents:

  1. Android SQLite data display to ListView
  2. Android :: SQLIte Db don't insert the datas
  3. How can I avoid concurrency problems when using SQLite on Android?
  4. Android SQLite database: slow insertion
  5. Share SQLite database between 2 android apps?
  6. Android: upgrading DB version and adding new table
  7. Best way to work with dates in Android SQLite [closed]
  8. Android SQLite Example [closed]
  9. Android database encryption
  10. Best place to close database connection
  11. Import .csv file to Sqlite in Android
  12. Cursor adapter and sqlite example [closed]
  13. How to add new Column to Android SQLite Database?
  14. How to retrieve data from sqlite database in android and display it in TextView
  15. What is a Full Android Database Helper class for an existing SQLite database? [closed]
  16. How do I create a database in android? [closed]
  17. How to save images into Database
  18. Android SQLite Database, WHY drop table and recreate on upgrade
  19. SQLite simultaneous reading and writing
  20. update sql database with ContentValues and the update-method
  21. How does one check if a table exists in an Android SQLite database?
  22. Could not allocate CursorWindow
  23. Saving ArrayLists in SQLite databases
  24. android, how to exec a sql file in sqlitedatabase
  25. SQLiteOpenHelper – creating database on SD card
  26. SQLite android column not found
  27. How to store JSON object in SQLite database
  28. SQLiteOpenHelper onUpgrade() Confusion Android
  29. Using COLLATE in Android SQLite – Locales is ignored in LIKE statement
  30. When to close db connection on android? Every time after your operation finished or after your app exit

Leave a Comment