Prevent user triggered changes via Table Subscriber

Answers

• Resolus Member Posts: 40

  2022-09-29

  Very special request...
  
  As you said, you can just use the onbeforemodify, onbeforeinsert, and onbeforedelete triggers and indeed check the RunTrigger value.
  When C/AL runs a MODIFY(TRUE) statement that will also be true.
  You could work around it by adding an additional Boolean field in the table, AllowCALChange.
  
  Whenever your subscriber is triggered, you could check both values.
  Before your MODIFY statement, you should simply change the AllowCALChange value to true.
  

  if (not Rec.AllowCALChange) then
      if (RunTrigger) then
          exit;
  
  Rec.AllowCALChange := false;
  ...
  

  
  I don't understand why you would want to restrict changes done through the regular UI, but this workaround should get you your desired result.

  0
• vaprog Member Posts: 1,118

  2022-09-30

  You should make the page(s) Editable=FALSE instead.
  
  You could also monitor all field's OnValidate trigger (Table) and check CurrFieldNo there.

  0
• jordi79 Member Posts: 272

  2022-10-07

  I used CurrentClientType = BACKGROUND instead. The purpose of the customisation was to integrate NAV vendors so that they are managed externally. And since the integration was done via JobQueue, this solution worked for me.

  0