Book a Demo

Author Topic: Cascade Update - where is it?  (Read 2483 times)

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 8626
  • Karma: +259/-129
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Cascade Update - where is it?
« on: March 08, 2007, 06:17:41 pm »
Before I report a bug, does anyone know where I can specify Cascade Update on a DB Relation?  I can specify (only partly) Cascade Delete.

Normally, these are specified as actions on both the destination (parent) end and the origin (child) end.

You can specify:
Insert, Update and Delete actions

Normally from the set of:
None, Restrict, Cascade, Set Null

NOTE: Not all the above actions are available for all types

This metadata is used to control the types of triggers or declarative referential integrity to be generated.

Thoughts? Votes?

Paolo

[size=10]PS: To clarify, here's one product's definition of the actions:
Restrict - Verifies the existence of foreign key values in the parent table's primary key and prevents the insertion, updating, or deleting of data if the values cannot be validated.
Cascade - Propagates any modification of a primary key value to the corresponding foreign key values in the child table.
Set Null - Verifies the existence of the foreign key values in the parent table's primary key. If the values cannot be validated, the trigger sets the foreign key values to null in the child table and lets the data modification operation proceed. [/size]
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!