Tuto WINDEV 25

172 Part 4: Full application with data Overview In the previous lesson, we have explained how to perform a search on a single criterion (the customer name). In this lesson, we will give the user the ability to perform a multicriteria search. In our example, this search will be done on the "Orders" data file. The user will be able to select: • the order status, • the payment mode, • the order dates taken into account.The interface of "WIN_Menu" window is as follows: This interface includes: • controls used to select the search criteria. • Button controls used to start the search or print the result. • a Table control used to display the search result. This Table control is based on a query. This query will be used to select the records to display. The Table control will list the search result. The first step consists in creating the query used to select the records. Remark What is a select query? A select query is a query that will "choose" the records corresponding to the specified criteria. This type of query is called a select query because the SELECT command is used in SQL language. Answer A corrected project is available. This project contains the different windows created in this lesson. To open the corrected project, in WINDEV’s home page (Ctrl + <), click "Tutorial" and select "Full application (With windows)".