We purchased a utility called eCreator that allows us to easily build web-based programs. Currently we have an SQL database which contains customer info for an outbound calling project. The application goes something like this: I've added a field called record_status and there are 3 possible values: IU-In Use; AV-Available; and CT-Complete. Everytime an agent logs in, it grabs a record and changes its record_status from AV to IU so that when the next agent comes along they don't get the same record. However if 2 agents log in at the same time they are getting the same record. This makes no sense. Can anyone make a suggestion to prevent 2 or more users from getting the same record? I'm using ADP to retrieve the info from SQL tables.
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!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Prevent Mulitple User From Grabbing Same Record
- Thread starter caper1175
- Start date
- Status
Similar threads
- Locked
- Question