|
|
|
|
|
|
|
|
|
|
- Overview
- Query characteristics
- Creating a query from the report editor
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, regarding the Sales Management application, you want to find out: - the orders placed in March 2015. You are going to create a query that will select from the ORDER data file only those orders with a date between 03/01/2015 and 03/31/2015.
The REQ_Mars2015 query interrogates the data file COMMANDE. - the numbers of the orders placed by customers who live in Paris (France). You are going to create a query that will interrogate:
- CLIENT data file to select only customers living in Paris (France).
- ORDER data file to display order numbers.
The elements and characteristics of a query are: Once created, the characteristics of this query can be modified at any time. For more details, see Describing a query. Creating a query from the report editor When creating a report, you can define a query. This query will be called embedded query.
Related Examples:
|
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.
|
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|