Results 1 to 2 of 2

Thread: Use Timestamp as a locking mechanism

  1. Dec 7th, 2001, 01:08 PM #1
    fiona_conard
    fiona_conard is offline

    Thread Starter
    Lively Member
    Join Date
    Oct 2001
    Posts
    112

    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!
    Reply With Quote Reply With Quote
  2. Dec 7th, 2001, 01:21 PM #2
    jim mcnamara
    Guest
    See your post in the COM/ActiveX forum.


    jim
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width