ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Editors / Query editor
  • Overview
  • Query characteristics
  • Creating a query from the report editor
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
Overview
A query is used to request information from a database to view, insert, change or delete data. The query structure defines the data used.
A query can request information from one or more data files.
The query editor allows you to easily create queries without programming.
For example, in the Sales Management application, you want to find out:
  • the orders placed in March 2015. You are going to create a query used to select the orders placed between 03/01/2015 and 03/31/2015 in the ORDERS file.
    The QRY_March2015 query interrogates the ORDERS file.
  • the numbers of the orders placed by customers who live in Paris (France). You are going to create a query that will interrogate:
    • the CUSTOMER file to select the customers who live in Paris (France).
    • the ORDERS file to display the order numbers.
The QRY_OrdersCustomerParisFrance query interrogates two data files (CUSTOMER and ORDERS).
Remark: For more details on how to manipulate a query in a WLanguage process, see Referring to an element in a WLanguage process.
Query characteristics

Creating a query from the report editor

When creating a report, you can define a query. This query will be called embedded query.
For more details, see Query creation mode.
Related Examples:
WD Managing a computer fleet Complete examples (WINDEV): WD Managing a computer fleet
[ + ] This example presents the management of a computer fleet with WINDEV.
The following topics are presented in this example:
1/ the printed reports,
2/ the graphic representation of the location of the computer,
3/ the automatically filled combo boxes.
Summary of the example supplied with WINDEV:
This example is used to manage a computer fleet.
For each computer, you will be able to define its characteristics, its components, the person who is using it as well as its location in the offices.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 06/22/2023

Send a report | Local help