Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
I need to delete master related records without deleting
Message
From
17/01/2006 17:00:38
 
 
To
17/01/2006 16:25:16
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01087731
Message ID:
01087748
Views:
6
I know you said that this was against your rules in another message, but the only way I know to achieve this is to change your settings in the Referential Integrity Builder for your database. You can set the RI to either ignore the fact that there are children & delete anyways, delete the children WITH the master, or leave the behavior as it currently is, prohibiting the deletion of the master while children exist. Without modifying your data's referential integrity setup, I don't believe you can achieve what you are looking for.


>i need to delete master related records without deleting the child ones. is it possible?
>thanks in advance.
Paul A. Busbey
Victoria Insurance
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform