PC SOFT

WINDEV的在线文档

  • Overview
  • Scope of operations
  • When to define the operations?
文档页面当前正在翻译。对于此延迟我们深表歉意。
您可以自愿地帮助我们翻译您想要的文档段落,然后只需通过以下地址与我们联系: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
The query editor allows you to perform operations on the values of an item. The possible operations are:
  • the sum of item values.
  • the mean of item values.
  • the calculation of the minimum value for all the values of the item.
  • the calculation of the maximum value for all the values of the item.

Scope of operations
These operations are performed:
  • on all the records selected by the query.
  • on sub-sets of records (automatically grouped by the query).
For example, you want to find out:
  • the total amount of orders placed by the customers living in Seattle.
  • the order with the smallest amount.
  • the average sum spent by the customer named Darwin.
  • ...

When to define the operations?
The operations are defined when creating the query. However, you have the ability to add, modify or delete the operations performed in a query. See Operations in a query: addition and deletion for more details.

Caution: If the result of the query is displayed in a report, the operations to perform on the values of the items must be defined when describing the report.