Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why use persistant relationships ?
Message
From
22/07/1999 14:03:53
 
 
To
22/07/1999 12:04:21
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00244805
Message ID:
00244876
Views:
17
Hi Pascal,

RI defined in a database in VFP is handled through stored procedure code that is generated automatically in the DBC. So, if you're not a fan of VFP stored procedures, it's not so good. What the RI procs do is delete or update child tables or bounce changes that may violate references and, maybe, create orphans.

I am inviting criticism here, but I simply refuse to use it. I have seen applications go into the mud speed-wise when cascading deletes, for example, were defined via RI.

>Recently when I started using an add-on that uses persistant relations, I've started using them. I was wondering as I didn't need them untill now what funtionallity they add to your database, except for the fact that these relations are proposed automatically when you create a view or a dataenvironment for a form (which I prefer to do myself ...). I know they're are used by the RI builder too (which I don't use ..), but what I want to know, are they only what is called meta data or does the database act different when they are defined ?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Reply
Map
View

Click here to load this message in the networking platform