PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Actions applied to the query items
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
Description window of select query: Actions applied
Actions applied to the query items
This section of the description window of a query is used to define the different actions that will be applied to the query items.
Available actions
Number 1Item onto which the actions will be applied.
Number 2Allows:
  • display (or not) the values of the selected item in the query result.
  • rename the selected item in the query result (create an alias).
Number 3Sorts the values of the selected item in the query result.
Number 4Adds a new item to the query result. This item corresponds to:
  • the number of records found in a group of records.
  • the number of records found in a data file.
Number 5Adds a new item to the query result. This item corresponds to the sum of a group of records.
Number  6Adds a new item to the query result. This item corresponds to:
  • the mean for a group of records.
  • the minimum value for a group of records.
  • the maximum value for a group of records.
Number 7Modifies the values displayed in the query result. You have the ability to display:
  • the year from a date item.
  • the month from a date item.
  • the state from an item containing a zip code.
Number 8Defines the selection conditions. You can:
  • apply a selection condition to the selected item.
  • modify and/or delete an existing condition.
  • modify the sequence of existing conditions.
Number 9Selects the records corresponding to a given period.
Number 10Selects the first n records or the last n records displayed in the query result.
Number 11Deletes (or not) the "duplicate" records from the query result.
Number 12Used to:
  • specify the type of database used (HFSQL, Oracle or other).
  • manage the joins (add, modify, delete, re-initialize).
  • check (or not) the SQL syntax used (in test mode only.
  • specify the runtime option (optimizing the memory used, checking the file format, ...).
  • specify whether the query is visible in "Reports & Queries".
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment