Fill Param (Stmt/Statement Menu)

The Fill Param function tool displays a dialog box in which you can enter the values of the ParameterValuePtr and StrLen_or_IndPtr buffers for a parameter specified with SQLBindParameter.

If the parameter is a data-at-execution parameter, you can select the SQL_LEN_DATA_AT_EXEC check box; if this check box is selected, the value of StrLen_or_IndPtr is used as the length parameter of the SQL_LEN_DATA_AT_EXEC macro.

If you have called SQLSetStmtAttr to set the SQL_ATTR_PARAMSET_SIZE statement attribute to a value greater than 1 (in ODBC 3.x), or you have called SQLParamOptions with crow greater than 1 (in ODBC 2.x), you can enter parameter values into an array of parameters. Use the Row box to specify which element of the parameter array you are entering a value for. The Row box is disabled unless the SQL_ATTR_PARAMSET_SIZE statement attribute has been set to a value greater than 1, or SQLParamOptions has been called to set crow to a value greater than 1. When you change the value in the Row box, ODBC Test stores the current values of ParameterValuePtr and StrLen_or_IndPtr boxes in the previously specified element of the parameter arrays.