PC SOFT

WINDEV的在线文档

  • Overview
  • How to proceed?
  • Modifying the sequence of selection conditions in a Select query
  • Modifying the sequence of selection conditions in an Update query or in a Delete query
  • Modifying the sequence of selection conditions from the graphic representation of the query
文档页面当前正在翻译。对于此延迟我们深表歉意。
您可以自愿地帮助我们翻译您想要的文档段落,然后只需通过以下地址与我们联系: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本地访问

Sequence of selection conditions for a query

Overview
When at least two selection conditions are found in a query, the sequence of selection conditions must be specified by the conditional operators AND and OR:
  • Conditional AND operator: the selected records will match both conditions. For example, select the customers whose name starts with the letter "A" AND who live in London.
  • Conditional OR operator: the selected records will match one of the two conditions or both conditions. For example, select the customers who live in London OR in New York.
Conditional AND operator
Conditional AND operator
Conditional OR operator
Conditional OR operator

The sequence of selection conditions is defined during the creation of the query. However, this sequence can be modified.

How to proceed?
Two methods can be used to modify the sequence of selection conditions in the current query:
  • 1st method: via the description window of the query.
  • 2nd method: from the graphic representation of the query.

Modifying the sequence of selection conditions in a Select query

To modify the sequence of selection conditions in the current Select query via the description window of the query:
  1. Display the popup menu of the query (right mouse click) and select "Query description". The description window of the query is displayed.
  2. Click the "Selection condition" button and select "Existing conditions".
  3. Modify the sequence of selection conditions.
  4. Validate. The modification is automatically performed in the query.

Modifying the sequence of selection conditions in an Update query or in a Delete query

To modify the sequence of selection conditions in the current Update or Delete query via the description window of the query:
  1. Display the popup menu of the query (right mouse click) and select "Query description". The description window of the query is displayed.
  2. Select the "And/Or" tab.
  3. Modify the sequence of selection conditions.
  4. Validate. The modification is automatically performed in the query.

Modifying the sequence of selection conditions from the graphic representation of the query

To modify the sequence of selection conditions in the current query via the graphic representation of the query:
  1. Select the selection condition whose sequence must be changed in the graphic representation of the query.
  2. Select "Reverse AND/OR" from the popup menu (right mouse click) of the current selection condition.
  3. The new sequence of selection conditions is automatically applied to the query.
另见