Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Composite primary keys
Message
De
02/12/2004 11:21:23
 
 
À
02/12/2004 08:18:22
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00966059
Message ID:
00966421
Vues:
7
OK, I think I got the point now. After relations are created, VFP still does nothing at all to prevent entries breaking the foreign key rule. If I want a real foreign key, I must run the Referential Integrity Builder on my DB. Of course with the drawback that if I change something to the DB and forget to run the builder, I can create a disaster.
And if I read your article correctly, the other annoying thing is that the referential integrity builder will always disallow to set a field to null in the child table, even if the field is defined as nullable ; only the external TaxRI builder would allow this. Right ?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform