Trigger form when changing post

J-AJ-A Member Posts: 6

there is a problem with users changing data on item records and I have a request to setup a log to track who changes the data.
The log is simple. I lock down the item card with Currform.Editable := false;
And then have a button so a user can request edit rights and when pressing I insert a line into log table along with the username and item no.
The problem is that if a user is at Item001 and reuqest edit, changes to Item003 and change that, I have no record of that.
so when user leave the post I would like to
1. Make the form not editable
2. Log that the user ended its edit session

The first one I can handle by saving the ItemNo when edit begin and in the Form - OnAfterGetCurrRecord() check if it's changed, and then make editable := false;

But I can't make any logging here. When I try I get a "Cannot make any changes in db before a transaction has been started"

Is there a way for me to fix this?


  • Options
    Rishi1109Rishi1109 Member Posts: 43
    Which version of NAV are you using ?
    Thanks and Regards
  • Options
    J-AJ-A Member Posts: 6
    Nav 5 on sql

    I know I'm not allowed to change data i db in the OnAfterGetCurrRecord() trigger, but I was wondering if there is a way around it so I can log this message as I leave the post or "entering" a new
  • Options
    KishormKishorm Member Posts: 921
    Using standard "Change Log" functionality would be a better option, this can log the exact fields/values changed.
Sign In or Register to comment.