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)
The RecordRef that identifies the record and the table in which you are interested.
The FieldNo that you want to know whether it exists in the table.
Property Value/Return Value
true if the field exists in the table; otherwise, false.
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.
|Text constant name||DataType||ENU value|
|Text000||Text||Field %1 exists.\The name of the Field is: " %2 ".|
|Text001||Text||Field %1 does not exist.|
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;