General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>Sounds like Dan has got you going in the right direction. First problem to solve is that you must stop the user from turning off the pc.
>>
>
>I have had so many problems with users turning off the PC or just leaving the apps opened and going to lunch. Barbara Paltiel had suggested using Semaphore locking, but I never had time to really research that.
I know what you mean. My main app doesn't buffer. User click an edit button to lock a record and then a save button to unlock it. Because it is healthcare record we wanted to make sure only one person can change the record at a time and there were no overwrites. Sure can cause some problems on occassion.
I have implemented another smaller (no health data) that using buffer with optimistic record locking. Was surprisingly easy to implement especially since I used a "last one wins" strategy.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only