SetParameterName Command (DDE)

Sets the name of a parameter received in a query string passed to Microsoft Query. SetParameterName should be sent after a BuildSQL command is sent.

Syntax

SetParameterName(index, name)

index The parameter index.

name The name for the parameter.

Remarks

If the SQL statement sent by BuildSQL contains parameters but no SetParameterName commands are received, Query assigns default parameter names in the form "Parameter n," where n is an incrementing number. If the number of parameter names sent using SetParameterName commands is insufficient, the remaining parameters are named "Parameter n". If too many parameter names are sent, the excess names are ignored.