Data Selection and Manipulation in X++: Techniques and Best Practices
☰Fullscreen
Table of Content:
This topic describes the support for data selection and manipulation in the X++ language.
You can use SQL statements, either interactively or within source code, to access and retrieve data that is stored in the database. You use the following statements for data manipulation:
- select – Select the data to modify. Click here for more details.
- insert – Add one or more new records to a table. Click here for more details.
- update – Modify data in existing table records. Click here for more details.
- delete – Remove existing records from a table. Click here for more details.