Bookshelf Home | Contents | Index | Search | PDF

Siebel Tools Reference > Business Objects Layer > Links >

Cascade Delete Property

---

The Cascade Delete property in a Link object definition indicates what action to perform on detail business component records of the link if the master record is deleted. The following three values are available for this property:

CLEAR. If CLEAR, the foreign key reference is removed if the master record is deleted, but the detail records remain in place.
DELETE. If DELETE, the detail records are deleted along with the master.
NONE. If NONE, no operations are performed on the detail record in response to deletion of the master, and the foreign key reference is not removed.

CAUTION:  Do not use DELETE if the child business component in this link is also a detail business component in another link. In this case, you use CLEAR instead.

Cascade Delete is not available for many-to-many links. With a many-to-many link, Siebel applications will automatically delete the intersection record but will leave the child record intact, as it may have other parents.

When you delete a record which is pointed to by foreign keys of other tables, the references to it may or may not be deleted. If those references are not deleted, the user is left with row IDs which point to nonexistent records. In the case of multi-value groups, sometimes these foreign keys will be converted to say "No Match Row Id."

Bookshelf Home | Contents | Index | Search | PDF