Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Referential integrity
Message
De
23/06/2004 03:39:27
Walter Meester
HoogkarspelPays-Bas
 
 
À
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:
00916304
Vues:
13
Hi denis,

You can use TaxRI (from the download section) to accomplish this.
You can use the _RiMode variable to force cascading updates or cascading deletes. See the remarks in the generated code.

BTW, TaxRi is far more efficient in producing Ri code. In large numbers of releations the size of Ricode might only be 10% of the VFP ri code.

Good luck,

Walter,


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

Click here to load this message in the networking platform