The Cursor must include a column named “_id” or this class (CursorAdapter and descendants) will not work.
COL_ID
should be “_id
” or you can try to use a workaround by making alias:
String[] allColumns = new String[] { SqlDbHelper.COL_ID + " AS " + BaseColumns._ID, ...
See CursorAdapter
11
solved Android SQLite data display to ListView