5,124
Is there any way I can lock a record as I get into Card Page? This way, any changes I make will supercede any changes made by other users, assuming I was the first one to open the page. Also, how can I error out if the record I am trying to modify was opened first by another user?
*This post is locked for comments
Still thinking why you are adding this with AND Operator
If (LockerID <> USERID) AND (LockerID <> '') then
LockerID will never be blank because you already wrote this code on OnOpen Page trigger
2. Put
LockerID := USERID;
Modify;
In OnOpenPage trigger
Yes, testfield exception is totally not user-friendly. Error is better.
But with using error it should be like this:
If (LockerID <> USERID) AND (LockerID <> '') then
ERROR('Record is locked');
In 2017 and 2018 NAV you also could create some magic:
if LockerID <> USERID then begin
LockNotification.MESSAGE('Record is locked');
LockNotification.SCOPE:=NOTIFICATION::LocalScope;
LockNotification.SEND;
end;
Where LockNotification is variable with type = notification
Notifications are most user-friendly way to inform.
Seems to be a nice approach as mentioned by above just in the last one
if LockerID <> USERID then
TESTFIELD(LockerID, '');
I will put some realistic custom Error instead of the error that will be self generated by TESTFIELD Command.
1. Create a new field "LockerID" in your table
2. Put
LockerID := USERID;
Modify;
In OnOpenPage trigger
3. Put
LockerID := '';
Modify;
in OnClosePage trigger
4. Put
if LockerID <> USERID then
TESTFIELD(LockerID, '');
in OnModify trigger in your table
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (