Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Locking Records

Status
Not open for further replies.
Azzuri

Azzuri

Programmer
Apr 16, 2002
18
CA
Hello,

I am using asp and SQL Server 2000 and have a question concerning locking records. Let me explain:

There are 26 orders showing and users click to get the next order so they can process it. What happens when two users click at the same time, I need one user to get order 26 and the other user to get order 25. I need this to continue for all users clicking to get orders.

I would like to know the best way to go about doing this. If I use a pessimistic lock or assign a field in the database that says the order has been taken.

Any suggestions would be appreciated.

Thanks,
 
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
Insert (new) records in a table => question about the inputscreen
2
Replies
20
Views
725
ChrisHirst
ChrisHirst
cr84net2
  • Locked
  • Question
I need to join 5 tables with identical fields then reference the records by table
Replies
4
Views
260
guitarzan
guitarzan
evr72
  • Locked
  • Question
Records double up after second log in 1
Replies
12
Views
261
evr72
evr72
madanthrax
  • Locked
  • Question
Using parameters when calling a recordset
Replies
0
Views
269
madanthrax
madanthrax
evr72
  • Locked
  • Question
Lock all records if all questions answered
Replies
3
Views
160
BigRed1212
BigRed1212

Part and Inventory Search

Sponsor

Back
Top