PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • How to proceed?
  • 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/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Operations in a Select query : addition and deletion
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 proceed?

Adding an operation into the current Select query

To add an operation into the current select query:
  1. Select "Query .. Query description". The description window of query is displayed.On the "Query" pane, in the "Edit" group, click "Description". The description window of query is displayed.
  2. In the middle section, select the item on which an operation must be performed.
  3. To calculate:
    • the sum of item values, click the "Sum" button.
    • the average of item values, click the "Average, Max, Min" button and select "Average".
    • the maximum value of item values, click the "Average, Max, Min" button and select "Maximum".
    • the minimum value of item values, click the "Average, Max, Min" button 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. Select "Query .. Query description". The description window of query is displayed.On the "Query" pane, in the "Edit" group, click "Description". The description window of query is displayed.
  2. In the middle section, select the calculation item to delete.
  3. Press the [Del] key.
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment