Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
RI
Message
De
09/03/2001 13:11:23
 
 
À
09/03/2001 11:25:47
Chuck Tripi
University of Wisconsin - Milwaukee
Milwaukee, Wisconsin, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Re: RI
Divers
Thread ID:
00483541
Message ID:
00483598
Vues:
8
Hi Chuck.

>In the Database Designer, there is no links between any tables, but in the Stored Procedures, there is a big section of "DO NOT REMOVE" code for the RI?

This sounds like you had persistent relations at one time and used them to generate the RI code, but they've gone AWOL. The most likely reason for that is using DELETE TAG ALL before INDEX ON to recreate indexes. While that's the correct approach, it has the downside of eliminating all the persistent relations for the table being reindexed.

>All I want to do is edit (or add for that matter) the update thing.

Since persistent relations are only used to generate the code at development time and not at runtime, you can change the stored procedure manually if you wish. However, a better approach is to take the time to recreate the missing relationships.

> What is happening? I can not even click-and-drag the fields in the DD.

You can only drag from indexes, not fields, since persistent relationships (unlike temporal ones such as those in the DataEnvironment of a form or report) are based on indexes, not fields.

Doug
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform