PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

  • 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/iPadApple WatchUniversal Windows 10 AppWindows Mobile
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. See How to create a query in SQL code? for more details
The query editor allows you to create several types of queries:
ImportantReports & Queries cannot be used to create insert queries, update queries or delete queries.
Note: 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 the query is created, the characteristics of this query can be modified at any time. See Describing a query for more details.
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.
The use of native WINDEV commands (HReadFirst, HReadNext, HAdd, HModify, HDelete, ... of WLanguage) 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
ImportantReports & 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 required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment