Tuto WEBDEV 25
174 Part 5: Let’s continue the development Using parameters in the query In our example, the user will be able to select a value for the following search criteria: • Name of the customer. • Order status. • Order payment mode. • Price of the order. We must modify the query in order for these search criteria to correspond to the query parameters. ▶ To define the query parameters, display the description window of query: double-click the background of graphic query representation (or select "Query description" from the popup menu). ▶ To manage the "Customer name" parameter: 1. Select the Customer.FullName item in the middle of the screen. 2. Expand "Selection condition" (in the window’s "Actions" section) and select "New condition". 3. In the window that is displayed, we are going to specify that the selection condition corresponds to a parameter: • Select "Contains". • Check "the parameter". • Specify the parameter name: "ParamCustomerName". Remark It is recommended to use the prefix "param" on query parameters. This allows you to easily find them in the code editor. When you search for a query parameter, simply enter ‘param’ and the completion of the code editor will propose all the parameters.
Made with FlippingBook
RkJQdWJsaXNoZXIy NDQ0OA==