Tuto WEBDEV 25

Part 5: Let’s continue the development 169 This interface includes: • controls used to select the search criteria. • buttons used to start the search or to 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 results. 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 select the records corresponding to the specific criteria. This type of query is called a select query because the SELECT command is used in SQL language. Creating the query used to find orders Creating the query ▶ The query editor will be used to create the query. 1. Click among the quick access buttons. The element creation window appears: click "Query". The query creation wizard starts. 2. Select the "Select" option. Indeed, this query will be used to select records. Go to the next step. 3.  The query description window is displayed.