From: Asendorf, John Sent: Monday, January 14, 2002 4:49 PM >You can, but there are a number of issues to deal with. One of the >potential solutions is to grab the MAX value from the table id field and >then increment that number for the next inserted record. The problem arises >though when you have multiple users attempting to add records...
Concurrency and update anomalies problems in the DB environment has to be dealt with independently of auto-incremental values. These types of problems will always arise, and thus has to be considered if they might constitute a problem. -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]