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

Question

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

Stop spamming the same question! Triple post: stackoverflow.com/questions/4427875/… stackoverflow.com/questions/4427660/… — WarrenFaith
– WarrenFaith, Commented Dec 13, 2010 at 10:30
please don't ask the same question over and over again. You can edit your question to update it, you can comment on answers to get more information, and you can offer a bounty if you cannot find a suitable answer. — user1228
– user1228, Commented Dec 13, 2010 at 12:40

WarrenFaith · Accepted Answer · 2010-12-13 09:09:30Z

1

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"

answered Dec 13, 2010 at 9:09

WarrenFaith

57.7k25 gold badges139 silver badges152 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Thrawn80 Over a year ago

realtime refreshing would be helpful, your advice seems to be more correct then mine :)

WarrenFaith Over a year ago

there is a "nearly realtime" refresh, but nevertheless both of us were right :)

ccheneson Over a year ago

The quotes around name are also missing: "SELECT * FROM " + TABLE_NAME + " WHERE " + "name" + "= '" + name + "'"

WarrenFaith Over a year ago

and the fact that the table name is a variable, but the column name not :) there are a lot of issues there... he could have used the parameter, too

Thrawn80 · Accepted Answer · 2010-12-13 09:09:50Z

0

First question: your data.Vector.get(position) returns a string as result? Second: if your rawquery doesn't works, then try:

" where " + name + " like '"
                    + name + "'", null);

Maybe this might help you

answered Dec 13, 2010 at 9:09

Thrawn80

3512 silver badges7 bronze badges

Comments

metter · Accepted Answer · 2010-12-13 09:10:07Z

0

Cursor c = db.rawQuery("SELECT * FROM " + TABLE_NAME + "WHERE" + "name" + "=" + name, null); 


>TABLE_NAME + "WHERE" + "name"

will be "TablenameWHEREname" instead of "Tablename WHERE name".

answered Dec 13, 2010 at 9:10

metter

1,44211 silver badges22 bronze badges

Collectives™ on Stack Overflow

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

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related