PARAMETERS Declaration
Declares the name and data type of each parameter in a parameter query .
Syntax
PARAMETERS name datatype [, name datatype [, ...]]
The PARAMETERS declaration has these parts:
| Part | Description |
|---|---|
| name | The name of the parameter. Assigned to the Name property of the Parameter object and used to identify this parameter in the Parameters collection. You can use name as a string that is displayed in a dialog box while your application runs the query. Use brackets ([ ]) to enclose text that contains spaces or punctuation. For example, [Low price] and [Begin report with which month?] are valid name arguments. |
| datatype | One of the primary Microsoft Jet SQL data types or their synonyms. |
Remarks
For queries that you run regularly, you can use a PARAMETERS declaration to create a parameter query. A parameter query can help automate the process of changing query criteria . With a parameter query, your code will need to provide the parameters each time the query is run.
The PARAMETERS declaration is optional but when included precedes any other statement, including SELECT .
If the declaration includes more than one parameter, separate them with commas. The following example includes two parameters:
PARAMETERS [Low price] Currency, [Beginning date] DateTime;
You can use name but not datatype in a WHERE or HAVING clause. The following example expects two parameters to be provided and then applies the criteria to records in the Orders table:
PARAMETERS [Low price] Currency,
[Beginning date] DateTime;
SELECT OrderID, OrderAmount
FROM Orders
WHERE OrderAmount > [Low price]
AND OrderDate >= [Beginning date];
See Also
| EXECUTE Statement | SELECT Statement |
| HAVING Clause | WHERE Clause |
| Microsoft Jet Database Engine SQL Data Types |