UDT Handler form not changing to update when field changed from a SQL report.

Paul Woods

• July 04, 2024 09:33

We have a UDT Handler set up and on the first field we have a validation that activates when someone clicks on the field. This triggers a SQL report when allows the users to select one value. When selected the value is returned to the UDT Handler form changing the value of the field but it is not changing the form button from OK to Update so will not allow you to uodate the UDT, 

Vote

0

• 

  Keshava Best

  • July 09, 2024 15:31

  Hi Paul,
  
  Here is a workaround - I have experienced the same issue.

  
  Create a Universal Function type Dynamic Code with the following command:
  form.Mode = BoFormMode.fm_UPDATE_MODE;
  
  From your Universal Function Macro that sets the value, add the code:
  If $[$1.0.0] = 'OK'
  BEGIN
      UF(UF-0XX); //Set Form Mode Update
  END
  
  Where 0XX is the Universal Function with the Dynamic Code.
  
  Keshava

Please sign in to leave a comment.