#

# LogiView

## Command 'where_ent'

| 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:
| {WHERE} | Where clause followed by the selection of the record in the list mask for the first entity.
| - |
| ### 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