VALIDATE

The syntax of the VALIDATE function is as follows:

Record.VALIDATE ( Field [, Value] )

VALIDATE will fire the OnValidate trigger of Record.Field. If we have specified a Value, that Value is assigned to the field and the field validations are invoked.

If we don't specify a Value, then the field validations are invoked using the field value that already exists in the field. This function allows us to easily centralize our code design around the table, which is one of NAV's strengths.

For example, if we were to code changing Item."Base Unit of Measure" to another unit of measure, the code should make sure the change is valid. We should get an error if the new unit of measure has any quantity other than 1 (because that is a requirement of the Base Unit of Measurement field). Making the unit of measure change with a simple assignment statement would not catch a quantity error.

Following are the two forms of using VALIDATE which give the same end result:

• Item...