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 3 – Data Manipulation
Data manipulation in X++ refers to interactively using SQL commands. These commands include insert, update and delete. These are required to modify the data in the database. When values are assigned to a table buffer, the data is not updated in the database.
You can use SQL statements either interactively or within source code, to access and retrieve data that is stored in the database. Data manipulation is performed through the following statements:
- insert adds one or more new records into a table.
- update modifies data in existing table records.
- delete removes existing records from a table.
Before any data can be changed in Microsoft Dynamics AX, the data must first be selected for update by using a select statement. The select forUpdate command selects records exclusively for update.