Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Relations lost in a DBC
Message
De
22/02/2004 15:56:52
Larry Long
ProgRes (Programming Resources)
Georgie, États-Unis
 
 
À
21/02/2004 04:53:22
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00879579
Message ID:
00879766
Vues:
18
Pat,
Are you setting your relationships programatically? If so, make sure that you use the ADDITIVE clause if multipe relationships need to be set, other wise the SET RELATION will drop any current relationship.

HTH

>Hi All,
>
>I have a strange problem at hand here. It seems that some of the relations involved in a DBC get lost when I modify some tables.
>
>This is a 50 tables DBC, in which there are many relations between the tables. For example I have a PROJECTS table and a CUSTOMERS table. Both table are linked with a CUST_ID field (a project is linked to a customer).
>
>If I update say another table in the system (the MODULES table for example), I suddenly lose the relation that once linked the PROJECTS and CUSTOMERS table together.
>
>Is this a known problem and is there any way to prevent this from happening?
>
>Thank you.
>
>Pat
L.A.Long
ProgRes
lalong1@charter.net
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform