Dynamics ax 2012 – Copying Temp Table instance for SQL TempDB

SQL Temp db introduced in Dynamics Ax 2012 is powerful then the “In memory” tables that was in use so far. It works across tiers and is relatively easier to understand and use.

This  post is about creating a new instance link(Populating data/Copying Reference) from one table instance variable to the other with SQL temp db type tables. With the standard “In memory” tables to copy the reference we use the “setTmpData” but for SQL temp db use the method mentioned below

static void UsingInMemory(Args _args)
{
   //Inmemory
   TmpABC abc, newAbc;

   abc.Amount = 50;
   abc.insert();

   newAbc.setTmpData(abc);
}

static void UsingSQLTempDB(Args _args)
{
   //SQL TempDB
   TmpABC abc, newAbc;

   abc.Amount = 50;
   abc.insert();

   newAbc.linkPhysicalTableInstance(abc);
}