Skip to main content

Posts

Showing posts from October, 2018

Select Statement Syntax

Applies To:  Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012 SelectStatement = select Parameters Parameters [ [  FindOptions  ] [  FieldList  from ] ] TableBufferVariable [ IndexClause ] [  Options  ] [  WhereClause  ] [  JoinClause  ] FindOptions = crossCompany | reverse | firstFast | [ firstOnly | firstOnly10 | firstOnly100 | firstOnly1000 ] | forUpdate | noFetch | [forcePlaceholders | forceLiterals] | forceselectorder | forceNestedLoop | repeatableRead | validTimeState FieldList = Field  { ,  Field  } | * Field = Aggregate  (  FieldIdentifier  ) |  FieldIdentifier Aggregate = sum | avg | minof | maxof | count Options = [ order by , group by ,  FieldIdentifier  [ asc | desc ] { ,  FieldIdentifier  [...

AX2012 CompileCIL and Refresh Services using X++

static void CILRefreshServices(Args _args) {     #AviFiles     #File     #define.fileName('AxTime.txt')     TextIo                  file;     FileIoPermission        permission;     SysOperationProgress    progress;     container               fileContainer;     int                     i;     Dialog                  dialog;     DialogField             dlgCompile;     DialogField             dlgCIL;     DialogField             dlgIncCIL;     DialogField             dlgRefreshService;     int           ...

Dynamics AX Frameworks

Dynamics AX provides different framworks for each functionality. Following are the list of AX frameworks 1. Runbase Framework 2. Batch Framework 3. Dialog Framework 4. Operation Progress Framework 5. NumberSequence Framework 6. SysLastValue Framework 7. AIF-Application Integration Framework 8. Wizard Framework 9. Infolog Framework 10.Unit Test Framework