ModifyAll is a powerfull statement. However often it is required to modify multple fields within a filterset. Currently it would require multiple ModifyAll statements or looping through the recordset and modify each record 1 by 1. Both solutions have performance drawbacks. It would be nice to have the ability to modify multiple fields at once in a filtered recordset.

Of course when fields have to be validated this will never be a performing instruction so I don't think it is a requirement for ModifyAll to have a validation option.

MyRecord.SetRange(FilerField1, FilterValue1);

MyRecord.SetRange(FilerField2, FilterValue2);

MyRecord.ModifyAll(Field1, Value1, Field2, Value2, Field3, Value3);