PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • 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
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
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 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 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 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 modified 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.
See also
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment