Multiuser who can modify the same data? 3

[xpblueScreenOfDeath]

How can I prevent two users from modifying the same data at about the same time, and notify the later user that the record is readonly because another user is currently modifying the data? What is the best way to deal with this because the web applications is always disconnect from the data? I don't want to hold a lock too long or it will block everyone else.

 

[sweth]

usually it is better to do with timestamp field to restrict multiple user being modifying same record. Or by using locks.

 

[jbenson001]

It depends on what DB you are using. There is no way in Sql server to manually lock a record. What I have done in the past is to create a bit column as a flag. I then check that flag and if that flag is set (flg = 1) then I don't allow that data to be edited/updated. Once the row has been updated, I set the flag back (flg = 0), which would then allow some one else to edit the data.


Jim

 

[chrissie1]

let's be optimistic here ;-).

if you use the dataadapter it will do it for you.

otherwise you will have to do it yourself. Lockng a record is never a good idea (what if it never gets released?)

what I would do is
- save a copy of the original data
- let the user edit a copy
- on update check to see if your original is still the same as the one on the server. if not don't save else save.


Christiaan Baes
Belgium

I just like this --> [Wiggle] [Wiggle]