Update and TimeStamp Question

  • Thread starter Thread starter Timothy
  • Start date Start date
T

Timothy

Hi,

I am using a timestamp column to manage my concurrency on updating. My
question is on the update should I create a new timestamp colmn on the
server side or the client side? And how would I accomplish that?

Thanks
 
Timothy,

If your application will give the user the ability to modify the same
DataRow object multiple times, make sure you fetch the new server-generated
timestamp value after a successful update. Otherwise, the timestamp column
in the DataRow and the database row will be out of synch and subsequent
update attempts will fail.

I hope this information proves helpful.

David Sceppa
Microsoft
This posting is provided "AS IS" with no warranties,
and confers no rights. You assume all risk for your use.
© 2004 Microsoft Corporation. All rights reserved.
 
Back
Top