LogiView

Command 'var'

     

This command is used to determine the fields in the list mask written in a catenated Update resp. Insert instruction ('update_ent/update_ref/update_typ' resp. ' insert_ent/insert_ref/insert_typ', 'var', ' where_ent', ' where_ent2', ' execute') or to be read in case of a catenated Select instruction ('select_ent/select_ref/select_agg/select_typ', 'where_ent', 'where_ent2', 'where', 'exec_select', 'exec_update').

This command must not be called with a conditional instruction.
  For Insert instructions for relational lists ('insert_ref') it is also possible to call 'var' without variable specification. If the 'where_ent2' command is used to uniquely specifiy a record for the second entity of the relational list, only the relation is defined in this case but no edge attribute (field in the relational list) is written!
 

Syntax:

  var({VAR_LIST})
 

I/O parameters:

{VAR_LIST}

List of variables with values to be written to the list mask. For the specified variables a database access must be defined (in the mask variable list) describing the allocation of a variable to a certain table field.

In this case, the specification of a Where clause in the database access definition of the variable is ignored. For a catenated Insert instruction the commands 'where_ent' and 'where_ent2' are available for this purpose.

The database access of the forwarded variables (with no limitation of the number) is used to determine which list mask fields are to be written.

The database access of the specified varaibles must be related to the (hidden or visible) fields in a single list mask.

-  
 

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