Open Forum

Expand all | Collapse all

dexterity save error 30

  • 1.  dexterity save error 30

    TOP CONTRIBUTOR
    Posted Oct 17, 2017 09:43 AM
    Another question for David and Mariano:

    My Dexterity code used in our company emails me every time there is a table error.

    Once a month a SAVE function will error out with error 30.  Which means that this happens maybe once in ten thousand (or more) times that our users try to save.  Saving is the only time that error 30 occurs.

    The Dexterity 3X manual has this description for error 30: "A record was changed with a passive lock."

    More recent dexterity manuals say error 30 is the constant RECORDCHANGED, or Changed Record.

    My thinking is my save functions should not error out when error 30 has been returned.  What do you think?



    ------------------------------
    Bruce Strom
    Programmer Analyst
    Associated Grocers of Florida
    sunrise FL
    ------------------------------
    Conference-GPUG_200x200


  • 2.  RE: dexterity save error 30

    GPUG ALL STAR
    Posted Oct 17, 2017 11:12 AM
    Hi @Bruce Strom

    If you use @Mariano Gomez & @David Musgrave, then they'll be notified that they were mentioned in a post.  You can usually get a quicker response this way.

    And, since it's ONLY a little after 11 pm in Perth, David may still be awake.  I swear he doesn't sleep;-)​​​​

    ------------------------------
    Frank Heslin
    Financial Systems Administrator
    ExamWorks, Inc.
    Atlanta GA

    Member, GPUG Advisory Committee
    Chairman, Georgia Regional GPUG Chapter
    Summit Track Leader
    GPUG All Star 2016

    GP2015 R2
    MR CU14

    Follow me on Twitter: @Automate_It

    GPUGGA - www.gpug.com/Atlanta


    *** Help Us, Help You...provide enough info so that we don't have to ask for more:) ***
    *** If you solve your issue please share the solution to assist others! ***
    ------------------------------

    Conference-GPUG_200x200


  • 3.  RE: dexterity save error 30

    GPUG ALL STAR
    Posted Oct 17, 2017 11:28 AM
    Hi @Bruce Strom and @Frank Heslin

    It worked, but was just about to call it a night.

    A RECORDCHANGED error is expected if two people save the same record at the same time AND change the same field.

    Your code should have handling for the error, or use activity tracking to prevent two users in the same record.

    Usually for a master record, after an error message we reread the data and display it to the window and let the user make the change again.

    The other possible error is DUPLICATE for a newly added record.

    Good night

    David ​​

    ------------------------------
    David Musgrave MVP, GPUG All-Star

    Managing Director
    Winthrop Development Consultants

    Perth, Western Australia

    http://www.winthropdc.com
    ------------------------------

    Conference-GPUG_200x200


  • 4.  RE: dexterity save error 30

    TOP CONTRIBUTOR
    Posted Oct 17, 2017 11:35 AM
    Edited by Bruce Strom Oct 17, 2017 11:47 AM
    Hi @David Musgrave,

    After reading your answer carefully, I now know what to do.

    I will usually not error out, but caution the user that someone else also tried to change that value, and display a message to the user.

    Thanks,
    Bruce
    Conference-GPUG_200x200


  • 5.  RE: dexterity save error 30

    GPUG ALL STAR
    Posted Oct 17, 2017 10:11 PM
    Correct! This is all good, but you need to re-read the record to display it back to the user and give them the chance to make the changes they expected to complete (or cancel out). This is how all GP master record maintenance screens work.

    ------------------------------
    Mariano Gomez, MVP, Dynamics Credentialed Professional
    Software Development Manager
    Mekorma
    Alpharetta GA
    ------------------------------

    Conference-GPUG_200x200


  • 6.  RE: dexterity save error 30

    TOP CONTRIBUTOR
    Posted Oct 18, 2017 12:17 PM
    ​But our users never read any messages, they just click, click, click through them.

    I actually had one user ask me why she had to click through all those messages, couldn't I just get rid of them?  I said Dorothy, those messages mean that the program is trying to talk to you, it is trying to tell you things, do you really want me to get rid of them?  She said no, that's okay, I can keep them in.

    ------------------------------
    Bruce Strom
    Programmer Analyst
    Associated Grocers of Florida
    sunrise FL
    ------------------------------

    Conference-GPUG_200x200


  • 7.  RE: dexterity save error 30

    GPUG ALL STAR
    Posted Oct 19, 2017 01:10 AM
    I sometimes swap the OK & Cancel or Yes & No buttons around to make sure the user has to read the message before they click.

    ------------------------------
    David Musgrave MVP, GPUG All-Star

    Managing Director
    Winthrop Development Consultants

    Perth, Western Australia

    http://www.winthropdc.com
    ------------------------------

    Conference-GPUG_200x200


  • 8.  RE: dexterity save error 30

    TOP CONTRIBUTOR
    Posted Oct 20, 2017 03:43 PM
    Or you can have a data entry box and say, Please enter PASSWORD to continue, and if they call and ask, What do I enter, you can say, please follow instructions, enter PASSWORD.

    ------------------------------
    Bruce Strom
    Programmer Analyst
    Associated Grocers of Florida
    sunrise FL
    ------------------------------

    Conference-GPUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role