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