PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • How to proceed?
  • Creating an insert query
  • Notes
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Creating an insert query
Overview
An insert query (corresponding SQL statement INSERT) is used to add records into a database file.
The following information is required to perform an insert query:
  • the file into which the data will be inserted.
  • the items into which new values will be inserted.
For example, creating a new customer in "Customer" file:
Insert query
The query editor automatically generates the SQL code of this query.
To see the SQL code of a query:
  1. Display the popup menu of the query graph.
  2. Select "SQL code".
You also have the ability to press [F2].
In our example:
INSERT INTO CUSTOMER
(
Title,
CustomerName,
Company,
Address1,
ZipCode,
City
)
VALUES
(
'Miss',
'Montgomery',
'UNISOFT',
'Accacia Avenue',
'EC4',
'London'
)

Important

Reports & Queries cannot be used to create insert queries.
How to proceed?

Creating an insert query

To create a new insert query:
  1. Select "File .. New .. Query". The wizard for query creation starts.Click New among the quick access buttons.
    • Click "Queries" in the wheel that is displayed. The window for creating a new element is displayed: click "Queries".
    • The wizard for query creation starts.
  2. Specify that you want to create an insert query ("Insert" option).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 must be attached.
    Go to the next wizard step.
  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 file items. Click the "Value/Parameters" column for each relevant item. A window allows you to select the value or the parameter to insert.
  6. Specify the value or the parameter containing the value to insert. 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.
  7. Validate your choice.
  8. Repeat the operations 5 to 7 for each item into which a value must be inserted.
    Go to the next step.
  9. Type the name of the query (name of the ".WDR" file corresponding to the query). This name will be used to identify the query in your programs.
  10. Specify the caption of the query by briefly describing the purpose of the query. This caption will be used in the project documentation.
    Note: The query name is automatically defined from the caption typed.
  11. Validate the description of the query. The graphic representation of the query is automatically displayed in the query editor.
Notes
  • To modify the characteristics of a query, select "Insert query .. Query description". See Describing a query for more details.To modify the characteristics of a query: on the "Query" pane, in the "Edit" group, select "Description". See Describing a query for more details.
  • To generate the SQL code corresponding to this query, select "Insert query .. SQL code". If modifications are performed in the description of the query, these modifications will be automatically carried over into the corresponding SQL code.To generate the SQL code corresponding to this query, select "SQL code" from the popup menu of the query. If modifications are performed in the description of the query, these modifications will be automatically carried over into the corresponding SQL code.
  • You also have the ability to create a query from one or more files described in the data model editor: to do so, Drag and Drop the selected files from the "Analysis" pane to the query editor.
  • The test of the created query can be run from the query editor. See Running the test of a query for more details.
See also
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment