|
|
|
|
|
|
|
|
- Creating a query with parameters
- Test of a query with parameters
Creating and testing a query with parameters
Creating a query with parameters Regardless of the query type (Select, Insert, Delete, Update) and regardless of its creation mode (with the wizard or by SQL directly), you have the ability to use parameters. The name of the parameter is specified when creating the query. To create a query with parameters: - Create a query. For more details on how to create a query, see How to create a query?.
- When defining the selection conditions:
- specify that the selection condition corresponds to a parameter,
- give the name of this parameter.
Test of a query with parameters To test a query with parameters: - Open the query with parameters in the query editor.
- Click
 in the quick access buttons. - Specify the value of the parameters that will be used for the query test. In this window, you have the ability to select an existing value via
 . The following menu is displayed: - You can:
- select one of the possible values among the values found in the file
- view the entire file.
Caution: This option is available only if Live Data is enabled. For more details, see Live Data.
- Validate. The query result is displayed according to the specified values.
Remark: If no parameter was selected (unchecked parameter), the conditions that use the parameters will be ignored.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|