Managing database controls

The data manipulation functions at spin2000.net/spinmy/ in the SPIN data control panel are made by generic programming and the specifications are held in database tables and thus makes it possible to add or change the functions when need arises.

Four general functions are available:

1. Add or remove “-” from any field
2. Use static data and the content of a specific field to generate content in another field
3. Control the content of any field for existence in another table and generate resulting files (csv) with missing values.
4.  Execute some sql select statement and download the found set: This is used for generating the tables of data delivery data outside +/- 20 pct of the average data for all years.

The controls are listed in the database table tablecontrol and the corresponding specifications are found in the table tabletreat.

See the full documentation on each function in separate articles.