PC SOFT

WINDEV的在线文档

  • Overview
  • Implementation
文档页面当前正在翻译。对于此延迟我们深表歉意。
您可以自愿地帮助我们翻译您想要的文档段落,然后只需通过以下地址与我们联系: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 editor of Select queries is used to limit the number of records that will be displayed in the result of the query. You can:
  • select the first n records found in the result of a query.
  • select the last n records found in the result of a query.
  • select the n records from a given record found in the result of a query.
The number of records to select can be defined:
  • by value.
  • 20版本和更高版本
    in percentage.
    20新版本
    in percentage.
    in percentage.
  • 20版本和更高版本
    by a parameter.
    20新版本
    by a parameter.
    by a parameter.

For example, you want to find out:

  • the ten best customers: the customers with the greatest turnover.
  • the 15 worst selling products.
  • the 20 products found after the record XXX.
  • ...

Implementation
To limit the number of records found in the result of a query:
  1. Display the description window of a Select query: display the popup menu of the query (right mouse click) and select "Query description".
  2. Click the "The first n..." button.
  3. In the window that is displayed, specify the number of records to select.
  4. Validate.
To limit the number of records found in the result of a query:
  1. Display the description window of a Select query: display the popup menu of the query (right mouse click) and select "Query description".
  2. Click the "The first n..." button.
  3. In the window that is displayed:
    • Specify the range of records to select: the first ones, the last ones or a group of records.
    • Specify the number of records that must be taken into account. This number can correspond to:
      • a value.
        20版本和更高版本
        If "In percentage" is checked, the value must correspond to a percentage of all the records.
        20新版本
        If "In percentage" is checked, the value must correspond to a percentage of all the records.
        If "In percentage" is checked, the value must correspond to a percentage of all the records.
      • 20版本和更高版本
        a parameter. The parameter must be specified when running the query. See Two methods for passing parameters to a query for more details.
        20新版本
        a parameter. The parameter must be specified when running the query. See Two methods for passing parameters to a query for more details.
        a parameter. The parameter must be specified when running the query. See Two methods for passing parameters to a query for more details.
  4. Validate.
Note: When selecting a range of records, specify:
  • the subscript of the first record to select.
  • the number of records to select.