Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SDT calc field help with RI cascade update error ?
Message
From
20/12/1999 10:40:17
 
 
To
19/12/1999 13:50:48
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00305894
Message ID:
00306145
Views:
31
Hi Sylvia.

>I turned on RI, and it objects, "Cascade updates that are based on an expression-based index key may not behave as expected. The system has identified expression based keys in the following relationships."
>
> wellunit + wellinsp

It's best to avoid using compound (ie. more than one field) keys in joins between tables. Say WELLUNIT is the foreign key field to the other table. Create an index on it *and* create one on WELLUNIT + WELLINSP as your candidate key. Then, use the WELLUNIT tag for RI.

>Would SDT be useful by making a calculated field of this expression to fool RI?

No, because calculated fields don't actually exist; they're just an expression pre-defined in the meta data tables that you can use in various places by specifically asking for the expression property.

Doug
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform