Use this function to enter a new value into a field and have the new value validated by the properties and code that have been defined for that field.

FieldRef.VALIDATE([NewValue])

Parameters

FieldRef

Type: FieldRef

Refers to the current field.

NewValue

Type: must be compatible with the data type of the field referred to by the FieldRef.

The value to insert in the field.

Remarks

The VALIDATE function first checks any TableRelation Property, and then executes the OnValidate (Fields) Trigger of the field.

If you omit NewValue, the function validates the current value.

This function is like the VALIDATE Function (Record).

Example

The following example opens table 17 (G/L Entry) as a RecordRef that is named EntryRecref. The FINDFIRST Function (RecordRef) searches for the first record in the table. The FIELD Function (RecordRef) sets the field to 3, which is the G/L Account No. field. The VALIDATE function validates and inserts the specified value (1210) into the field. The MODIFY Function (RecordRef) modifies the table. A message that indicates the G/L Account No. field has changed is displayed. To show that the code in the OnValidate trigger is executed, design the G/L Entry table and add the following code to the G/L Account No. - OnValidate trigger: MESSAGE('The OnValidate trigger is called.');

This example requires that you create the following variables and text constants in the C/AL Globals windows.

Variable name DataType

EntryRecref

RecordRef

MyFieldRef

FieldRef

Text constant ConstValue

Text000

The G/L Account No. for record %1 is %2.

Text001

The G/L Account No. for record %1 has changed to %2.

 Copy Code
EntryRecref.OPEN(17);
IF EntryRecref.FINDFIRST THEN BEGIN
  MyFieldRef := EntryRecref.FIELD(3);
  MESSAGE(Text000, EntryRecref.RECORDID, MyFieldRef.VALUE);
  MyFieldRef.VALIDATE('1210');
  EntryRecref.MODIFY;
  MESSAGE(Text001, EntryRecref.RECORDID, MyFieldRef.VALUE);
END;

See Also