Get a Jumpstart with our Sample Apps
Results 1 to 3 of 3

Thread: Update Errors - record locked

  1. #1
    Moderator Steve Wood's Avatar
    Real Name
    Steve Wood
    Join Date
    Nov 2003
    Location
    Bay Area, California
    Posts
    8,738

    Default Update Errors - record locked

    I have a grid with Update allowed. When I update a row, I get an Update Error/Write Conflict statement (see below). But I have done everything possible to complete any previous update that might be locking the database record. Including, packed the table, closed the database, removed all cached files on my browser, reset all session vars, etc.

    What is locking that long-ago updated record?


    Row 2: Record was not updated because another user changed the record. (Write conflicts found in these fields: PASSWORD

  2. #2
    Moderator Steve Wood's Avatar
    Real Name
    Steve Wood
    Join Date
    Nov 2003
    Location
    Bay Area, California
    Posts
    8,738

    Default RE: Update Errors - record locked

    My fault, I did not properly set the Define Primary Keys on the Grid Query page.

  3. #3
    Member EricN's Avatar
    Real Name
    Eric
    Join Date
    May 2007
    Location
    Minnesota
    Posts
    553

    Default Re: Update Errors - record locked

    I am getting these errors even after setting primary key.

    userid currently is primary key. Could there be other reasons for this error?

    Even with this error, it does update the record with my updates.
    When I click select again, the error goes away and again saves my changes.

    This is an update only grid. I have Enterprise V8.
    Eric

    Alpha Five Websites
    longlivepuppies.com
    socialservicenetwork.com
    -------------------------------------------------
    socialservicenetwork.org

Similar Threads

  1. Record locked by another session or user
    By Ray Dean in forum Alpha Five Version 5
    Replies: 4
    Last Post: 09-09-2011, 09:38 AM
  2. another session has record locked
    By DaveM in forum Alpha Five Version 5
    Replies: 2
    Last Post: 07-08-2004, 07:25 AM
  3. Record Locked
    By Fishell, Bob in forum Alpha Five Version 4
    Replies: 2
    Last Post: 01-30-2003, 11:59 AM
  4. Record locked error
    By brett s in forum Alpha Five Version 5
    Replies: 7
    Last Post: 11-03-2002, 07:21 PM
  5. Locked Record
    By Dennis Silver in forum Alpha Five Version 4
    Replies: 2
    Last Post: 07-26-2000, 02:43 PM

Posting Permissions

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