Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Referential integrity
Message
From
22/06/2004 16:32:49
 
 
To
22/06/2004 16:29:58
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00916179
Message ID:
00916189
Views:
12
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é
Previous
Reply
Map
View

Click here to load this message in the networking platform