Show AllReturns information about the parameters for a parameter query. This request is available only on the system channel.
Syntax
ParameterNames2( )
For each parameter, ParameterNames2 returns the name, data type, and most recently used value. ParameterNames2 returns a 3 column by N row array in xlTable format, as follows:
| Column 1 | Column 2 | Column 3 |
|---|---|---|
| Parameter name | Column data type | Most recently used parameter value, if available; otherwise, null |
For information about xlTable format, refer to Visual Basic Help for Microsoft Excel.
The ParameterNames2 request can be used at any time, even if parameters have been disabled for a query by the EnableParameters command. If the query has no parameters, ParameterNames2 returns an empty array.