Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Referential Integrity Disabling
Message
 
To
11/04/2002 02:11:57
Walter Meester
HoogkarspelNetherlands
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00643457
Message ID:
00643658
Views:
6
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.

I appreciate the help!!

Tommy


>Hi tommy,
>
>Look at my TaxRiBuilder available from the download section. It produces far cleaner and more compact RI code, is more flexible (you can temporarely switch off RI), and way faster than the standard RI code.
>
>Walter,
>
>...
>>
>>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
Tommy Tillman A+ NetWork+ MCP
Previous
Reply
Map
View

Click here to load this message in the networking platform