HostIntegratorSession.PerformTableProcedure Method (String, String, IDictionary, IDictionary, Boolean, IList, Int32)

Performs a procedure on a table defined in the model.

public DataSet PerformTableProcedure(
   string tableName,
   string procedureName,
   IDictionary inputValues,
   IDictionary filterValues,
   bool filterIsCaseSensitive,
   IList outputColumnNames,
   int maxRows
);

Parameters

tableName: Specifies the name of the table on which to perform the procedure.
procedureName: Specifies the name of the table procedure to perform.
inputValues: Specifies a set of column name-value pairs to input.
filterValues: Specifies a set of filter column name-value pairs to use.
filterIsCaseSensitive: Specifies whether the filter comparison should be case sensitive.
outputColumnNames: Specifies the names of the columns to return.
maxRows: Specifies the maximum number of rows to return. If maxRows is set to 0, no limit is imposed on the number of rows returned.

Return Value

This method returns the result of the table procedure, if applicable. If no data match the specified conditions, this method returns an empty DataSet.

Remarks

Performs a table procedure on a table defined in the model.

Exceptions

Exception Type	Condition
HostIntegratorModelDefException	Thrown if a reference is made to a non-existent table, procedure, or table column
HostIntegratorConnectorException	Thrown if client is not connected
HostIntegratorException	Thrown if the connection is for metadata only
HostIntegratorServerException	Thrown if an error occurs while performing the procedure

HostIntegratorSession.PerformTableProcedure Method (String, String, IDictionary, IDictionary, Boolean, IList, Int32)

Parameters

Return Value

Remarks

Exceptions

See Also