Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cascading Referential Integrity
Message
De
17/02/2011 12:04:12
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01499588
Message ID:
01500554
Vues:
52
>>
>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform