Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Skip record in child table
Message
From
11/11/2003 04:58:34
 
 
To
10/11/2003 05:53:57
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00848202
Message ID:
00848624
Views:
16
Hi Boban,

------------
I have Form with Parent and Child table linked with Relation.
When I do SKIP 1 for child table it moves to next record regardless of a relation with a parent table.
I want to do SKIP in Child table only with records that are related to Parent table.
How?

If you want skip the Parent-Child tables like a LEFT JOIN, use this:
SELECT Parent
SET RELATION TO eOnParent INTO Child
SET SKIP TO Child
Now, SKIP 1 on Parent, VFP cycle on child, and only when a EOF('child') occur VFP SKIP on Parent;
if you want a true SKIP on Parent, do:
GO BOTTOM ON Child
SKIP 1 IN Parent
Fabio
Previous
Reply
Map
View

Click here to load this message in the networking platform