Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cascading Referential Integrity
Message
 
 
To
17/02/2011 11:18:39
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01499588
Message ID:
01500544
Views:
47
>
>There must be relationships established ( when you create table .... foreign key)
>If no relationships are established, you can add them in Modify database
>
>Click on a PK from a table and drag that to a FK of the related child table - then you will see the (new) relationship (line)
>
>When you have all your relationships, then do the right click - Edit referential integrity
>When you are done with that it will ask whether you want the code generated

One important tip before editing Referential Integrity (at least it was important in VFP9 SP1):

PACK DATABASE myDB
COMPILE Database MyDB

(backup also will be good)

and then you can use it. Otherwise there is a potential for Internal Consistency Error.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform