Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SDT calc field help with RI cascade update error ?
Message
De
20/12/1999 10:40:17
 
 
À
19/12/1999 13:50:48
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00305894
Message ID:
00306145
Vues:
30
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform