AutoGen Update rules: the clause WHERE <fieldname> IS NULL should not be added if Console.dbo.ttTargetField.DefaultValue is populated

When creating the Update rules via AutoGen, the clause

WHERE <fieldname> IS NULL 

is added to the UpdSel views by default.

This where clause filters out all records if the field to be updated has a default value set up in Design.

As a consequence the update rule needs to be manually edited after AutoGen creates it, having to remove the where clause to make it work correctly.

  • Ana GARCIA RUBIO
  • May 18 2018
  • Shipped
  • Attach files
  • Admin
    Jon Green commented
    24 Aug, 2018 10:31am

    Thanks for sending this idea.  We will place this into backlog as part of the improvements to the autogen logic.