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);
}

Demo of the New X++ Editor for Dynamics Ax 2011/6.0

Look in to the video for an exciting demo on the features of X++ Editor in coming up Dynamics Ax version.

Also look here for the post related to it ….

http://blog.amer-ax.com/?p=406

Awaiting to get hands on 🙂