ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Editors / Query editor / Operations on queries
  • Overview
  • How to?
  • 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
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
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.
AND
Conditional AND operator
OR
Conditional OR operator
The sequence of selection conditions is defined when creating the query. However, this sequence can be modified.
How to?
Two methods can be used to modify the sequence of selection conditions in the current query:
  • 1st method: via the description window of query.
  • 2nd method: from the graphic representation of 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. Right-click to open the context menu of the query and select "Query description". The query description window appears.
  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. Right-click to open the context menu of the query and select "Query description". The query description window appears.
  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 modified in the graphic representation of the query.
  2. Right-click the current selection condition and select "Reverse AND/OR" in the context menu.
  3. The new sequence of selection conditions is automatically applied to the query.
See also
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help