|
Whenever you insert
supertype or subtype data, this affects the entire record
constellation (the supertype data and all corresponding subtype
data).
You can insert new subtype
data:
|
·
|
By using a window or info box based on the subtype table. The
supertype attributes will also be shown. |
|
·
|
By using a window based on the supertype table. In this case,
select the appropriate subtype indicator(s). You can access the
subtype windows by clicking the list buttons provided for each
subtype. |
|
·
|
Indirectly, by issuing an |
INSERT INTO <subtype>
or an
UPDATE <supertype> SET <subtype
indicator> = 'Y'
statement. This statement
could be issued from a constraint.
In all cases you need to
provide values for any mandatory subtype columns.
If the record constellation is
subject to one or more totality rules, you are allowed to insert a
new supertype record only if you also set the necessary subtype(s)
and provide values for its mandatory columns.
If the record constellation is
subject to one or more exclusivity rules, you are allowed to add
subtype data only if this does not violate these rules.
How USoft Developer handles
new subtype data added to existing supertype data depends in part
on the Update Supertype on Insert deployment configuration
parameter setting in the Authorizer.
|
