Microsoft Dynamics AX 2012 R3 Development-2 Locus IT Services

Microsoft Dynamics AX 2012 R3 Development-2

Locus IT ServicesMicrosoft Dynamics AX 2012 R3 Development-2

Lesson 2 – Retrieving Data

Retrieving Data:

Retrieving Data in Microsoft Dynamics AX 2012 accesses data using select statements and queries. This section focuses on select statements.

Table Buffers

A table buffer stores complete records in a variable. A table buffer is declared like a variable – the table name is specified in the declaration. It is required when you use select commands to retrieve records and is declared before the select statement.

Queries enable you to ask questions about the data in the Microsoft Dynamics AX database and retrieve information. There are two ways to create queries:

  • Use the Queries node in the Application Object Tree (AOT) to create static queries using a graphical interface. For more information, see How to: Create Queries by using the AOT.
  • Use the query system classes to create dynamic queries in code. For more information, see How to: Create Queries by Using X++.
Locus IT Project Management Office
What’s it?