Use Timestamp as a locking mechanism

Hi all,

I am developing a multi-tier application and I want to use timestamp value for a record in an SQL 2000 database to act as a locking mechanism.
Every time when Client retrieves record from a table , the original timestamp of that record will also be retrieved. When client updates the record, the original timestamp value will be compared with the current timestamp value
found in table, if they are not the same then the update will be rejected.

Does any one know how to compare the values of two timestamp values?
I code the front end using VB. Thanks!

See your post in the COM/ActiveX forum.


jim