Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Surrogate Keys - Have I got the right idea
Message
From
11/01/2001 13:03:16
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00434523
Message ID:
00462391
Views:
18
>But what about all the Orphans and Widows? *really big grin*

With surrogates, those would only happen on a Delete, which you can restrict or cascade via RI too. I'd rather put the over head on a delete instead of on an update. Besides, if the RI barfs, I'd rather it widow or orphan a deleted record then something I'm still tyring to use.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform