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.

The insert, update, and delete methods perform operations on only one record at a time. The array insert, insert_recordset, RecordInsertList, and update_recordset statements perform operations on multiple records at a time.