PC SOFT

WINDEV的在线文档

  • Overview
  • Notes
  • Insert query, Update query and Delete query:
  • Principle
文档页面当前正在翻译。对于此延迟我们深表歉意。
您可以自愿地帮助我们翻译您想要的文档段落,然后只需通过以下地址与我们联系:info@cn.windev.com
产品
WinDevWebDev-服务器代码WebDev-浏览器代码WinDev Mobile报表和查询
平台
WindowsLinuxWindows MobileWindows PhoneWindows Store appsAndroidAndroid Widget iPhone/iPad
语言
JavaPHPAjax用户代码(MCU)外部语言
数据库
HFSQLHFSQL Client/Server存储过程HF 5.5OLE DBODBC本地访问

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.
  • entering the SQL code. See How do I 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 the types of queries can be based on the items belonging:
  • to a data file described in the analysis.
  • to 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 (H读第一个, H读下一个, H添加, H修改, H删除, ... 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 the query (Insert, Update, ...).
  • specify (if necessary) the WinDev, WinDev Mobile or WebDev analysis containing the description of the data files onto which the query will be based.
  • select the items to use.
  • enter the characteristics of the query (selection conditions, sort, ...).