Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement