It is possible to include parameters in the following notations to the query:
expression = :param (named notation)
expression = ? (unnamed notation)
expression = @Param (for MS SQL only)
Parameter names can be quoted according to quotation rules of your database server (with double quotes or square brackets)
Some database servers support ordered parameter notation ( "expression = ?1" )
End users can use parameters in any SQL expressions:
Active Query Builder provides the necessary information about parameters that were used in the query via the QueryBuilder.Parameters collection:
- the parameter name,
- prefix symbol ("?", ":" or "@")
- if the left expression is a field, information about this field: field name and database object name.
You can examine this collection before the query execution and prompt the end-user for parameter values. An example of such usage is provided in the sample projects that included in the installation packages.
Note: Some of the data access components may lack the support of some of the mentioned parameter notations; please refer to the documentation for 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.