Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Referential Integrity Disabling
Message
 
To
11/04/2002 07:33:33
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00643457
Message ID:
00643660
Views:
5
Thanks for the info.... I was able to figure out what I had to do. Basically I used a DELETE TRIGGER in the code to shut it down while executing the code.

Tommy

>>Hi folks...
>>
>>Is there an easy way to temporarally disable Referential Integrity in a Database Container (for certain tables)?
>>
>>I mean, if there is RI code in the Stored Procedures (generated by the Internal RI builder), like __RI__DELETE_orders...
>>
>>and I want to delete Orders and the Order Items MYSELF, without going through the slow RI code, how can I tell Foxpro NOT to use the RI code... let me do it myself, then when done, have the RI code turned back on like it was before?
>>
>>Thanks!
>>Tommy
>
>Use TaxRI instead of the standard RI. Walter Meester's claims are no overstatement.
Tommy Tillman A+ NetWork+ MCP
Previous
Reply
Map
View

Click here to load this message in the networking platform