18
There is no way to ModifyAll() of a given field within a RecordRef record set to have a new value. This means we either have to
(a) write non-generic code, copied and pasted for each table that needs ModifyAll()d... or
(b) do it by FindSet(true)/repeat/Modify()/etc. - which is a lot slower as it needs to pull and iterate all rows from SQL.
Please add a way with RecordRef and/or FieldRef to achieve the same thing as Record.ModifyAll(Field, NewValue, RunTrigger) - i.e. to direct SQL Server to do an UPDATE Table SET Field = NewValue.
Thanks!
(a) write non-generic code, copied and pasted for each table that needs ModifyAll()d... or
(b) do it by FindSet(true)/repeat/Modify()/etc. - which is a lot slower as it needs to pull and iterate all rows from SQL.
Please add a way with RecordRef and/or FieldRef to achieve the same thing as Record.ModifyAll(Field, NewValue, RunTrigger) - i.e. to direct SQL Server to do an UPDATE Table SET Field = NewValue.
Thanks!
STATUS DETAILS
Needs Votes

Business Central Team (administrator)
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future. Best regards, Business Central Team