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.