Manipulate Data

    

                 Throughout Dynamics AX you can find data manipulation done in code by using the
insert(), update(), and delete() methods. An example can be when posting an
invoice. When this is done the system has to create records in journals and update
data in different tables, all based on the data that already exists in an order and in
other base data tables.
In this chapter we will look at the following topics:
• Methods used to validate the data to be inserted, updated, or deleted
(validateWrite, validateDelete, validateField)
• The method used for inserting data (insert())
• The method used for updating existing data (update())
• The method used for deleting records (delete())
• The method to send a request to the database to insert a chunk of data
(insert_recordset)
• The method to send a request to the database to update a chunk of records
(update_recordset)
• The method to send a request to the database to delete a chunk of records
(delete_from)
• Direct handling of data manipulation, without running any code within the
update, insert, or delete methods