onlistitemclick after filtering the listview

I am retreiving 20 names from an sqlite database and displaying them in the form of listview. They are unsorted. I use filter and sort them alphabetically so that I avoid unnecesary scrolling. I have an edittext too. When I type a key, it matches the listitems and filters the list. Each listitem has a respective text with it,

The problem now here is, when I sort and filter, the position of the listitem changes. When I click on that, it displays its current positions text and the listitem's text.

For example: I have a 3 DB entries

ROWID NAME       DESCRPTION
1    RASHMI   I AM FRM INDIA
2    RICHA    I AM FROM USA
3    STELLA   I AM FROM CANADA.

My list view displays only the NAME column. Now when I press S in the edittext, STELLA comes up from position 3 to position 1. When I click on that listitem, it开发者_StackOverflow中文版 displays I AM FROM INDIA instead of I AM FROM CANADA. Every action is taking place from SQLite DB.

post your adapter code.

if you are changing the cursor on the adapter as you probably are. be sure to get the cursor from the adapter by calling

    Cursor c = adapter.getCursor()
c.moveToPosition(position);
String description = c.getString(c.getColumnIndex("DESCRIPTION"));

the key thing is to move the cursor to the desired position in the list. also be sure you are using the attached cursor to the listView not a previously saved instance or from your first query when you were assigning it to the adapter.