Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Referential Integrity Disabling
Message
 
À
11/04/2002 07:33:33
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
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:
00643660
Vues:
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.

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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform