Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How Do I set Relations
Message
De
28/01/1999 18:37:30
 
 
À
28/01/1999 18:29:36
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00181595
Message ID:
00181597
Vues:
7
>1. I have a DBC in VFP5 with about 15 tables. I cannot find how to set relations in the DBC as has been done in the sample Tastrade DBC( with the lines signifying the relationship). Neither Help nor the manual tell me how.

Firstly, there are two types of relations: permanent and temporary. Permanent relations are used for RI-triggers and can be set in Modify Database builder: select primary key index in one table (parent) and drag it onto foreign key index in another table. Temp relations can be set either in DataEnvironment or programmatically by SET RELATION command. It's question of design approach what relations, if any, are reasonable to use. IMO, permanent relations are useful and temp ones are unnecessary.
Edward Pikman
Independent Consultant
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform