Results 1 to 3 of 3

Thread: Locks

  1. 09-19-2002, 01:12 PM #1
    MCNKC
    MCNKC is offline Registered User
    Join Date
    Sep 2002
    Posts
    5

    Locks

    2 quick questions :

    1) How do I keep multiple users from editing the same record without locking the entire table? What would be a 'standard' way of handling this?

    2) How do I keep 2 people from posting the same record?

    Please help me understand locking, THANKS!!!
    Reply With Quote Reply With Quote
  2. 09-19-2002, 02:14 PM #2
    WizKid
    WizKid is offline Registered User
    Join Date
    Sep 2002
    Location
    DALLAS
    Posts
    25
    1. OPEN a CURSOR with SCROLL_LOCKS option to lock the record from being updated by other users, while your app is editing it.

    2. what do you mean by "POSTING the same record". Do you mean two users creating the same record at the same time..? If yes, you will need to query to see if the record exists, just before you issue the update statement.

    hope it helps..
    Reply With Quote Reply With Quote
  3. 09-19-2002, 03:01 PM #3
    MCNKC
    MCNKC is offline Registered User
    Join Date
    Sep 2002
    Posts
    5
    yes, and thanks for the reply. Does the ADO object handle the situation too instead of SQL cursors?
    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