SQL2000 Timestamp Data Type

[cp84]

I need to record the value of the timestamp field in VB.Net to provide validation in pending update procedures using a DataReader/DataRow.
Can this be done or is there a better way?

Many thanks

 

[chrissie1]

the timestamp value in sql-server is an array of 8 bytes and changes everytime you update the record. Allthough your idea was a very good one you don't really need to bother with this because the dataadapter update method will do that check for you and will give an error if the record was changed by somebody else.

And the timestamp datatype is there for backward compatibility and is replaced by the uid datatype.

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[cp84]

Many thanks Christiaan, I'll look into the method you suggest

Clive Porter Uk