Dataset Objects
You can access the DataSet object using the ObjMethod function. A more efficient method is to use these commands:
| Command | Description |
|---|---|
| ObjectDataSet | The ADO.Net DataSet object for the required object is retrieved. |
| DataSetTableName |
The logical table name of the requested detail code is retrieved. This facilitates the retrieval of the data from the ADO.Net DataSet object. |
| GetNewRow |
A blank row for the required detail code is returned. If the detail code has an auto-sequenced line ID column, the next row number value, for the new row, is filled automatically. 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 |
The new row returned from the The rows can be committed to the table only if each column that requires a value has a value. An exception is thrown if a row with same key value already exists in the table as the new row, |
| RowUpdate |
Enables the script to call the same This command is optional. It is useful, for the Formula Ingredient detail, because the new rows Quantity % column is calculated. |