concurrency access/mssql

  • Thread starter Thread starter Danny Nielsen
  • Start date Start date
D

Danny Nielsen

Hi
Im developing an order database. So far, I've not been concerned about
concurrency issues because I thought that it was done by mssql. But at one
point I tested it with some users and it seemed that when I tried to insert
two orders with same orderno (primary key) at the same time, the 2. user got
an message that there had happened a violation on the primary key. Thats
good except that this popup screen continued to pop up whereby the user got
locked in this specific screen! Any idears why?

Thanks and best regards

Danny Nielsen
Denmark
 
Back
Top