D365FO: TempDB tables

In D365FO all types of temporary tables are automatically dropped by the system when the table variable in X++ goes out of scope. A TempDB table is not dropped in such case. You could see capabilities and limitations of TempDB tables here.

Sometimes there is a need to add more information to existing TempDB table, typical using event handling extensions or chain of command. In this case you may realise that the data you are adding is not saved/missing. This happens becase new data will be saved in a different TempDB table session and will not be visible by the code/form you are trying to extend.

The solution is to use a special linkPhysicalTableInstance() method to link current table instance with existing one.

Code example below:

    MyTempDBTable myTempDBTableCaller;
    
    public void init()
    {
        MyTempDBTable myTempDBTable;
    
        next init();

        myTempDBTable.linkPhysicalTableInstance(myTempDBTableCaller.cursor());        
        
        // insert more data to existing myTempDBTable session
        ...
    }