A Flexible Method of Storing Control Data
By Tony Marston
2006-08-29
Summary
This design has the following advantages:
- Values can be added to or removed from the control table without having to
alter the structure of the table. The structure of the table remains static
while it is only the contents which are varied.
- Because individual values are held on totally separate records, individual
values can be locked without affecting other values.
- Because each value is held on a separate record it is easier for the table
to hold 1000's of records than it is for the table to contain 1000's of fields.
- By using a different value for
record_id it is possible to use
the same table for different sets of control data, such as for an individual
application instead of the whole system.
Tutorial Pages:
»
Introduction
»
A flexible approach
»
Implementation
»
From database to screen
»
From screen to database
» Summary
|
|
