Results 1 to 3 of 3

Thread: Update issue

  1. #1
    Join Date
    Feb 2004
    Location
    Jordan
    Posts
    137

    Unhappy Unanswered: Update issue

    Hi all

    I have a form with DB-Block and a button there, on click on this button ( update , insert statments) will issued depends on the current record.
    when two users query the same record and press the button at a time and one of them has a network latency,
    one of them will finish the process and the other will have the message (record has been udated by another user) but it complete the processes,
    and duplicated transactions will be issued.

    how to prevent this problem ?

    thanx in advance

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    You need to trap the FRM-40657 error and not perform the insert/update processing.

  3. #3
    Join Date
    Mar 2009
    Location
    New Delhi - India
    Posts
    22
    try using locks so that the user which gets the control earlier, locks the table and after processing, unlocks it.

Posting Permissions

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