THIS ACTION HAS BEEN DEPRECATEDUse AddSDIDetail to deal with detail tables. |
Purpose
Adds an SDI to a Detail table supporting an SDC (which is the Master table). See Comments (below) for an example.
|
PropertyId |
Type |
Property Name and Description |
Mandatory |
| sdcid | string | SDC
Identifier of the SDC (Master table) supported by the Detail table. |
Yes |
| keyid1 keyid2 keyid3 |
string | SDI Key1, SDI Key2,
SDI Key3 Key value(s) of the SDI (Master table). Up to three Keys uniquely identify each SDI. |
Yes |
| linkid | string | Link Id
Link Text describing the Detail Link specified by the SDCLink table. |
Yes |
| any desired column name | string | Column Name of Detail SDC
Since this Action adds a record to a Detail table, this Property adds a column to the record, and names the column using the column name you specify. You can add more than one column by specifying multiple column names and values (below). See the Example below. |
No |
| value | string | Value
Value of the column you have added (above) to the Detail table. |
No |
| applylock | string | Apply Lock
Determines whether data are locked or unlocked while the Action is processing. |
No |
|
Property Id |
Value |
Description |
| (return) | 1 | The Action has successfully executed. |
| >1 | The Action has not successfully executed. |
The Parameter List Item table is a Detail table that supports SDIs relevant to the Parameter List SDC, which is the Master table. To add a Parameter List Item to a Parameter List SDI, you could specify the following Properties:
| PropertyId | Property Value |
| sdcid | parameterlist |
| keyid1 keyid2 keyid3 |
paramlistid paramlistversionid variantid |
| linkid | paramlistitems |
| Define a Parameter List and a Parameter List Item by adding the following columns: | |
| paramlistid | ...as required |
| paramlistversionid | ...as required |
| variantid | ...as required |
| paramid | ...as required |
| paramtype | ...as required |
| replicateid | ...as required |