Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Referential integrity
Message
De
22/06/2004 16:29:58
 
 
À
22/06/2004 15:56:20
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:
00916187
Vues:
8
>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
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform