FIELDEXIST Function (RecordRef)

Determines if the field that has the number FieldNo exists in the table that is referred to by the RecordRef. Returns an error if no table is currently selected.

Exist := RecordRef.FIELDEXIST(FieldNo)

Parameters

• RecordRef
  Type: RecordRef The RecordRef that identifies the record and the table in which you are interested.

• FieldNo
  Type: Integer The FieldNo that you want to know whether it exists in the table.

Property Value/Return Value

Type: Boolean

true if the field exists in the table; otherwise, false.

Example

The following example opens table 18 (Customer) as a RecordRef variable that is named MyRecordRef. The code loops through fields 1 through 12 and uses the FIELDEXIST function to determine whether the specified field exists. If the field exists, the name of the field and a message that indicates that the field exists is displayed. Otherwise, a message that indicates that the field does not exist is displayed. This example requires that you create the following variables and text constants in the C/AL Globals window.

MyRecordRef.OPEN(18);
FOR i := 1 TO 12 DO BEGIN
  IF MyRecordRef.FIELDEXIST(i) THEN BEGIN
     VarFieldName := MyRecordRef.FIELD(i);
     MESSAGE(Text000, i, VarFieldName.NAME);
    END
  ELSE
    MESSAGE(Text001, i);
  END;

See Also

Reference

RecordRef Data Type