PC SOFT

WINDEV的在线文档

  • Overview
  • Characteristics of a query
  • Creating a query from the report editor
文档页面当前正在翻译。对于此延迟我们深表歉意。
您可以自愿地帮助我们翻译您想要的文档段落,然后只需通过以下地址与我们联系: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
A query is used to interrogate a database in order to view, insert, modify or delete data. The structure of the query defines the data used.

A query can interrogate one or more data files.

The query editor allows you to easily create queries without programming.

For example, regarding the Sales Management application, you want to find out:

  • the orders placed in March 2015. You will have the ability to create a query to select the orders placed between 03/01/2015 and 03/31/2015 in the ORDERS file.
    The QRY_March2015 query interrogates the ORDERS file.
  • the numbers of the orders placed by customers who live in Paris (France). You are going to create a query that will interrogate:
    • the CUSTOMER file to select the customers who live in Paris (France).
    • the ORDERS file to display the order numbers.
The QRY_OrdersCustomerParisFrance query interrogates two data files (CUSTOMER and ORDERS).

Note: See Referring to an element in a WLanguage process for more details.

Characteristics of a query
The characteristics of a query are:Once the query is created, the characteristics of this query can be modified at any time. See Describing a query for more details.

WinDev allows you to optimize the execution speed of a query. See Optimizing a query for more details.

Creating a query from the report editor

When creating a report, you have the ability to define a query. The query will be called embedded query.

See Creation mode of queries for more details.