|
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:
|
|||||||
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 |