Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Programmatically change persistent relation settings
Message
From
25/02/2004 17:34:44
 
 
To
21/02/2004 02:18:24
Larry Long
ProgRes (Programming Resources)
Georgia, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00879555
Message ID:
00880926
Views:
21
Hi Larry.

>Request adding the capability to programmatically add or alter the Referentical Integrity settings on persistent relationships. For example, if I want to change the RI Delete setting from none to cascade, the only way I can do it now it through the RI builder. Please see the suggested command mods below...

Unfortunately, that won't work because VFP uses procedural RI rather than declarative. However, you should look at a replacement for VFP's RI code written by Steve Sawyer and published in "Effective Technique for Application Development", a book written by him and Jom Booth and available from Hentzenwerke Publishing (www.hentzenwerke.com or Amazon). It doesn't use hard-coded code but is instead data-driven. So, when you change the RI settings (which you still have to do by writing directly to the DBC), you're done.

Doug
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform