Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Referential integrity
Message
De
22/06/2004 16:32:49
 
 
À
22/06/2004 16:29:58
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00916179
Message ID:
00916189
Vues:
11
Thanks Al,

I already had NewRi from Steve Sawyer. So I guess that there could be some dirty work for me playing in there.



>>VFP7 SP1
>>
>>Perhaps the topic has already been covered here before.
>>
>>Would it be possible in my App to process the deletion of records based on the user level?
>>
>>I mean if the user is the administrator and he wants to delete something then I do a cascade delete. If the user is not the administrator then I don't let him delete a thing if the referential integrity code determines that there are links elsewhere.
>
>RI code is just Fox code, you can modify it to do anything you want. You could just wrap the existing cascaded delete function.
>
>One thing to be careful of, if you let Fox re-generate RI code your changes might get overwritten.
>
>I understand Steve Sawyer has some replacement RI code that might be worth looking at: http://www.stephensawyer.com/content/ricode.htm
*******************************************************
Save a tree, eat a beaver.
Denis Chassé
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform