PRB: No Error Message When Creating a Cyclic RelationLast reviewed: December 12, 1995Article ID: Q141083 |
The information in this article applies to:
SYMPTOMSIn the Database Container (DBC), a table can be related to itself to create a cyclic relationship. No error message is displayed when the relation is drawn between two tags of the same table. On the other hand, the SET RELATION command returns an error message when a cyclic temporal relation is created.
CAUSEThe cyclic relation is not a correct "SET RELATION" relation, but is used in permanent relations for referential integrity purposes. Relational theory allows a table to be related to itself. For example, in an employee table, a whole division needs to be deleted. If the table is related to itself, you can use a cascade rule when deleting the whole division by deleting the division head.
STATUSThis behavior is by design.
MORE INFORMATION
Steps to Reproduce Behavior
|
Additional reference words: 3.00 3.00b VFoxWin
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |