You can use SQL statements either interactively or within source code, to access and retrieve data that is stored 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.
The insert, update, and delete methods perform operations on only one record at a time. The array insert, insert_recordset, RecordInsertList, and update_recordsetstatements perform operations on multiple records at a time. However, the X++ record-set operations can fall back to record-by-record operations in a number of situations.
For more detail information Go to the :