Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Persistent Relationships
Message
From
07/07/2000 17:06:28
 
 
To
07/07/2000 12:23:12
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00388567
Message ID:
00389708
Views:
16
>>>>I set persistant relations in the DBC to handle Referential Integrity.
>>
>>>You mean making sure no orphans are created?
>
>>That is part of what RI does for you. It can also:
>
>>- Prohibit delete of parent if children exist
>>- Cascade delete so that children get deleted with parent
>>- Prohibit addition of child if no parent exists
>>- Change the foreign key in the child when the parent record changes
>
>Thanks Mr. Berntson. I was just checking to see if there was anything about PR that I was missing. You never know unless you hear it from an expert. :)

I wouldn't say I'm an expert...just another guy sharing his knowledge.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Reply
Map
View

Click here to load this message in the networking platform