iCommand Events and Methods

The SAP Manufacturing Integration and Intelligence (SAP MII) iCommand applet only supports the CreationEvent applet parameter that permits JavaScript functions to be linked to the creation of the applet object on the Web page.

You can use scripting methods to return information from a command.

Features

The following table lists common methods to use with commands. All column and row numbers described start at one.

Method	Use
`Boolean executeCommand()`	Executes the command associated with the query template. It returns True if successful and False if an error occurs.
`String getLastError()`	Returns a string that describes the last error associated with a call to the `executeCommand()` method.
`int getColumnCount()`	Returns the number of columns returned by the query.
`int getRowCount()`	Returns the number of rows returned by the query. Use the `getColumnRowCount()` or `getColumnRowCountByName()` methods for results that may have multiple rowsets (such as a tag history event query).
`int getColumnRowCount(int ColID)`	Returns the number of rows for the specified column.
`int getColumnRowCountByName(String ColName)`	Returns the number of rows for the specified column name.
`int getColumnIndex(String ColName)`	Returns the column number for the specified column name.
`String getColumnName(int ColID)`	Returns the column name for the specified column number.
`String getValue(int ColID, int RowID)`	Returns the value for the specified column and row numbers as a string.
`String getValueByName(String ColName, int RowID)`	Returns the value for the specified column name and row number as a string.
`String getFirstValue(String ColName)`	Returns the first row value for the specified column name as a string.
`int getColumnType(int ColumnNumber)`	Returns the data type as an integer for the specified column number.
`String getColumnDescription(int ColumnNumber)`	Returns the metadata section description of the query result set for the specified column number.