Search code examples
androidsqliteselectduplication

Select query to check the existing record in the SQLite Database in android

I want to know the Query to check whether the particular Record in the DataBase already exists or not for my application.

I have made one function for these, but it is not working properly.

public boolean ifExisting(String name) {
    Cursor c = db.rawQuery("SELECT * FROM " + TABLE_NAME + "WHERE" + "name" + "=" + name, null);
    if(c.getCount() == 0)
     return false; 
else
     return true;
}

This is the place where I need to perform the function of checking for the Duplication Process.

if(dh.ifExisting(dataVector.get(position)) == true) {

} else {
dh.insert(dataVector.get(position));
}

Can anybody please help me.

Thanks, david

Solution

  • Can you be a bit more specific? "no working properly" isn't a real problem description.

    Anyway, your query is missing some spaces:

    "SELECT * FROM " + TABLE_NAME + "WHERE" + "name" + "=" + name
// if you would print the string you would get this:
"SELECT * FROM TABLE_NAMEWHEREname=name"