FIELDCOUNT Function (KeyRef)

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

Syntax


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

KeyRef Data Type