Select Statements on Fields [AX 2012]

Updated: February 7, 2012

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

It is possible to use a select statement in a lookup on a field. Following a select statement that fetches a record in a table, you can write .fieldName to reference a field in the table. These select statements must be used in expressions.

There is a difference between a normal select statement and a field select statement:

  • The field select statement operates directly on a table.

  • The normal select statement operates on a table buffer variable.

void selectFieldExamples ()
{
    ;
    // Prints the NameRef field from the selected customer
    print (select CustTable order by AccountStatement).AccountStatement;
         pause;
 
    // Uses the balance field from the customer with AccountNum 3000
    if ((select custTable where CustTable.AccountNum == '3000').CreditMax < 50000)
      print "This customer has a credit maximum less than $50,000.";
      pause;
}

Announcements: New book: "Inside Microsoft Dynamics AX 2012 R3" now available. Get your copy at the MS Press Store.

Community Additions

ADD
Show: