UNIQUE KEY [Answered] RSS

• • Reply
  Omar.m

  None

  0 Points

  14 Posts

  UNIQUE KEY

  May 25, 2013 11:03 AM|Omar.m|LINK

  dears

  I get this error when you use the UNIQUE KEY.

  Violation of UNIQUE KEY constraint 'IX_New'. Cannot insert duplicate key in object 'dbo.New'. The duplicate key value is (20). The statement has been terminated.

  What is the code to solve this issue.

• • Reply
  suneeld

  Participant

  790 Points

  230 Posts

  Re: UNIQUE KEY

  May 25, 2013 11:27 AM|suneeld|LINK

  This means that you are inserting a record with a duplicate value for the unique column. have a check in your code before inserting.

  If I have answered your question, then mark my post as the anwer.
  
  Thanks,
  Sunil Dixit
• • Reply
  Omar.m

  None

  0 Points

  14 Posts

  Re: UNIQUE KEY

  May 25, 2013 11:41 AM|Omar.m|LINK

  I've put not to repeat " UNIQUE KEY ", but I see this error when I enter two identical .

  How can I put Labelerror no one Cannot insert duplicate number to Database

• • Reply
  oned_gk

  All-Star

  52523 Points

  15675 Posts

  Re: UNIQUE KEY

  May 25, 2013 12:08 PM|oned_gk|LINK

  check first the record using SELECT COUNT(*) FROM YOURTABLE WHERE IDFIELD=…
  Programming to simplify, don't look for difficult way
  Suwandi - Non Graduate Programmer
• • Reply
  Omar.m

  None

  0 Points

  14 Posts

  Re: UNIQUE KEY

  May 28, 2013 06:23 AM|Omar.m|LINK

  thanks for all