#

# 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 Master List, Refined Relation List, or Type List .
| In order to add records to the master list the following functions and commands are used: command 'insert_ent' command 'var' integer function 'execute'
| ### 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: command 'insert_ref' command 'var' command 'where_ent' command 'where_ent2' integer function 'execute'
| ### 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: command 'insert_typ' command 'var' command 'where_ent' integer function 'execute'
| ### 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