Creates a table cache with the name a, the primary key b and the further columns c to k.
The return value of the function is a.
Parameters
Parameter | Description |
|---|---|
a | Name of the Table Cache. |
b | Name of the first column (primary key). |
c...k | (optional) Names of further columns. |
Examples
Parameter a | Parameter b | Parameter c | Parameter d | Result |
|---|---|---|---|---|
article | id | name | supplier_Id | article |
Creates a Table Cache with name article, the column containing the primary key with name id and two other columns named name and support_Id.
Parameter a | Parameter b | Parameter c | Parameter d | Result |
|---|---|---|---|---|
supplier | id | supplier_name | supplier_country | article |
Creates a Table Cache with name supplier, the column containing the primary key with name id and two other columns named supplier_name and supplier_country.
References
Character > is used to specify references to other Table Caches.
Parameter a | Parameter b | Parameter c | Parameter d | Result |
|---|---|---|---|---|
article | id | name | supplier_Id>supplier | article |
The column supplier_Id references to the Table Cache with the name supplier. This definition is the prerequisite for later retrieving referenced values with the function get value from table cache() (see there).