ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Editors / Query editor / Creating queries
  • Overview
  • Notes
  • Insert query, update query and delete query:
  • Principle
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Overview
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.
Notes

Insert query, update query and delete query:

The ability to create insert, update and delete queries is supported for compatibility with the SQL standard.
Using native WINDEV commands (HReadFirst, HReadNext, HAdd, HModify, HDelete, ... is much better suited to programming this type of process.
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.
Principle
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, ...).
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 12/08/2023

Send a report | Local help