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

 

In order to modify data from a master list the following functions and commands are used:

 

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:

 

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:

 

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