Jaa


GETPOSITION Function (RecordRef)

Gets a string that contains the primary key of the current record.

Syntax

  
String := RecordRef.GETPOSITION([UseCaptions])  

Parameters

RecordRef
Type: RecordRef

The RecordRef that refers to the record for which you want to know the primary key.

UseNames
Type: Boolean

Indicates whether a reference to the field caption or the field number should be returned.

The UseCaptions parameter is optional. If it is set to true (default value) or if it is empty, then the returned string contains references to field captions in the table with which the record is associated. If the parameter is set to false, then field numbers are used instead.

Property Value/Return Value

Type: Text or code

The name or number of the field that contains the primary key.

Remarks

This function works just like the GETPOSITION Function (Record).

Example

The following example opens the Customer table as a RecodRef that is named RecRef. The RecordRef variable uses the GETPOSITION function to retrieve the position of the primary key. The UseCaptions parameter is set to true so the caption of the field that contains the primary key is returned. If you set UseCaptions to false, the number of the field is returned. This example requires that you create the following variables in the C/AL Globals window.

Variable name DataType
RecRef RecordRef
varPrimaryKey Text
Text constant ENU value
Text000 The primary key is: %1.
  
RecRef.OPEN(DATABASE::Customer);  
varPrimaryKey := RecRef.GETPOSITION(TRUE);  
MESSAGE(Text000, varPrimaryKey);  

See Also

RecordRef Data Type