DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Record has been updated by another user...

  1. #1
    Join Date
    Sep 2000
    Posts
    5

    Angry

    Hi.

    Is there any way to fetch automaticaly changed record to form when the error FRM-40645 "Record has been updated by another user. Re-query to see changes." occurs. Executing whole query is too expensive.

    P.S. I am using FORMS 4.5.

  2. #2
    Join Date
    Oct 2000
    Posts
    13

    Angry

    I think your changing data values at table level in your database by using a procedure in/from your form.
    This is something you can do because you are using the session_id who is locking records at table.

    Try not to change table values but record block values or you will go on getting the same error.

    Otherwise, you will have to requery to see changes.

    Hope this helps.

  3. #3
    Join Date
    Sep 2000
    Posts
    5
    Thanks, but I allready found, what i was looking for:

    1. Save rowid
    2. Create new record and fetch all the item from database using rowid of the record
    3. Assign rowid to the new record
    4. Change record status to QUERY_STATUS
    5. Clear old record from form

Posting Permissions

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


Click Here to Expand Forum to Full Width