mysql - delete entry from sqlite data base in android application. where to get the that row id to pass it ot delete function -

after going through many posts posting query. not able proper resolution problem.

i using sqlite , inserting data (name, info etc..)

now rows , show in list view.

now user selects 1 list entry deletion, have call db.delete id rowid of particular record.

how record id?

when user selects list view have position number index list. not database row id entry resides.

do have save ids returned when call db.insert(table, data) when rows created?

all examples show implementation like

    public void deleterow(long id) {      db.delete(table_name,key_id + " = ?",             new string[] { string.valueof(id) });      }

where should id from?

for setup list view have create adapter, right?

the adapter hold entries , create views.

ask adapter item on position x.

the baseadapter implement getitemid method.

public long getitemid(int position) {      // example list<object>     return mitems.get(position).getid();  }

you can simple call adapter.getitemid(x); or use onitemclicklistener give id.

for more informations loot @ android developer pages.

i hope helps.

updated:

use getitemid(int) instead of getitem(int), @pskink

WIKI