add to table cache()
Adds a new entry to the Table Cache a (if fewer values are specified than there are columns in the cache, the remaining columns are filled with empty strings "").
The return value of the function is a.
Parameters
Parameter |
Description |
a |
Name of the cache. Important note: If the cache does not exist, the function terminates with an error. |
b |
Value for column 1 (= primary key) of the cache. |
c...k |
Values for further columns. |
Example
First, a table cache was created using the function "create table cache()" and the following parameters.
Parameter a |
Parameter b |
Parameter c |
Parameter d |
article |
id |
name |
supplier_Id |
After that, the function described here is called to add an entry.
Parameter a |
Parameter b |
Parameter c |
Parameter d |
article |
100 |
mobile phone |
4711 |
Following the content of cache article.
id |
name |
supplier_Id |
100 |
mobile phone |
4711 |