Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Referential integrity
Message
From
21/05/2001 17:59:15
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Title:
Referential integrity
Miscellaneous
Thread ID:
00509701
Message ID:
00509701
Views:
40
has anyone else observed the following:

1) create an app using the quickstart following all directions.
2) open the database exclusively
3) open the database designer - there are relationship links between the users table and usgrlink table and between the group table and the usgrlink table
4) try to edit the referential integrity, the first time thru, it says to clean up the database, do that, then when you get to edit the RI, all the rules between these tables say Ignor. If you save this, it wipes out the following RI code:

__ri_delete_groups
__ri_insert_usgrlink
__ri_update_groups
__ri_update_usgrlink

which I assume the framework needs in order to properly manage the user lists. I haven't followed the code all the way thru to figure out if these are restrict, or cascade, but I think I can safely assume they aren't ignor. I'm using VFP 6 service pack 4, Mere Mortal 6.0b and Stonefield (which I figure isn't a factor, but just to be on the safe side, I'll list it).

Have I done something strange? thanks!
Reply
Map
View

Click here to load this message in the networking platform