![]() |
|
| Product | |
| Support | |
| Everything Else... | |
| Validate Specific Fields on Replace | |
| Introduction |
According to The Helix Reference, "When using Replace to modify a record, validation is checked only on the modified Fields." This specification can sometimes cause problems when validating a group of Fields. The following technique will allow validation of all Fields on Replace. |
| Example |
In this example, if each of the three Fields equal 1 then the validation should occur. Create an inert Flag Field. Set the keyboard validation so the Field must equal True. For those Fields that need to pass the validation, create a "Condition" Abacus. The Abacus should return a value of False for the Fields that should pass the validation and True if they should not pass.
If a Field is undefined, it should also pass the validation. Create an "Undefined" Abacus which returns a True value if undefined.
Place the "Undefined" Abacus in the same Data rectangle as the inert Flag Field. When you Enter or Modify a record, the "Condition" Abacus will evaluate the Fields. When a False value is returned, the inert Flag Field's validation will occur. |