A bit OT: handling multiple users in DB

[Klaus Major]

Hi all,

this is a bit off topic, but maybe someone can give me some helpful  
hints.

Is someone of you working with databases with multiple users?
If yes, how do you handle "concurrent transactions"?

I mean how do you solve the possible overwriting of data when both  
users work with
cursors and are allowed to  update data and how do you update a cursor  
(on the fly?)
when its data may have been updated?

Know what I mean?

I searched the net and found some hints, but maybe you have some  
really clever
solutions that you are willing to share :-)

Thanks in advance!


Best

Klaus Major
klaus at major-k.de
http://www.major-k.de