|
|
|
|
|
- Overview
- Notes
- Insert query, update query and delete query:
- Principle
Two methods can be used to create a query: - creating the query with a wizard or with the description window, and generating the SQL code automatically.
- typing the SQL code. For more details, see How to create a query in SQL code?
The query editor allows you to create several types of queries:  Reports & Queries cannot be used to create insert queries, update queries or delete queries. Remark: All types of queries can be based on items belonging: - to a data file described in the analysis.
- a query that was previously created with the query editor.
Once created, the characteristics of this query can be modified at any time. For more details, see Describing a query. Insert query, update query and delete query: The ability to create insert, update and delete queries is supported for compatibility with the SQL standard. SQL is a query language used to interrogate data but it is not well suited for custom modifications of this data. To add, modify or delete records in a database file, the power and simplicity of WINDEV makes it the ideal and recommended solution  Reports & Queries cannot be used to create insert queries, update queries or delete queries. To create a query, you must: - specify the method used to create the query (wizard, description window or SQL code).
- specify the type of query (insert, update, ...).
- specify (if necessary) the WINDEV, WINDEV Mobile or WEBDEV analysis containing the description of data files on which the query will be based.
- select the items to use.
- enter the characteristics of the query (selection conditions, sort, ...).
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|