Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Referential Integrity Disabling
Message
 
À
11/04/2002 02:11:57
Walter Meester
HoogkarspelPays-Bas
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00643457
Message ID:
00643658
Vues:
7
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform