C
charles
I developed a ticketing system and the quota for a given
day is stored within one record. When several users add
say Economy tickets for a given trip at the same time, it
results in the conflict dialog (in this case No Locks
default) since all records must reduce the Econonomy seats
available by 1 but taking any of the options is not
desirable since updates to the quota record will not be
correct. I was thinking of using edited record but I do
not want to disturb users who are adding tickets for some
other trip (it was stated that serveral records - quota
records in this case - will be locked). Can you tell me
what to do in this situation?
Thanks in advance,
Charles
day is stored within one record. When several users add
say Economy tickets for a given trip at the same time, it
results in the conflict dialog (in this case No Locks
default) since all records must reduce the Econonomy seats
available by 1 but taking any of the options is not
desirable since updates to the quota record will not be
correct. I was thinking of using edited record but I do
not want to disturb users who are adding tickets for some
other trip (it was stated that serveral records - quota
records in this case - will be locked). Can you tell me
what to do in this situation?
Thanks in advance,
Charles