Re: How notice user, that this record has change by another user?
From: Sahil Malik (contactmethrumyblog_at_nospam.com)
Date: 10/16/04
- Next message: SpotNet: "OleDbConnection, OleDbCommand and OleDbDataReader (one at a time?)..."
- Previous message: Sahil Malik: "Re: SQL2000 & SQLEXPRESS TOGETHER"
- In reply to: mttc: "How notice user, that this record has change by another user?"
- Next in thread: mttc: "Re: How notice user, that this record has change by another user?"
- Reply: mttc: "Re: How notice user, that this record has change by another user?"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 16 Oct 2004 01:23:36 -0400
Welcome to "Concurrency Management"
The below situation can be rectified by doing two things
a) Updating only the columns that you changed.
b) Checking the value of each column before doing the update. i.e. If A's
value used to be 1, then at update check and see if the value is still 1 and
update it to the new value (say 2) only if this test passes.
You can do the above by looking at various versions of values in your
dataset.
- Sahil Malik
You can reach me thru my blog http://www.dotnetjunkies.com/weblog/sahilmalik
"mttc" <s@hotmail.com> wrote in message news:416f8159$1@news.012.net.il...
> Under ADO.NET and SQL 2000
>
> I build form that edit data, and i use with wizard to create Update query.
>
>
> What happen in this situation?:
>
>
> I read record into DataSet. The user 1 change value an field A in the
> record.
>
> Meanwhile, user 2 change and commit the same record in field B.
>
> Now the first user makes commit.
>
>
> I suppose that field B is become again as original value!
>
>
> If it is correct, what method I got to resolve this problem?
>
> How notice user, that this record has change by another user?
>
>
>
>
- Next message: SpotNet: "OleDbConnection, OleDbCommand and OleDbDataReader (one at a time?)..."
- Previous message: Sahil Malik: "Re: SQL2000 & SQLEXPRESS TOGETHER"
- In reply to: mttc: "How notice user, that this record has change by another user?"
- Next in thread: mttc: "Re: How notice user, that this record has change by another user?"
- Reply: mttc: "Re: How notice user, that this record has change by another user?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
