Doug,
I disagree. It is decarative beacause you can currently esatblish a persisten relationship via a PRIMARY KEY or FOREIGN KEY clause in the CREATE or ALTER TABLE command. If VFP can create a persistent relationship programmatically via the FOREIGN KEY clause, then there is no reason they couldn't add an additional clause to modify that relationship. All it would have to do is set one of 3 bytes in the DBC with the desired RI setting.

Thanks for your input. I'll see if I can check out the reference.

>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