• the data file into which the data will be inserted.
• the items into which new values will be inserted.

For example, creating a new customer in the "Customer" data file:

The query editor automatically generates the SQL code of this query.

1. Open the context menu of the query graph.
2. Select "SQL code".

Reports & Queries software cannot be used to create insert queries.

Creating an insert query

1. Click in the quick access buttons.
   • In the window that appears, select "Query".
   • The query creation wizard opens.
2. Specify that you want to create an insert query ("Insert" option).
   
3. If your project is linked to no analysis, specify the analysis to which the query will be attached.
   Proceed to the next step of the wizard.
4. Select the data file into which the data will be inserted.
   Go to the next step.
5. The new values will be inserted into the different items of the data file. For each relevant item:
   • Click the "Value/Parameter" column.
   • In the popup window that appears, specify the value or the parameter that contains the value to be inserted.
     
     The new values to insert can correspond to:
     • the default value defined in the analysis.
     • a value that must be specified. Specify this value.
     • a value contained in a parameter. Specify the name of the parameter.
     • a null value.
   • Validate your choice.
6. Repeat the previous steps for each item into which you want to insert a value .
   Note: the button automatically generates a parameter for each item not filled in.
7. Go to the next step.
8. Type the query name (name of ".WDR" file corresponding to the query). This name will be used to identify the query in your programs.
9. Specify the caption of the query by briefly describing the purpose of query. This caption will be used in the project documentation.
   Note: The query name is defined automatically from the label entered.
10. Validate the query description. The graphic representation of query is automatically displayed in the query editor.

• To modify the characteristics of a query: in the "Query" pane, in the "Edit" group, click on "Description". For more details, see Description of a query.
• To generate the SQL code corresponding to this query, select "SQL code" in the context menu of the query. If changes are made in the query description, these changes will be automatically reflected in the corresponding SQL code.
• You also have the ability to create a query from one or more data files described in the data model editor: to do so, Drag and Drop the data files selected in the "Analysis" pane to the query editor.
• The test of the created query can be run from the query editor. For more details, see Testing a query.