Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Relations lost in a DBC
Message
From
22/02/2004 15:56:52
Larry Long
ProgRes (Programming Resources)
Georgia, United States
 
 
To
21/02/2004 04:53:22
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00879579
Message ID:
00879766
Views:
17
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform