Android column ‘_id’ does not exist?

by

I see, the documentation for CursorAdapter states:

The Cursor must include a column named _id or this class will not
work.

The SimpleCursorAdapter is a derived class, so it appears this statement applies. However, the statement is technically wrong and somewhat misleading to a newbie. The result set for the cursor must contain _id, not the cursor itself.
I’m sure this is clear to a DBA because that sort of shorthand documentation is clear to them, but for those newbies, being incomplete in the statement causes confusion. Cursors are like iterators or pointers, they contain nothing but a mechanism for transversing the data, they contain no columns themselves.

The Loaders documentation contains an example where it can be seen that the _id is included in the projection parameter.

static final String[] CONTACTS_SUMMARY_PROJECTION = new String[] {
    Contacts._ID,
    Contacts.DISPLAY_NAME,
    Contacts.CONTACT_STATUS,
    Contacts.CONTACT_PRESENCE,
    Contacts.PHOTO_ID,
    Contacts.LOOKUP_KEY,
};
public Loader<Cursor> onCreateLoader(int id, Bundle args) {
    // ...
    return new CursorLoader(getActivity(), baseUri,
            CONTACTS_SUMMARY_PROJECTION, select, null,
            Contacts.DISPLAY_NAME + " COLLATE LOCALIZED ASC");
}

More Related Contents:

  1. get Feature item to list View
  2. Android SQLite data display to ListView
  3. how to save image taken from camera and show it to listview – crashes with “IllegalStateException”
  4. How to implement endless list with RecyclerView?
  5. Share SQLite database between 2 android apps?
  6. How do I view the SQLite database on an Android device? [duplicate]
  7. Android P – ‘SQLite: No Such Table Error’ after copying database from assets
  8. How to ignore accent in SQLite query (Android)
  9. Android ListView Divider
  10. Store Android SQLite
  11. Why do I get a “sqlite3: not found” error on a rooted Nexus One when I try to open a database using the adb shell?
  12. Android Persistence room: “Cannot figure out how to read this field from a cursor”
  13. Replace one Fragment with another in ViewPager
  14. SQLite Exception no such column when trying to select
  15. android java.lang.IllegalStateException: Couldn’t read row 0, col 0 from CursorWindow
  16. how to customize listview row android
  17. How can I insert image in a sqlite database
  18. Android Alternate row Colors in ListView
  19. Android – ListView – performItemClick
  20. android attaching multiple adapters to one adapter
  21. Listview itemclick not work
  22. Passing a List from one Activity to another
  23. Sort listview with array adapter
  24. How to Overlap items in LinearLayoutManager – RecyclerView (like stacking cards)
  25. How to check database on not rooted android device
  26. Android ListView with delete button
  27. Placing ViewPager as a row in ListView
  28. How to get selected list items from a Listview with checkBox and Custom Adapter?
  29. Recycling views in a listview, worth it?
  30. Android Click on listItem checks wrong checkbox

Leave a Comment