TABLENO Function (RecordID)

Gets the table number of the table that is identified by RecordID. This function returns an error if the record is blank.

Syntax


No := RecordID.TABLENO  

Parameters

RecordID
Type: RecordID

The RecordID of the record whose number you want returned.

Property Value/Return Value

Type: Integer

The number of the table.

Remarks

In previous versions of Dynamics NAV, if a RecordID referred to a temporary table, then the table number value of the RecordID was the run-time generated sequence ID, which is from the base value of 2000100000. You could use the table number to determine if a RecordID referred to a temporary table. In Dynamics NAV, the table number value of a RecordID always contains the ID of the originating physical table and not the run-time generated sequence ID. If you previously used the TABLENO Function (RECORDID) to test for the sequence number and determine if the RecordID was temporary, then you use the ISTEMPORARY Function (RecordRef) in Microsoft Dynamics NAV 2018 instead.

Example

The following example opens the Customer table with the record reference variable named RecRef and finds the first record in the Customers table. If a record is found, the RECORDID Function (RecordRef) gets the ID of the first record in the table. The TABLENO function then uses the RecID variable to retrieve the number of the table that contains the record. The table number is then displayed in a message box. This example requires that you create the following variables in the C/AL Globals window.

Variable name DataType
RecID RecordID
RecRef RecordRef
varTableNumber Integer

RecRef.OPEN(DATABASE::Customer);  
IF RecRef.FIND('-') THEN BEGIN  
  RecID := RecRef.RECORDID;  
  varTableNumber := RecID.TABLENO;  
  MESSAGE('The Customer table is number: %1', varTableNumber);  
  END  
ELSE BEGIN  
MESSAGE('No records found in the table');  
END;  

See Also

RecordID Data Type