LogiView

Combined Instructions: Insert (Using Virtual Widgets)

 

In order to ensure the referential integrity of a database, new records should only be inserted into the database table using so called virtual widgets.

The functions and commands provided by LogiView are based on this method and ensure that all required system attributes (creator, access rights, etc.) are defined and that all integrity checks are performed when creating new records.

When creating new records, you need to differentiate between entries to the

.

 

In order to add records to the master list the following functions and commands are used:

 

Example:

 
T Ln Cond/Act R 01
A 10 insert_ent("ORDER") yes
A 20 var(I_NO[1],P_NO[1],PRICE[1], USER[1]) yes
A 30 RC = execute(3) yes
 

In order to add records to a refine relation list the following functions and commands are used:

 

Example:

 
T Ln Cond/Act R 01
A 10 insert_ref("ITEM ORDER CUSTOMER") yes
A 20 var(K_PRICE,QUANTITY) yes
A 30 where_ent("ITEM.ITM_NO"= "4711") yes
A 40 where_ent2("ORDER.ORD_NO"=ORDER) yes
A 50 RC = execute(1) yes
 

In order to add records to a type list the following functions and commands are used:

 

Example:

 
T Ln Cond/Act R 01
A 10 insert_typ("ITEM DRAWING") yes
A 20 var(FORMAT,CREATOR) yes
A 30 where_ent("ITEM.ITM_NO"= "4711") yes
A 40 RC = execute(1) yes