ParamEx

For SAP systems only, this property controls all the business function’s parameter values and allows for nested parameters, like a table parameter that contains another table.

Group: Embedded Procedure Object

Syntax:

emProc.ParamEx(vParamId, vColName, [nRowNo]) = enValue

Alternate: enValue = emProc.ParamEx(vParamId, vColName, [nRowNo])

enValue (EmbeddedParam) the result of the parameter’s value or the value being placed in the parameter

vParamId (Variant) the name of the table usually referred to by name and in double quotes.

vColName (Variant) the name of the column within a table parameter

nRowNo (Long) Optional – the row number within a table parameter

Example:

Dim sError As Variant

sError = emProc.ParamEx("RETURN", "MESSAGE", 1)

In the case of nested parameters, specify the parameter ID and the column that contains the nested table and then use “dot” notation to extend the statement.

Dim vValue As Variant

vValue = emProc.ParamEx("ParamId", "Col1").Param("SubParam", "SubCol")

This notation can be used indefinitely to set or obtain data from structures within other structures. The properties available after the ParamEx property are:

emParam.ParamEx("ParamID", "Col").ColumnCount

emParam.ParamEx("ParamID", "Col").ColumnName

emParam.ParamEx("ParamID", "Col").Param

emParam.ParamEx("ParamID", "Col").ParamEx

emParam.ParamEx("ParamID", "Col").RowCount