Show AllShow All

ParameterNames2 Request (DDE)

Returns 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.