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 |
|
desikankannan
Posting Yak Master
152 Posts |
 Posted - 2011-09-19 : 08:54:44
|
| hi,my application is single user, but my client wants multi user billing any way to lock row, two user using same form, iam using .net as my front end.looking forward helpDesikankannan |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2011-09-19 : 09:01:41
|
| Hello,If I understand your need, one option might be to create a 'flag' on the record(s) which user1 is accessing via the form. This flag marks the records in the db which are in use by user1. This flag is than checked each time a user attempts to access the record(s) and if they are locked by user1 then return a message to user2.HTH. |
 |
|
|
|
|
|
multi user row lock