ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Editors / Query editor / Query with parameters
  • Creating a query with parameters
  • Test of a query with parameters
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
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:
  1. Create a query. For more details on how to create a query, see How to create a query?.
  2. 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:
  1. Open the query with parameters in the query editor.
  2. Click in the quick access buttons.
  3. 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:
  4. 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.
  5. 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.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 12/21/2022

Send a report | Local help