to avoid duplicate entry

Results 1 to 2 of 2

Thread: to avoid duplicate entry

  1. #1
    Join Date
    Dec 1969

    Default to avoid duplicate entry

    Hi There,<BR>In my application user is enterning data every month for some products, I want to know what steps should I take to make sure he is not able to enter duplicate entry for the product he has already taken care of for a specific month. <BR>How to take care of the error handling?<BR>What can be done to restrict him from entering the duplicate values?

  2. #2
    Join Date
    Dec 1969

    Default This is the same, really... this FAQ:<BR><BR><BR>For starters, stick with the simplest way: Do a SELECT to see if the data is already there. If it is, give a message. If not, add it.<BR><BR>Especially for something only done once a month, I wouldn&#039;t get more exotic than that.<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts