Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set skip to
Message
From
11/07/2000 09:27:47
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Set skip to
Miscellaneous
Thread ID:
00390694
Message ID:
00390694
Views:
39
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
Next
Reply
Map
View

Click here to load this message in the networking platform