PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • 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 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 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 version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment