How to prevent duplicate entry in sqlite

Question

i need to prevent duplicates entry in sqlite i made this code but it not working.

String brandName=BrandName.getText().toString().trim();
            SQLiteDatabase db = dbh.getWritableDatabase();
            Cursor c=db.rawQuery("SELECT * FROM Brand_Table WHERE Name="+brandName, null);
            if(c.moveToFirst())
            {
                showMessage("Error", "Record exist");
            }
            else
            {
                ContentValues values = new ContentValues();
                values.put("Name", brandName);
                db.insert("Brand_Table", null, values);
                Toast.makeText(getActivity(), "Brand  Created", Toast.LENGTH_LONG).show();
                BrandName.setText("");

            }

Error Logs

  android.database.sqlite.SQLiteException: no such column: abc (code 1): , while compiling: SELECT * FROM Brand_Table WHERE Name=abc

my database look likes

id   Name
1    abc
2    pqr

id is auto incremented i am passing value abc from edittext and data is present in database but it gives above error and stop application

You could do the same thing with the UNIQUE constraint (which is much safer to use than custom code) — MatPag
– MatPag, Commented Aug 28, 2019 at 7:35

Rajnish suryavanshi · Accepted Answer · 2019-08-28 07:33:50Z

1

Try this Query

db.rawQuery("SELECT * FROM Brand_Table WHERE Name='" + brandName+ "'",null);

instead of this what you have tried

db.rawQuery("SELECT * FROM Brand_Table WHERE Name="+brandName, null);

branName is a String needs to be in single quote.

answered Aug 28, 2019 at 7:33

Rajnish suryavanshi

3,4942 gold badges20 silver badges24 bronze badges

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

Collectives™ on Stack Overflow

How to prevent duplicate entry in sqlite

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related