|
For catenated Insert instructions ('insert_ref', 'where_ent', 'where_ent2', 'execute') this command specifies the record of the second entity for the relational list. For this purpose a virtual widget is generated for the second entity of the relational list and the corresponding record is selected by means of the forwarded Where clause. |
||||||
![]() |
This command must not be called with a conditional instruction.
In contrast to the syntax for the 'where' command, the logical operator '|' (OR) must only be used in order to link Where clauses within a single field! If the command is not forwarded a parameter, - where_ent2() - no record is selected in the second entity. In this case also a new record is created in the second entity in addition to the record in the relational list! |
||||||
Syntax: |
|||||||
where_ent2({WHERE| } ) |
|||||||
I/O parameters:
|
|||||||
Return value: |
|||||||
|
|||||||
Example: |
|||||||
Declaration of Variables | |||||||
10 insert_ref("GROUP USER ASSIGNMENT") 20 var(EP_GRP_USR_ACC,EP_GRP_USR_DEF) 30 where_ent("T_GROUP.C_NAME" = EP_GROUP_NAME) 40 where_ent2("T_USER.C_NAME" = EP_USER_NAME) 50 DOCU_INT_1 = execute(1) |
|||||||
![]() |
Functions and commands: DB/Mask Interface |