Frame Construct MD3
With 'construct' we mean a syntactical form. It can be entered in a table action. In the subject will be a table-variable , in the example KB: first name from frame construct. In one or more action value cells comes the construct. Example:
FRAME(NAME(Person),IDENTIFIER((NAME(ID),VALUE(ID user))),VALUE(first name))
Here all parts are explained.
- First keyword NAME identifies the frame whose objects will be accessed.
- Keyword IDENTIFIER(( )) stands for the object to access. Between the double parentheses are two parameters around a comma:
- NAME identifies a frame-variable. This must be the primary key variable as specified in the frame's properties!
- VALUE holds the name of a table-variable. By user input or reasoning in surrounding tables it is supposed to receive a value that will be searched in the frame objects. It is a primary key value, so it selects one object (or none).
- Keyword VALUE at the right of the frame construct again identifies a frame-variable. Its value will be passed to the table-variable in the subject.
This is all with a frame having a simple primary key, being one frame variable. More complicated is a composite primary key. An example is a Dutch address formed by a postcode and a house number. This will be documented later. Meanwhile have attention that above IDENTIFIER has double parentheses. They are mandatory, also in case of a single primary key. In case of a composite key the form is like
IDENTIFIER((first)(second))