Thursday, 22 August 2013

how to retrieve Data from sqlite database

how to retrieve Data from sqlite database

I have created a table in SQLite database with following statement.
i.e.
static final String DATABASE_CREATE =
"create table " + "TEST" +
"( " + "ID" + " integer primary key autoincrement," +
" UID text, FULLNAME text, GENDER integer, MSTATUS integer, MOBILE text,
AGE text );";
with this statement, I can able to insert data but I want to design a
function that will accept the mobile no. and return the UID.

No comments:

Post a Comment