There are many contexts in which passing data from one page to another via the URL is a convenient means of transferring data.
Parameters such as primary and foreign key values can be passed from one page to another through the destination page’s URL. For example, you can create a "wizard" from a New Orders page to a New Order Details page by passing the OrderID of the new Orders record on the URL so that the OrderDetails.OrderID field is automatically set in the New Order Details page.
URL parameters can be used for passing data from one page to another when a button is clicked. These URLs are specified via the Button Action Wizard in the Properties dialog (Properties, Bindings tab, Add... or Edit...). For example, when a user clicks the “Show” button on an Show Table page, the the primary key value (ID) of the selected table row entry can be passed to a Show Record page to display the full details of the selected record.
|
|
|
Pass data between pages using URL parameters, as shown in the Button Action Wizard. |
To select which URL parameters to pass, open the Properties dialog and select the button control you wish to configure. Then, go to the Bindings tab and click Add... or Edit... to display the Button Action Wizard.
URL parameters can be used when selecting and displaying data in an SQL query. A URL parameter can provide a value that is compared to the record's field value when that record is read at run-time. Based on the comparison of the two, the record is either included in or excluded from the result set. When Iron Speed Designer generates your application, it creates the “addFilter” mechanism that applies the comparison.
|
|
Select URL parameter to constrain the selection criteria by a parameter passed into the control from the page’s URL. |
Use the Add WHERE Clause dialog in the Query Wizard (Right-click, Query) to select the URL parameters to use in the query.
URL parameters can be used to initialize FieldValue components.
|
|
|
Initialize field values with data passed via URL parameters. |
Select which URL parameter to use in the Properties dialog, Initial Value tab for any FieldValue control.
Passing Primary and Foreign Key Values in URLs
Example: Passing a Record ID from an Add Record Page
