CHAPTER 1 - Introduction to X++
CHAPTER 2 - X++ Control Statements
CHAPTER 3 - Objects and Classes
CHAPTER 4: Accessing the Database
CHAPTER 5: Exception Handling
CHAPTER 6: Security for Developers
Lesson 2 – Retrieving Data
Retrieving Data in Microsoft Dynamics AX 2012 accesses data using select statements and queries. This section focuses on select statements.
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++.