FIELDCOUNT Function (KeyRef)

Gets the number of fields that have been defined in a key. Returns an error if no key is selected.

No := KeyRef.FIELDCOUNT

Parameters

  • KeyRef
    Type: KeyRef The keyref that refers to the key.

Property Value/Return Value

Type: Integer

The number of fields that have been defined in the key.

Example

The following example retrieves the number of fields that are defined in a key in record. The table with ID 18 (the Customer table) is open with a reference to table 18. The KEYINDEX Function (RecordRef) function retrieves the second key in the record and store the KeyRef in the varKeyRef variable. The FIELDCOUNT Function (KeyRef) is then used to return the number of fields defined in the key and displayed in a message box. This example requires that you create the following variables in the C/AL Globals window.

Variable name DataType

RecRef

RecordRef

varKeyRef

KeyRef

VarCount

Integer

RecRef.OPEN(18);
varKeyRef := RecRef.KEYINDEX(2);
VarCount := varKeyRef.FIELDCOUNT;
MESSAGE('The number of fields defined in the key is: %1', VarCount);

See Also

Reference

KeyRef Data Type