Alpha Video Training
Results 1 to 9 of 9

Thread: "Record was not updated because it has been deleted by another user."

  1. #1
    Member
    Real Name
    Roelof
    Join Date
    Jul 2008
    Location
    Seattle, WA
    Posts
    763

    Default "Record was not updated because it has been deleted by another user."

    Could anybody tell me why this is happening:"Record was not updated because it has been deleted by another user."

    The record is not deleted.
    Using SQL 2012 and V11 latest
    Using: grid with detail

  2. #2
    Member
    Real Name
    Rod McLeish
    Join Date
    May 2010
    Posts
    43

    Default Re: "Record was not updated because it has been deleted by another user."

    This could happen if you have a join and the join table is not being updated properly. This same thing happened to me and I found that I had marked a join table as read only under the "Select Primary Key(s)" button even through I was attempting to update the table.

  3. #3
    "Certified" Alphaholic
    Real Name
    Frank Bicknell
    Join Date
    Feb 2010
    Location
    39.1915° N, 84.4348° W
    Posts
    2,467

    Default Re: "Record was not updated because it has been deleted by another user."

    Thank you Rod, this has been puzzling me for a while.
    Win 10 64 Development, Win 7 64 WAS 11-1, 2, Win 10 64 AA-1,2, MySql, dbForge Studio The Best MySQL GUI Tool IMHO. http://www.devart.com/dbforge/mysql/studio/

  4. #4
    Member
    Real Name
    Roelof
    Join Date
    Jul 2008
    Location
    Seattle, WA
    Posts
    763

    Default Re: "Record was not updated because it has been deleted by another user."

    Still working on it for me, still have issues. Will update when I find out the issue

  5. #5
    Member
    Real Name
    Roelof
    Join Date
    Jul 2008
    Location
    Seattle, WA
    Posts
    763

    Default Re: "Record was not updated because it has been deleted by another user."

    Can anyone give another pointer for me, I cannot get it to work. I have several tables, alll read and write and one table is a view. But that one does not need to be updated.

  6. #6
    Member
    Real Name
    Roelof
    Join Date
    Jul 2008
    Location
    Seattle, WA
    Posts
    763

    Default Re: "Record was not updated because it has been deleted by another user."

    OK I found the issue. Because 2 databases had the same field names I had pulled the wrong fieldnames in the main table. So it was connected with the joint command.
    thanks

  7. #7
    Member
    Real Name
    Karl Bornmann
    Join Date
    Jun 2016
    Posts
    1

    Default Re: "Record was not updated because it has been deleted by another user."

    I have the same issue. Yet i have selected the correct filed to update. I have tried several different grid templates and all fields are read and write. The 2 tables are joined (Inner) and on three different fields.
    I created a button under javascrips (Onclick) to lookup and fill in the field. Still i receive the same error message "Record was not updated because it has been deleted by another user."
    All the tables are opened Exclusive. AFv12 running on a VPS server Server 2012 R2
    Please Help

  8. #8
    Member
    Real Name
    Drew R.
    Join Date
    Feb 2011
    Location
    Northeast TX
    Posts
    60

    Default Re: "Record was not updated because it has been deleted by another user."

    Karl,

    Have you corrected this issue yet? I've run into the same problem.

    Andrew

  9. #9
    Member
    Real Name
    Priyesh Agarwal
    Join Date
    Mar 2018
    Posts
    9

    Default Re: "Record was not updated because it has been deleted by another user."

    Has anyone figured this problem out yet?

Similar Threads

  1. copy previous field / record by pressing key ctrl + shift + " f " / " r " problem
    By dannysiu in forum Alpha Five Version 10 - Desktop Applications
    Replies: 3
    Last Post: 10-12-2011, 06:12 AM
  2. How to prevent "default" records from being deleted??
    By Scholin in forum Application Server Version 10 - Web/Browser Applications
    Replies: 12
    Last Post: 08-05-2010, 10:22 AM
  3. To "zoom to record" or to "open form" using action scripting, that is the question.
    By georgefurnel in forum Alpha Five Version 9 - Desktop Applications
    Replies: 4
    Last Post: 06-18-2008, 07:32 PM
  4. "Add" and "Save" buttons don't stay on "Self" page
    By Scholin in forum Application Server Version 8
    Replies: 2
    Last Post: 02-05-2008, 08:50 AM
  5. Duplicating a "Parent" record complete with "Children"
    By Peterg in forum Alpha Five Version 7
    Replies: 4
    Last Post: 02-23-2006, 10:40 AM

Bookmarks

Posting Permissions

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