Enterprise Communication Interface (ECI)

eci_ins_rel

Description

Insert record in a relation list.

  • Opens mask of entity 1 and selects parent record.
  • Opens mask of entity 2 and selects child record.
  • Opens relation list.
    • Write fields 'ins_fld_nam'.
    • User can modify and insert values in interactive mode.
    • Calls fields and mask triggers.
    • Stores record.
    • Returns values of return field.
  • Close masks.

 

Input parameter

fat_ent_nam

string name of entity 1 ("father")

fat_wdg_nam

string name of mask of entity 1

fat_wdg_ext

string activate system fields on list of entity 1 {"on", "off"}

fat_wdg_mod

string mode of widget of entity 1 {"list","form","bvb"}

res_flag

string allow insert only if parent record is reserved {"on","off","reset"}

act_mod

string mode of interaction {"int","bat"}

fat_sel_nam

stringlist names of fields for selection of parent record

fat_sel_val

stringlist values of fields for selection of parent record

son_ent_nam

string name of entity 2 ("son")

son_wdg_nam

string name of mask of entity 2

son_sel_nam

stringlist field names of child record

son_sel_val

stringlist Field values of child record

rel_vie_nam

string view name of relation

rel_ref_agg

string direction of relation {"ref", "agg"}

rel_wdg_nam

string name of relation list

rel_wdg_ext

string activate system fields on relation list {"on", "off"}

rel_wdg_mod

string mode of relation widget {"list","form","bvb"}

ins_fld_nam

stringlist names of fields to write

ins_fld_val

stringlist values of fields to write

ret_fld_nam

stringlist names of return fields

Output parameter

ret_fld_val

stringlist values of return fields

 

Example

Insert an item-document relation record

Input parameter:

fat_ent_nam "EDB-ARTICLE"
fat_wdg_nam "EDB-ART-SLI"
fat_wdg_ext "off"
fat_wdg_mod "list"
res_flag "off"
act_mod "int"
fat_sel_nam "T_MASTER_DAT.PART_ID"
fat_sel_val "art001"
son_ent_nam "EDB-DOCUMENT"
son_wdg_nam "EDB-DOC-SLI"
son_sel_nam "T_DOC_DAT.DOCUMENT_ID"
 
"T_DOC_DAT.DOC_TYPE"
son_sel_val "drw001"
 
"DRAWING"
rel_vie_nam "STR"
rel_ref_agg "ref"
rel_wdg_nam "EDB-ART-DOC-RLI"
rel_wdg_ext "off"
rel_wdg_mod "list"
ins_fld_nam "T_MASTER_DOC.POS_NO"
ins_fld_val "10"
ret_fld_nam "T_MASTER_DOC.C_ID"
 
"T_DOC_DAT.C_ID"