Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cascading Referential Integrity
Message
From
17/02/2011 12:04:12
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01499588
Message ID:
01500554
Views:
53
>>
>>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.

(1) it won't let you generate code if the database is not packed
(2) I always use 'Clean up database' in the menu
Gregory
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform