Results 1 to 2 of 2

Thread: error in SQL

  1. #1
    Join Date
    Sep 2010

    Unanswered: error in SQL

    i have create a registration form in & sql server..It's working good..

    i generate ID for user when they click "sign Up" button..(the ID will appear in drop down list at form-ID not saved yet into database)..

    the problem is when several user register at same time and click "SAVE" button at same time..

    while 1 user register if another user click Signup from different computer or place it'll get same ID for both user...

    How to avoid this problem...?please give some idea..

    Last edited by Jeev; 09-14-10 at 05:35.

  2. #2
    Join Date
    Nov 2004
    Provided Answers: 4
    Don't show the ID or use it in any way, until you know what value it will finally have.
    With kind regards . . . . . SQL Server 2000/2005/2012

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

Posting Permissions

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