LogiView

Command 'where_ent2'

     

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:

{WHERE} Where clause followed by the selection of the record in the list mask for the second 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