Tuto WEBDEV 25

Part 5: Let’s continue the development 183 2. Only orders paid in cash and whose price is found between $1,500 and $3,000 are displayed, like in the last query test run in the editor, when the parameters were specified in the test window of query. 3. Close the browser to go back to the editor. ▶ Let’s take a look at the events associated with the Table control: 1. Select the Table control and press the F2 key. 2.  The "Initializing TABLE_QRY_FindOrders" event contains the following code: // The control is using a query with parameters to display the data. // The parameters of this query must be defined before or // when initializing the control. // The query will be automatically run if at least one parameter is defined. // // See the online help for more details: // Query with parameters, Use in a Table, List Box or Combo Box control // // Parameters of ’QRY_FindOrders’ query //MySource.ParamCustomerName = <Value of ParamCustomerName> //MySource.ParamStatus = <Value of ParamStatus> MySource.ParamPaymentModeID = "1" MySource.ParamMinPrice = "1500" MySource.ParamMaxPrice = "3000" The test parameters have been retrieved as default parameters for the execution. We are now going to modify the page in order for the parameters to be typed by the user, via controls.