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 3 – Data Manipulation

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.

Locus IT Project Management Office
What’s it?