Index vs Index hint

Hello, Index : Using “Index“: when you add the statement “index MyIndex”, the Axapta kernel will add an “ORDER BY” with all the fields of the index. Example: select * from InventTable index GroupItemIdx will generate the following SQL statement to the database: SELECT A.ITEMGROUPID, A.ITEMID, A.ITEMNAME,…. FROM INVENTTABLE A ORDER BY A.ITEMGROUPID, A.ITEMID The…

CIL in AX 2012?

Hi There, On this post I would like to talk about a bit more about the CIL and what happens in the background. Recently I had to go through a process to find a CIL error I got after deploying a service. You can read my post solving the error “The CIL generator found errors…