It would be nice if the auto generated update handler would not include the added_by and added_on trace fields. Because they are automatically included in the update handler you have to set a value for them, even though technically those two fields should never be overwritten. There are workarounds ofcourse, but i’d rather use the auto generated update handler as is. Our project is in Dutch, so if langauge can also be considered when excluding the added trace fields, that would be nice, because we are using toegevoegd_op en toegevoegd_door as added_by/on.
Exclude added_by/added_on from auto generated update handler
Software Factory
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
I like the general idea but I think it should be more generic. Like give a developer the option for a column to set whether this column is used in the automatically generated handlers or not.
I like the general idea but I think it should be more generic. Like give a developer the option for a column to set whether this column is used in the automatically generated handlers or not.
We could provide a Tag that developers then can attach to Columns to exclude them from the automatically generated handlers, but maybe we can think of another way
I like the general idea but I think it should be more generic. Like give a developer the option for a column to set whether this column is used in the automatically generated handlers or not.
We could provide a Tag that developers then can attach to Columns to exclude them from the automatically generated handlers, but maybe we can think of another way
That would work but is also not a great user experience. Maybe you could add it as options in this screen, that seems a logical place:
Agree with Remco. It should be a formal property per column.
Hi all,
We have added in the upcoming release a way that you can exclude columns for the generated insert and update statement. These setting can be found via User Interface --> Subjects --> Columns --> tab: Performance
There you can uncheck if you don't want that column to be used in the auto generated statement. There are some restrictions for the insert handler checkbox. This can not be unchecked if the column is:
Note that it may break your dynamic model if you use select * into #cols from col. Please verify your dynamic model code and add the new columns if needed.