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

Click here to load this message in the networking platform