Tuto WINDEV 25

184 Part 4: Full application with data Remark Live Data and controls based on queries The Live Data is not displayed in the controls that use a query as data source for the following reason: the data displayed in the control depends on the query result therefore it is known at run time only. ▶ We are going to run a first test of this window: 1. Click among the quick access buttons. 2. Click the "Finding orders" tab pane. Only some orders are displayed, like during the last query test run in the editor, when parameters were specified in the test window of query. 3. Close the test window to go back to the editor. ▶ Let’s take a look at the WLanguage events associated with the Table control: 1. Select the Table control. 2. Display the popup menu (right mouse click) and select "Code". 3.  The "Initializing TABLE_QRY_FindOrders" event contains the following code: // Parameters of ’QRY_FindOrders’ query //MySource.ParamStatus = <Value of ParamStatus> MySource.ParamPaymentModeID = "1" MySource.ParamStartOfPeriod = "20160101" MySource.ParamEndOfPeriod = "20160331" The test parameters have been retrieved as default parameters for the execution. We are now going to modify the window in order for the parameters to be typed by the user, via controls. 4. Close the code editor (click the cross in the top right corner of editor).