Just a quick straw poll . . . .
How do you guys achieve resilience in the face that multiple users can change records at the same time?
Printable View
Just a quick straw poll . . . .
How do you guys achieve resilience in the face that multiple users can change records at the same time?
By rolling back every transaction.
Is that supposed to be "change the same record at the same time"?Quote:
Originally Posted by yrwyddfa
Sort of.
Two (or more) users both working on the same set of data. How do you manage the updates?
This may impart some important info...
i used transaction method on update,delete and insert methodQuote:
Sort of.
Two (or more) users both working on the same set of data. How do you manage the updates?
when the record was locked by the first user and some user also modifying the same record you can rollback transaction to those other user as the error fires "row cannot be located ....." something like that on bound controls or " currently lock" on adodb.connection, and then issue the requery to read the updated values..