Collapse the table of content
Expand the table of content

TABLENO Function (RecordID)

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

No := RecordID.TABLENO



Type: RecordID

The RecordID of the record whose number you want returned

Type: Integer

The number of the table.

In previous versions of Microsoft 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 Microsoft Dynamics NAV 2009, 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 2009 instead.

Community Additions

© 2015 Microsoft