PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Items that can be used in 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
Description window of select query: Items that can be used
Items that can be used in the query
This section of the description window of a query mainly lists the different items that can be used in the query.
List of items that can be used in the query. These items belong to:
  • a file of the analysis associated with the current application.
  • a query of the current application.
Note: To select several items, keep the [Ctrl] key down.

Important

The data files and the file items that can be used in Reports & Queries are defined in the data model editor of WINDEV.
See Distributing Reports & Queries for more details.
Used to add or delete the selected items to/from the query.
The items can be displayed:
  • by associated file or by associated query.
  • in alphabetical order.
Adds a new item to the query result. This item corresponds to a calculation performed on some analysis items.
For example, the "PriceIOT" item corresponds to the "PriceBT" item multiplied by the "VATRate" item.
Displays:
  • the query in natural language.
  • the SQL code corresponding to the query.
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment