|
When changing, inserting, or selecting data from a relational list (catenated Update resp. Insert instruction: 'update_ref' resp. 'insert_ref', 'where_ent', 'where_ent2', 'execute' or catenated Select instruction: 'select_agg'/'select_ref', 'where_ent', 'where', 'execute') this command specifies the parent of the relational list. When inserting data into a relational list (catenated Insert instruction: 'insert_typ', 'where_ent', 'execute') this command specifies the master table record to be extended with the specified type attribute. For this purpose a virtual widget is generated for the first entity of the relational/type list and the corresponding record is determined 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! |
||||||
Inserting in type list only ('insert_typ'): If the command is not forwarded a parameter, - where_ent() - no record is selected in the first entity. In this case also a new record is created in the first entity in addition to the record in the type list! |
|||||||
Syntax: |
|||||||
where_ent({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 |