How to prevent duplicate entry in database

Meet · 06-16-2011, 04:38 AM

Hello all

m working first time with database in iphone.

I want my applicatin to add a row on clicking a button.

all is goin wel, but my data is full of duplicate entries.

i dont know how to overcome it.

can nyone help????

dany_dev · 06-16-2011, 05:02 AM

before you use INSERT, you can do a SELECT with the data that you want to insert, if will return 0 record, then you will insert it, else no....

another approach is to use the right primary key (like name, surname) so that the db will reject record when you insert something with the same name,surname.

ios dev · 06-17-2011, 04:15 AM

Quote:

Originally Posted by Meet

Hello all

m working first time with database in iphone.

I want my applicatin to add a row on clicking a button.

all is goin wel, but my data is full of duplicate entries.

i dont know how to overcome it.

can nyone help????

Can't you create UNIQUE key on the column?
You will get errors when trying to insert duplicate values.