Updating supertype and subtype data

Previous Next

Existing supertype-subtype record constellations may be updated in three ways:

Supertype values are changed.

Subtype values are changed.

New subtypes are selected for an existing supertype, or existing subtypes are de-selected.

Subtypes are selected or de-selected for an existing supertype by:

Selecting or clearing subtype indicators (check boxes).

Inserting or deleting records in windows based on the subtype table.

Indirectly, by executing one of the following SQL statements:


DELETE FROM subtype 

 Such a statement could be executed from a constraint.


These manipulations are treated as UPDATEs to the record constellation. Transitional constraints defined on the record constellation are evaluated if the Fire On Update flag is set.

A possible exception is adding new subtype data to an existing supertype constellation. If this new data is inserted through a window based on the subtype, or inserted indirectly through a constraint, it is handled as INSERT rather than UPDATE if the Update Supertype on Insert deployment configuration parameter in the Authorizer is set to No.


See also

Inserting supertype and subtype data

Deleting supertype and subtype data

Understanding subtype behaviour