Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Referential integrity
Message
From
23/06/2004 03:39:27
Walter Meester
HoogkarspelNetherlands
 
 
To
22/06/2004 15:56:20
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00916179
Message ID:
00916304
Views:
12
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.
Previous
Reply
Map
View

Click here to load this message in the networking platform