Android: column ‘_id’ does not exist

by

Your database doesn’t have to have a column called ‘_id’ but the SimpleCursorAdaptor does need to have one returned. You can do this with an alias.

An example is that I have a table with columns…

uid,name,number

To query this for a SimpleCursorAdapter, I do this with a database rawQuery…

SELECT uid as _id,name,number FROM MY_TABLE

This works fine and supplies the necessary ‘_id’ column to SimpleCursorAdapter.

EDIT: As far as I understand it the _id field is used as a unique key to make sure the data the cursor handles can be handled correctly by adapters and adapterviews etc.

Look at the data model in the docs for Content Providers.

Using a unique key in ‘databases’ of whatever kind is pretty much universal practice, and as far as I can tell, the use of the column name ‘_id’ (or ‘_ID’) is simply a way of standardizing and simplifying things across databases, content providers, cursors, adapters etc etc

In short, in order for these various components to work correctly, they need a data column with unique values but they must also ‘know’ what the name of that column is. They wouldn’t ‘know’, so to speak, that my column name ‘uid’ is the one they need as opposed to my ‘name’ and ‘number’ columns.

More Related Contents:

  1. How to add multiple edit text and spinner data into SQLite database?
  2. Why does the application crash when I press the button to insert the values in the table? [duplicate]
  3. When does SQLiteOpenHelper onCreate() / onUpgrade() run?
  4. Android SQLite issue – table … has no column named
  5. Cursor adapter and sqlite example [closed]
  6. How to perform an SQLite query within an Android application?
  7. How can I insert image in a sqlite database
  8. How to store and retrieve a byte array (image data) to and from a SQLite database?
  9. Android Cursor with ORMLite to use in CursorAdapter
  10. A pre-populated database does not work at API 28 throws “no such table” exception
  11. How to store sqlite database directly on sdcard
  12. Attempt to reopen an already-closed object sqlitedatabase
  13. How insert image in room persistence library?
  14. How to convert milliseconds to date in SQLite
  15. How to check database on not rooted android device
  16. Android database encryption
  17. Android error – close() was never explicitly called on database
  18. How to save images into Database
  19. Full text search example in Android
  20. How to get Last record from Sqlite?
  21. What are the overheads of using AUTOINCREMENT for SQLite on Android?
  22. select distinct value in android sqlite
  23. Could not allocate CursorWindow
  24. When should I do certain SQLite operations on another thread(not the main thread)?
  25. SQLite exception: Database is locked issue
  26. Sqlite issues with HTC Desire HD
  27. PowerManager.PARTIAL_WAKE_LOCK android
  28. cursoradapter with different row layouts
  29. Android SQLiteOpenHelper cannot open database file
  30. Android table creation Failure (near “autoincrement”: syntax error)?

Leave a Comment