Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
programer
Posting Yak Master
221 Posts |
 Posted - 2010-08-08 : 10:05:39
|
| I have an application open in two locations.On one computer working secretary, and one director.Both simultaneously modify the same record. First Secretary amended recordthen Director.How to inform the latter, which wants to save the record that the data were changed.However, if the record is changed and someone in the organization of the record, write error. |
|
|
programer
Posting Yak Master
221 Posts |
Posted - 2010-08-08 : 10:06:11
|
quote:
Originally posted by programer
I have an application open in two locations.On one computer working secretary, and one director.Both simultaneously modify the same record. First Secretary amended recordthen Director.How to inform the latter, which wants to save the record that the data were changed.
|
 |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-08-08 : 10:11:51
|
| read about raising errors: http://msdn.microsoft.com/en-us/library/ms178592.aspxotherwise, you have deadlocks, sharedlocks, etc. for such cases. If someone is working (updating) a record, this record is locked for someone else to work on. |
|
|
|
programer
Posting Yak Master
221 Posts |
Posted - 2010-08-08 : 10:27:22
|
quote:
Originally posted by programer
quote:
Originally posted by programer
I have an application open in two locations.On one computer working secretary, and one director.Both simultaneously modify the same record. First Secretary amended recordthen Director.How to inform the latter, which wants to save the record that the data were changed.
thanks
|
|
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-08-08 : 10:42:04
|
| no problem |
|
|
|
|
|
|
UPDATE/DELETE