Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hello:
I am setting up relations within a transaction. The code executed is:
SELECT primpdat
SET RELATION TO lang_Pref INTO pkLabel ADDITIVE
SET RELATION TO cheque_id INTO coll1 ADDITIVE
This creates two relations properly with primpdat being the parent table ( Doing a ? set('relation') returns the two relations at this point).
However when I try to execute (the next line):
SET SKIP TO coll1
I get the following error message:
"Coll1 is not related to the current work area". All three cursors are in the same data session. Both relations are on numeric fields (I do not use an index here because indexes are not allowed within a transaction).
What does this message mean, and how do I fix this so I have a 1 to many relationship?
Thanks
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