ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Editors / Query editor / Operations on queries
  • Overview
  • How to?
  • Adding an operation into the current Select query
  • Deleting an operation from the current Select query
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Operations in a Select query : add and delete
Overview
The following paragraphs present:
  • the addition of an operation into a Select query.
  • the deletion of an operation from a Select query.
How to?

Adding an operation into the current Select query

To add an operation into the current select query:
  1. On the "Query" tab, in the "Edit" group, click "Description". The query description window appears.
  2. In the middle section, select the item on which an operation must be performed.
  3. To calculate:
    • the sum of the values in the item, click on "Sum...".
    • the average of the values in the item, click on "Average, Max, Min" and select "Average".
    • the maximum value of the values in the item, click on "Average, Max, Min" and select "Maximum".
    • the minimum value of the values in the item, click on "Average, Max, Min" and select "Minimum".
  4. An item corresponding to the requested calculation is automatically added to the query items.
  5. Validate. The operation is automatically added into the query.

Deleting an operation from the current Select query

To delete an operation from the current Select query:
  1. On the "Query" tab, in the "Edit" group, click "Description". The query description window appears.
  2. In the middle section, select the calculation item to delete.
  3. Press the Del key.
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