Specifications

The Database API 335
• paramNameArray is an array that contains a list of parameter names. You can use the
MMDB.getSPParamsAsString() function to get the parameters of the stored procedure.
• paramValuesArray is an array that contains a list of design-time parameter test values.
Returns
Nothing. This function returns an error if the SQL statement or the connection string is invalid.
Example
The following code displays the results of the executed stored procedure:
var paramNameArray = new Array("startDate", "salary")
var paramValueArray = new Array("2/1/2000", "50000")
MMDB.showSPResultsetNamedParams("EmpDB","getNewEmployees¬
MakingAtLeast", paramNameArray, paramValueArray)