DataSet objects

You can access the DataSet object using the ObjMethod function. A more efficient and robust method is to use these commands:

Command	Description
ObjectDataSet	Retrieves the ADO.Net DataSet object for the requested object.
DataSetTableName	Retrieves the logical table name of the requested detail code. This facilitates the retrieval of the data from the ADO.Net DataSet object.
GetNewRow	Returns a blank row for the requested detail code. If the detail code has an auto-sequenced line ID column, the next row number value, for the new row, is pre-filled. Some detail codes, such as CUSTOM, do not support the addition of new rows. Calling this method on those detail codes throws an exception.
CommitNewRow	Adds the new row that is returned from the GetNewRow command to the data table. Rows can be committed to the table only if each column that requires a value has a value. When a row with same key value already exists in the table as the new row, an exception is thrown.
RowUpdate	Enables the script to call the same RowUpdate logic that the user interface would use for a given detail row. This command is optional. It is useful, especially for the Formula Ingredient detail, because the new row’s Quantity % column is calculated.

These commands offer more direct access to the underlying data objects that Optiva utilizes internally. They can be used to complete these tasks:

• Add rows to any Optiva object.
• Access the DataSet object in a workflow script.
• Import ION information to Optiva.

In this chapter, the commands are presented in alphabetical order.