Questio: MySQL Duplicate Entrys

04/20/2010 01:56 ~Yuki~#1
How would i prevent duplicates? How would i check it IN C#
04/20/2010 04:13 LetterX#2
Quote:
Originally Posted by ~Yuki~ View Post
How would i prevent duplicates? How would i check it IN C#
Duplicate entries of what?
04/20/2010 04:36 kamote#3
Quote:
Originally Posted by ~Yuki~ View Post
How would i prevent duplicates? How would i check it IN C#
duplicate entry's usually happen in an INSERT statement. therefore you need to put ifs before executing INSERT statement.

anyway, duplicate entry's can be avoided also if you had set a primary/unique key on the database table definition....

read the subject area from this site:
[Only registered and activated users can see links. Click Here To Register...]
04/20/2010 06:12 ~Yuki~#4
mkay fixed it inside the source wifout a pkay thanks too.

Can be closed
04/20/2010 06:39 pro4never#5
Yah, just do a simple bool for if a value already exists in the specified database. That way you can check if it already exists and if so return to the client that the required db function couldn't be completed, if not it will go ahead and complete the database function properly.
04/20/2010 12:22 tanelipe#6
#Closed