AndroidSQLite | Android SQLite example with CRUD Operations | Android library

Room names tables the same as their associated entities. In your DAO, TABLE_ITEMS needs to be PermitItem, because your entity is PermitItem. Or, add the tableName property to the @Entity annotation, to tell Room some other name to use for the table.

Cursor cursor = (Cursor) parent.getItemAtPosition(id); will get the item according to it's position in the list, but you are using the id (as extracted from the button's Tag) as it's position. This will rarely if ever be correct.

The first position in the list is 0, the first id will be 1 (assuming no rows have been deleted and you aren't manually setting the id) and hence the symptoms you report.

If rows have been deleted then each missing id can increase the difference between id and position. If the rows are sorted in any other order than id, then positions v id's could be way out. If a where clause excludes rows then again id's and position would vary.

Simple fact is you can't rely on any relationship between id and the position in the list.

What you could do is use the id, from the Tag, to query the database to extract the specific row. The query would be be the same as the query used to get the cursor for the list except that it would utilise the 3rd (SQLiteAdapter._id + "=?") and 4th parameters (new String[]{String.valueOf(id)}) (if using the query convenience method).

• Note corrected (missing S added to QLiteAdapter) since comment.

I tried add code as I wrote in last comment, but it's wrong. I don't know how to implement your changes. –

Your code could be :-

The following is a relatively simple way of handling click events of views within an Item of a ListView.

To simply obtain the actual item that has been clicked to distinguish it from another Item you need a Custom Adapter, in this case a Custom Cursor Adapter, in which you can set the view's tag to an appropriate value (the id).

In conjunction with this you use the onClick attribute to specify the method to be called when the view (checkbox) is clicked, which is defined in the Activity.

The following is a working example based upon your code. It uses a simpler and more flexible method for managing the ListView i.e. manageListView

Note some of your code has been omitted (commented out) for convenience.

The Cursor you pass to CursorAdapter needs to have _id column in its result set. You can add it here: