#

# LogiView

## Combined Instructions: Update (Using Virtual Widgets)

| In order to ensure the referential integrity of the databse, modification of existing records should only be done through virtual widgets. LogiView proves commands and functions using this processing method, thus ensuring that access rights are checked, system attributes (such as change dates) of modified records are updated and all integrity checks are performed. When modifying records, you need to differentiate between records of a Master List, Refined Relation List, or Type List.
| In order to modify data from a master list the following functions and commands are used: command 'update_ent' command 'var' command 'where' integer function 'execute'
| ### Example:
T | Ln | Cond/Act | R 01
A | 10 | update_ent("ORDER") | yes
A | 20 | var(PRICE[1],USER[1]) | yes
A | 30 | where("ORDER.ORD_NO"=ORDER) | yes
A | 40 | RC = execute(3) | yes
| In order to modify data from an refine relation list the following functions and commands are used: command 'update_ent' command 'var' command 'where_ent' command 'where' integer function 'execute'
| ### Example:
T | Ze | Bed/Akt | R 01
A | 10 | update_ref("ITEM ORDER CUSTOMER") | yes
A | 20 | var(S_PRICE,QUANTITY) | yes
A | 30 | where_ent("ITEM.ITM_NO"= "4711") | yes
A | 40 | where("ORDER.ORD_NO"=ORDER) | yes
A | 50 | RC = execute(1) | yes
| In order to modify data from a type list the following functions and commands are used: command 'update_typ' command 'var' command 'where' integer function 'execute'
| ### Example:
T | Ze | Bed/Akt | R 01
A | 10 | update_typ("ITEM DRAWING") | yes
A | 20 | var(FORMAT) | yes
A | 30 | where("ITEM.ITM_NO"="4711") | yes
A | 40 | RC = execute(1) | yes