HomeActive Query Builder - IntroductionCommon QuestionsWorking with parameters

3.5. Working with parameters

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.

Please note that some data access components may not support all of the mentioned parameter notations; please refer to the documentation to your data access components for details.

Please note that the Parameters collection is not available in the Free version. Use the Trial or Standard version to work with parameters.

This page was: Helpful | Not Helpful