Update and TimeStamp Question

[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]

Nevermind I figured it out. MS SQL Server generates it for you.

 

[David Sceppa]

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.