It is possible to include parameters in the following notations to the query:

= :param (named notation)

= ? (unnamed notation)

= @Param (for MS SQL only)

Active Query Builder does not execute SQL queries, but it provides all necessary information about parameters that were used in the query. You should examine the QueryBuilder.Parameters collection before query execution and display a dialog prompt for parameter values based on the information from this collection. An example of such usage is provided in the sample projects that included in the installation package.

Note: Some data access components may lack support of all of the mentioned parameter notations; please refer to the documentation to your data access components for details.

Note: The Parameters collection is not available in the Free version. Use the Trial or Standard version to work with parameters.

Is this article helpful for you?