lundi 7 septembre 2015

get the position of a row in the table if a String exist in a Column of that table in Android sql database

I'm making a android app with database. and i think i have 50 percent skills on android database sql. i want to get the position of a row that a String exist on a Column of my table.

first i use cursor to find the row that has my String by: Cursor c = database.rawQuery( "SELECT * FROM myTable WHERE name Like '"+word+"'", null);

then i think we should use moveToFirst.

then if i write for example: int s=cursor.getPosition(); , s is showing 1;

its not my position that i want. i want to know the position of that row in my table. for example it can be 20, or 10, or any number.

what should i do to get that????????? PLEASE

Aucun commentaire:

Enregistrer un commentaire