BindSPInput

Description

Specifies that DataWindow Designer bind input parameters in dynamic SQL statements when executing a stored procedure.

Applies to

Syntax

BindSPInput = value

Parameter

Description

value

Specifies whether you want to bind input parameters in dynamic SQL statements when executing stored procedures. Values are:

  • No (Default) DataWindow Designer does not bind parameters in dynamic SQL statements when executing stored procedures.

  • Yes DataWindow Designer binds parameters in dynamic SQL statements when executing stored procedures.

Default

BindSPInput = 'No'

Examples

Example 1

To specify that DataWindow Designer should bind parameters in dynamic SQL statements when executing a stored procedure, type the following in a script:

SQLCA.DbParameter = "BindSPInput = 'Yes'"

See also

DisableBind