create table cache()
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).